Re: Autovacuum on by default? - Mailing list pgsql-hackers

From Matthew T. O'Connor
Subject Re: Autovacuum on by default?
Date
Msg-id 44E4A8F7.4000702@zeut.net
Whole thread Raw
In response to Re: Autovacuum on by default?  ("Larry Rosenman" <ler@lerctr.org>)
List pgsql-hackers
Larry Rosenman wrote:
> Alvaro Herrera wrote:
>   
>> Bruce Momjian wrote:
>>     
>> Well, the problem is that it shows what it's *currently* doing, but it
>> doesn't let you know what has happened in the last day or whatever. 
>> It can't answer "has table foo been vacuumed recently?" or "what
>> tables haven't been vacuumed at all during this week?"
>>     
>
> I added last vacuum and last analyze (both auto and manual) dates in the 8.2
> tree.....

Hmm... well that does address most of my issue.  Doesn't tell me that 
table_foo is getting vacuumed constantly, but it does tell me that it 
was vacuumed recently.  Might be good enough.



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] selecting large result sets in psql using
Next
From: Bruce Momjian
Date:
Subject: Re: Autovacuum on by default?