> 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 

Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to