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 - [EMAIL PROTECTED] - http://www.commandprompt.com Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
begin:vcard fn:Joshua D. Drake n:Drake;Joshua D. org:Command Prompt, Inc. adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA email;internet:[EMAIL PROTECTED] title:Consultant tel;work:503-667-4564 tel;fax:503-210-0034 note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl. x-mozilla-html:FALSE url:http://www.commandprompt.com/ version:2.1 end:vcard
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
