check point segments leakage ?

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: check point segments leakage ?
Date: 2004-07-20 20:58:11
Message-ID: 40FD8763.6030101@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

-----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-----

Attachment Content-Type Size
image/png 5.2 KB
image/png 3.7 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-07-20 21:01:31 Re: How to display privileges in psql
Previous Message Andrew Dunstan 2004-07-20 20:11:30 pg_config