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

Re: speed up restore from dump

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Alan Hodgson <ahodgson(at)simkin(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: speed up restore from dump
Date: 2008-10-30 20:17:15
Message-ID: 20081030201715.GM3857@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-general
Alan Hodgson wrote:
> On Thursday 30 October 2008, Joao Ferreira gmail 
> > During restore:
> > # vmstat
> > procs --------memory------- ---swap-- -----io---- -system-- ----cpu----
> > r  b   swpd   free   buff  cache   si  so   bi   bo  in  cs us sy id wa
> > 3  1 230204   4972   1352 110128   2    1   17   63  24  56 12  2 85  0
> > #
> 
> Does that machine really have only 256MB of RAM? And it's over 200MB into 
> swap? 

Huh, if that's the case then you should drop maintenance_work_mem a lot
(and not increase work_mem too much either), because having it high
enough that it causes swapping leads to worse performance.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

pgsql-general by date

Next:From: Joao FerreiraDate: 2008-10-30 20:19:37
Subject: Re: speed up restore from dump
Previous:From: Tom LaneDate: 2008-10-30 20:13:29
Subject: Re: array_cat null reasoning

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