Re: WAL Files checkpoint_timeout with voluminous delete/insert

Hi Tom,

Le Vendredi 22 Août 2003 22:43, Tom Lane a écrit :
> =?iso-8859-15?q?Herv=E9=20Piedvache?= <herve(at)elma(dot)fr> writes:
> > I have a dedicated partition on the disk for the WAL files, 2Gb.
> >
> > So I start my script and saw the size of the pg_xlog partition groing
> > quickly to be full after 20 min ...
>
> That shouldn't happen, unless there's something preventing automatic
> checkpoints from occurring. What do you have checkpoint_segments set
> to?

#checkpoint_segments = 3 # in logfile segments, min 1, 16MB each

Unset in the config file ... so default value ... 3 ?

So, any idea of my problem ?

regards,
--
Hervé Piedvache

Elma Ingénierie Informatique
6 rue du Faubourg Saint-Honoré
F-75008 - Paris - France
Pho. 33-144949901
Fax. 33-144949902