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 

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...
Bill Footcow

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Reply via email to