Bruce said the other day open transactions can't cause this problem.
I wonder what all can?
On Tue, 2004-07-20 at 16:32, Joshua D. Drake wrote:
> Hello,
>
> Perhaps you have an open transaction that isn't closing and thus the
> pg_xlog continues to grow?
>
> Sincerely,
>
> Joshua D. Drake
>
>
> Gaetano Mendola wrote:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > Hi all,
> > today I add 4 new columns to a table with 4E+06 rows,
> > I also update to an initial value these new columns.
> >
> > The new columns are 3 INTEGER one of type DOUBLE.
> > The table have also 5 indexes.
> >
> > Immediately after the operation my partition "data" had
> > an usage increment of 1.2GB.
> > I did a reindex and a vacuum full on that table and 600MB
> > were freed.
> >
> > Now I have an increment of only 600 MB.
> >
> > I use a checkpoint_segments = 16 but in my pg_xlog I have
> > 35 files. Why 35 files ?
> >
> > Where are lost my 600MB ?
> >
> > Also the load increased from 1 to 5 !!
> > Any ideas ?
> >
> > I'm attaching boot graphs ( HD space usage and load ).
> >
> > Regards
> > Gaetano Mendola
> >
> >
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v1.2.4 (MingW32)
> > Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
> >
> > iD8DBQFA/Ydh7UpzwH2SGd4RAuhKAKCTftBGjBLSfR+OTy5vHlYpL46TXQCfc65/
> > VfepMM87dQKvg3rswhGUNL8=
> > =HWHy
> > -----END PGP SIGNATURE-----
> >
> > ------------------------------------------------------------------------
> >
> >
> > ------------------------------------------------------------------------
> >
> >
> > ------------------------------------------------------------------------
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 8: explain analyze is your friend
>