Re: pg_autovacuum

On Tue, Dec 13, 2005 at 10:43:14AM +0200, Sim Zacks wrote:
> This is a sampling of the debug output.
>
> [2005-12-13 09:43:47 IST] DEBUG: 33 All DBs checked in: 278300 usec,
> will sleep for 300 secs.
> [2005-12-13 09:48:47 IST] DEBUG: 34 All DBs checked in: 171112 usec,
> will sleep for 300 secs.
> [2005-12-13 09:53:47 IST] DEBUG: updating the database list
>
> Does that mean that it is vacuuming the databases?
> One major reason that I think it is not, is that after a while the
> system starts getting sluggish and when I run vacuum analyze then it
> picks up again.
>
> That leads me to believe that it is not running vacuum analyze.

That means that it's most likely just not hitting the statistic targets,
which by default are set so that the table can bloat quite a bit. Try
adding -V 0.2 to your pg_autovacuum command line.

I think if you up the verbosity one more level it'll give you
information about the stats on the tables it's looking at.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461