pg_clog & vacuum oddness

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_clog & vacuum oddness
Date: 2003-10-29 16:03:58
Message-ID: 20031029110358.548105be.threshar@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-10-29 16:32:12 Re: pg_clog & vacuum oddness
Previous Message Stef 2003-10-29 15:36:53 Re: [SQL] Table versions