Thanks, we're at 128 now but I'll see how bumping that up goes.
On Nov 28, 2007, at 9:46 AM, Vivek Khera wrote:
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
Erik Jones
Software Developer | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
