Re: Insert are going slower ...

From: Hervé Piedvache <footcow(at)noos(dot)fr>
To: pgsql-performance(at)postgresql(dot)org
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, Hervé Piedvache <herve(at)elma(dot)fr>
Subject: Re: Insert are going slower ...
Date: 2004-07-14 21:32:05
Message-ID: 200407142332.05161.footcow@noos.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Patrick Hatcher 2004-07-14 22:36:46 Re: vacuum full 100 mins plus?
Previous Message Patrick Hatcher 2004-07-14 21:29:48 vacuum full 100 mins plus?