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