Skip site navigation (1) Skip section navigation (2)

Re: Backup/Restore too slow

From: Sebastián Baioni <sebaioni-postgresql(at)yahoo(dot)com(dot)ar>
To: Performance PostgreSQL <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Backup/Restore too slow
Date: 2006-12-29 18:03:55
Message-ID: 20061229180355.31522.qmail@web36104.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-performance
Thanks for answering.
This is my configuration:
# - Memory -

shared_buffers = 1000        # min 16, at least max_connections*2, 8KB each
#work_mem = 1024        # min 64, size in KB
#maintenance_work_mem = 16384    # min 1024, size in KB
#max_stack_depth = 2048        # min 100, size in KB

The PC where we are runing PostgreSQL server is:
AMD Athlon(tm) 64 Processor
3000+
1.79 GHz, 1.93 GB RAM
with WindowsXP Proffesional, Version 2002 Service Pack 2.

How should we set it?

Thanks a lot!
     Sebastián

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> escribió: Rod Taylor  writes:
> Rebuilding the indexes or integrity confirmations are probably taking
> most of the time.

> What is your work_mem setting?

maintenance_work_mem is the thing to look at, actually.  I concur that
bumping it up might help.

   regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
 __________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis! 
¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar

In response to

Responses

pgsql-performance by date

Next:From: Simon RiggsDate: 2006-12-29 18:18:18
Subject: Re: URGENT: Out of disk space pg_xlog
Previous:From: Tom LaneDate: 2006-12-29 17:44:06
Subject: Re: Backup/Restore too slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group