Re: autovacuum blues - Mailing list pgsql-general

From Anton Melser
Subject Re: autovacuum blues
Date
Msg-id 92d3a4950611090916s3834bc1cy5cf8ba74a13c9cab@mail.gmail.com
Whole thread Raw
In response to Re: autovacuum blues  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: autovacuum blues
Re: autovacuum blues
List pgsql-general
On 09/11/06, Alvaro Herrera <alvherre@commandprompt.com> wrote:
> Anton Melser wrote:
> > Hi,
> > I just can't understand why autovacuum is not working. I have a test
> > db/table which I insert values into (by the thousands) and can't work
> > out why my stats don't get updated. Could someone have a quick look at
> > my attached .conf and tell me what I am doing?
> > I am running it on FC5 8.1.4.fc5.1.
>
> You can tell whether autovacuum is running by using
>
> SHOW autovacuum;
>
>
> Note that if you have a firewall of some sort stopping UDP messages from
> being transmitted inside your machine, the stats collector may not
> start, which may stop the autovacuum daemon from starting.  If you're
> not seeing stat updates then there's probably something like that going
> on.  Maybe the system has emitted a warning message at server start;
> check the logs.

Thanks for that. Just a clarification, can someone tell me what the
"number of tuples" means in the context of the multipliers? I mean,
when the vacuum min multiplier is at 0.4, we multiply 0.4 by what? I
get the min val, but what are we multiplying by 0.4? The total number
of tuples in the table? The total modified/deleted?
I guess it is just that I assumed that it would kick in regularly, and
it doesn't seem to. Probably it is not needed but I always got the
feeling that after a good vacuum performance seemed better.
Cheers
Antoine

pgsql-general by date:

Previous
From: Jorge Godoy
Date:
Subject: Re: Why overlaps is not working
Next
From: Steve Atkins
Date:
Subject: Re: Mac OS X