Re: check point segments leakage ?
От | Scott Marlowe |
---|---|
Тема | Re: check point segments leakage ? |
Дата | |
Msg-id | 1090364780.709.27.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: check point segments leakage ? ("Joshua D. Drake" <jd@commandprompt.com>) |
Ответы |
Re: check point segments leakage ?
|
Список | pgsql-hackers |
Bruce said the other day open transactions can't cause this problem. I wonder what all can? On Tue, 2004-07-20 at 16:32, Joshua D. Drake wrote: > 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 >
В списке pgsql-hackers по дате отправления: