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