From: Hervé Piedvache <footcow@noos.fr>
To: pgsql-performance@postgresql.org
Cc: Josh Berkus <josh@agliodbs.com>
Cc: Hervé Piedvache <herve@elma.fr>
Subject: Re: Insert are going slower ...
Date: Wed, 14 Jul 2004 23:32:05 +0200
Message-ID: <200407142332.05161.footcow@noos.fr> (raw)
In-Reply-To: <200407140928.29498.josh@agliodbs.com>
References: <200407131850.52095.herve@elma.fr>
<200407140142.11720.footcow@noos.fr>
<200407140928.29498.josh@agliodbs.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: footcow@noos.fr, josh@agliodbs.com, herve@elma.fr
Subject: Re: Insert are going slower ...
In-Reply-To: <200407142332.05161.footcow@noos.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox