pg_clog & vacuum oddness
От | Jeff |
---|---|
Тема | pg_clog & vacuum oddness |
Дата | |
Msg-id | 20031029110358.548105be.threshar@torgo.978.org обсуждение исходный текст |
Ответы |
Re: pg_clog & vacuum oddness
|
Список | pgsql-admin |
I have a machine that typically runs good, but more and more recently when vacuum runs everything (not just pg) comes to a griding halt. If iostat is to be believed, there isn't too much IO going on - 300kB/sec write, 0kB read. Now before we diagnose this as "bah!" I noticed something odd - in my pg_clog directory I have [currently] 384 files. there seem to be about 3-6/day in there. They all (except for hte last) have the same size of 200someodd-kB. The DB is fairly active with around 20-100 (varies wildly) insert/update/delete a second. I had vacuum & fsm tuned so my UnUsed was rather steady. The thing that bothers me most is why all that stuff in the clog? There are entries in there that are older than the last time I spun PG. Machine is a 2xp3-800mhz, 2gb, linux 2.2.17 [old], pg 7.3.4 -- Jeff Trout <jeff@jefftrout.com> http://www.jefftrout.com/ http://www.stuarthamm.net/
В списке pgsql-admin по дате отправления: