Config settings for large restore

Hi,

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 the
bgwriter (I'm thinking this should just follow the checkpoint and
shared_buffers settings)?  I realize that the actual setting will be
hardware dependent, I'm just looking for general rules of thumb for
what to tweak wrt increased restore speed/performance.


Erik Jones

Software Developer | Emma®
erik@myemma.com
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