Re: Insert are going slower ... - Mailing list pgsql-performance

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