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
maintena
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_time
On Tue, 27 Nov 2007, Erik Jones wrote:
> I'm just wondering what is considered the general wisdom on config setting
> for large pg_restore runs.
I think the first thing you can do is to "fsync=off" temporarily. But
do remember to turn this back on when you're done restoring.
Regards
Tometzky
--
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_
