Re: Config settings for large restore

On Nov 27, 2007, at 3:30 PM, Erik Jones wrote:

> I'm just wondering what is considered the general wisdom on config
> setting for large pg_restore runs.  I know to increase
> maintenance_work_mem and turn off autovacuum and stats collection.
> Shoule should checkpoint_segments and checkpoint_timeout be
> increased?  Would twiddling shared_buffers help?  What about

At least with 8.0 testing I did a while back, I found that bumping
checkpoint segments was the biggest benefit.  I use 256 segments as a
matter of course now, even for normal operations.



=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                MailerMailer, LLC     Rockville, MD
http://www.MailerMailer.com/                     +1-301-869-4449 x806