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