Postgres Pro
Downloads
Home   >   mailing lists

Re: 8.0.3 pg_autovacuum doesn't clear out stats table? - Mailing list pgsql-admin

From Robin Iddon
Subject Re: 8.0.3 pg_autovacuum doesn't clear out stats table?
Date
Msg-id 43FE48EF.4000409@edesix.com
Whole thread Raw
In response to Re: 8.0.3 pg_autovacuum doesn't clear out stats table?  (Robin Iddon <robin@edesix.com>)
Responses Re: 8.0.3 pg_autovacuum doesn't clear out stats table?  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-admin
Tree view 
>
> 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

pgsql-admin by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: 8.0.3 pg_autovacuum doesn't clear out stats table?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: 8.0.3 pg_autovacuum doesn't clear out stats table?