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.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to