From: | Hervé Piedvache <herve(at)elma(dot)fr>(by way of Hervé Piedvache <herve(at)elma(dot)fr>) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: WAL Files checkpoint_timeout with voluminous delete/insert |
Date: | 2003-08-26 17:25:22 |
Message-ID: | 200308261925.22784.herve@elma.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?= <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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
From | Date | Subject | |
---|---|---|---|
Next Message | Dennis Gearon | 2003-08-26 17:25:28 | Re: [PERFORM] Best tweak for fast results.. ? |
Previous Message | Dennis Gearon | 2003-08-26 17:22:35 | Re: is linux ready for databases ? (Ziff Davis article |