Horton

Re: pg_restore taking 4 hours!

Josh Berkus <josh@agliodbs.com>

View thread
From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Cc: Vivek Khera <khera@kcilink.com>
Date: 2004-12-13T18:25:54Z
Lists: pgsql-performance 
Vivek,

> The biggest improvement in speed to restore time I have discovered is
> to increase the checkpoint segments.  I bump mine to about 50.  And
> moving the pg_xlog to a separate physical disk helps a lot there, too.

Don't leave it at 50; if you have the space on your log array, bump it up to 
256.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco