Hervé Piedvache wrote:
Josh,
Le mercredi 14 Juillet 2004 18:28, Josh Berkus a écrit :
checkpoint_segments = 3
You should probably increase this if you have the disk space. For massive insert operations, I've found it useful to have as much as 128 segments (although this means about 1.5GB disk space)
Other point I have also read this : "NOTE: Since 7.2, turning fsync off does NOT stop WAL. It does stop checkpointing."
So ... still true for 7.4.3 ??? So I'm with fsync = off so the value of checkpoint_segments have no interest ??
Thanks for your help...
I suggest you check this first. Check the performance tuning guide..
http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php
That is a starters. As Josh suggested, increase checkpoint segments if you have disk space. Correspondingly WAL disk space requirements go up as well.
HTH
Shridhar
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html