From: | Erik Jones <erik(at)myemma(dot)com> |
---|---|
To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Config settings for large restore |
Date: | 2007-11-27 20:30:27 |
Message-ID: | DA6FD8EC-478E-4F7F-9D54-3E8774BCFD77@myemma.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)myemma(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Brendan Jurd | 2007-11-27 21:53:42 | Re: [GENERAL] Empty arrays with ARRAY[] |
Previous Message | Cyril VELTER | 2007-11-27 18:59:34 | Unknown winsock error 10061while dumping a big database |