From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: check point segments leakage ? |
Date: | 2004-07-20 22:32:50 |
Message-ID: | 40FD9D92.1000101@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
Attachment | Content-Type | Size |
---|---|---|
jd.vcf | text/x-vcard | 640 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-07-20 22:46:55 | Re: unused variable |
Previous Message | Bruce Momjian | 2004-07-20 22:30:23 | Re: How to display privileges in psql |