-----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-----
<<inline: load.png>>
<<inline: space_usage.png>>
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
