Hi Tom,
Le Vendredi 22 Août 2003 22:43, Tom Lane a écrit :
> =?iso-8859-15?q?Herv=E9=20Piedvache?= <herve@elma.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