Re: 8.0.3 pg_autovacuum doesn't clear out stats table?

From: Robin Iddon <robin(at)edesix(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: 8.0.3 pg_autovacuum doesn't clear out stats table?
Date: 2006-02-23 23:44:47
Message-ID: 43FE48EF.4000409@edesix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


>
> In fact I just noticed that the number of stats tuples just climbed
> from 1236 to 2634. The ins/del counts are still zero. I ran analyze
> and the update counter went up only by 1232. For pg_autovacuum to
> vacuum this table I need (2*2634)+1000 = 6268 updates, which is never
> going to happen.

At least not before the number of tuples has climbed to beyond that
count based on my experience to date!

Robin

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jim C. Nasby 2006-02-23 23:49:45 Re: 8.0.3 pg_autovacuum doesn't clear out stats table?
Previous Message Jim C. Nasby 2006-02-23 23:44:12 Re: 8.0.3 pg_autovacuum doesn't clear out stats table?