On Thu, 22 Apr 2004, Sean Shanny wrote:
> I should have included this as well:
> fsync | on
> shared_buffers | 4000
> sort_mem | 64000
For purposes of loading only, you can try turning off fsync, assuming this
is a virgin load and you can just re-initdb should bad things happen (OS,
postgresql crash, power plug pulled, etc...)
Also increasing sort_mem and shared_buffers might help. Especially
sort_mem. But turn it back down to something reasonable after the import.
And turn fsync back on after the import too. Note you have to restart
postgresql to make fsync = off take effect.