Re: tuning autovacuum - Mailing list pgsql-hackers

From Tom Lane
Subject Re: tuning autovacuum
Date
Msg-id 9317.1307584222@sss.pgh.pa.us
Whole thread Raw
In response to Re: tuning autovacuum  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: tuning autovacuum
Re: tuning autovacuum
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> I think it'd be really useful to expose some more data in this area
> though.  One random idea is - remember the time at which a table was
> first observed to need vacuuming. Clear the timestamp when it gets
> vacuumed.  Then you can do:

As far as I recall that logic, there is no delay between when we know
that a table needs vacuumed and when we do it.  I don't see the point of
introducing any such delay, either.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Dan Ports
Date:
Subject: Re: SSI work for 9.1
Next
From: Robert Haas
Date:
Subject: Re: tuning autovacuum