Hi Tom, (sorry again but no answer about this any idea ?)

Le Vendredi 22 Ao�t 2003 22:43, Tom Lane a �crit :
> =?iso-8859-15?q?Herv=E9=20Piedvache?= <[EMAIL PROTECTED]> 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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to