Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 548829FA280
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 29 Dec 2006 14:04:03 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024)
	with ESMTP id 55765-01 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 29 Dec 2006 14:03:57 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from web36104.mail.mud.yahoo.com (web36104.mail.mud.yahoo.com
	[66.163.179.218])
	by postgresql.org (Postfix) with SMTP id 2FE359F9F47
	for <pgsql-performance@postgresql.org>;
	Fri, 29 Dec 2006 14:03:57 -0400 (AST)
Received: (qmail 31524 invoked by uid 60001); 29 Dec 2006 18:03:56 -0000
Message-ID: <20061229180355.31522.qmail@web36104.mail.mud.yahoo.com>
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.ar;
	h=X-YMail-OSG:Received:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
	b=mpNkp4AjxfOqeT4GlDywqFj9Pb/JIwV+tCLuvK2UtdutsR3FXiZYtV2ST0mg9uELz9Xjl91SfdSD8H1ocPsG1AAgq3v5EBXNR31nW3rXEOnulpH2nKBHg93CkYH3A5tL/b0hKfCd0t82qtqWLddPwf4gQh6Jnp0dFJKUcMNwhl0=;
X-YMail-OSG: 
 GKd0FKwVM1mzdAWsSNHZvBKSRyIli42stjhoBdLgkXwt3LrVwqIBu0wTrLOPm3krvA--
Received: from [200.49.144.50] by web36104.mail.mud.yahoo.com via HTTP;
	Fri, 29 Dec 2006 18:03:55 GMT
Date: Fri, 29 Dec 2006 18:03:55 +0000 (GMT)
From: =?iso-8859-1?q?Sebasti=E1n=20Baioni?= <sebaioni-postgresql@yahoo.com.ar>
Reply-To: sebaioni-postgresql@yahoo.com.ar
Subject: Re: Backup/Restore too slow 
To: Performance PostgreSQL <pgsql-performance@postgresql.org>
In-Reply-To: <14012.1167414246@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-257543033-1167415435=:30872"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.865 tagged_above=0 required=5 tests=AWL, BAYES_50,
	HTML_30_40, HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200612/533
X-Sequence-Number: 22589

--0-257543033-1167415435=:30872
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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@sss.pgh.pa.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
--0-257543033-1167415435=:30872
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Thanks for answering.<br>This is my configuration:<br># - Memory -<br><br>shared_buffers = 1000&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # min 16, at least max_connections*2, 8KB each<br>#work_mem = 1024&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # min 64, size in KB<br>#maintenance_work_mem = 16384&nbsp;&nbsp;&nbsp; # min 1024, size in KB<br>#max_stack_depth = 2048&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # min 100, size in KB<br><br>The PC where we are runing PostgreSQL server is:<br>AMD Athlon(tm) 64 Processor<br>3000+<br>1.79 GHz, 1.93 GB RAM<br>with WindowsXP Proffesional, Version 2002 Service Pack 2.<br><br>How should we set it?<br><br>Thanks a lot!<br>&nbsp;&nbsp;&nbsp;&nbsp; Sebastián<br><br><b><i>Tom Lane &lt;tgl@sss.pgh.pa.us&gt;</i></b> escribió:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> Rod Taylor <rod.taylor@gmail.com> writes:<br>&gt; Rebuilding the indexes or integrity confirmations are probably
 taking<br>&gt; most of the time.<br><br>&gt; What is your work_mem setting?<br><br>maintenance_work_mem is the thing to look at, actually.  I concur that<br>bumping it up might help.<br><br>   regards, tom lane<br><br>---------------------------(end of broadcast)---------------------------<br>TIP 2: Don't 'kill -9' the postmaster</rod.taylor@gmail.com></blockquote><p>&#32;__________________________________________________<br>Correo Yahoo!<br>Espacio para todos tus mensajes, antivirus y antispam ¡gratis! <br>¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar
--0-257543033-1167415435=:30872--