Re: Question regarding autovacuum - Mailing list pgsql-general

From Karl Denninger
Subject Re: Question regarding autovacuum
Date
Msg-id 46D48D38.70809@denninger.net
Whole thread Raw
In response to Re: Question regarding autovacuum  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Question regarding autovacuum  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
I don't know.  How do I check?
Karl Denninger (karl@denninger.net)
http://www.denninger.net



Alvaro Herrera wrote:
Karl Denninger wrote:
 
A manual "Vacuum full analyze" fixes it immediately.

But... .shouldn't autovacuum prevent this?  Is there some way to look in a 
log somewhere and see if and when the autovacuum is being run - and on 
what?   
Are your FSM settings enough to keep track of the dead space you have?
 

pgsql-general by date:

Previous
From: Jeff Amiel
Date:
Subject: Re: Out of Memory - 8.2.4
Next
From: Tom Lane
Date:
Subject: Re: Question regarding autovacuum