Re: check point segments leakage ?

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

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL