Re: Question regarding autovacuum - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Question regarding autovacuum
Date
Msg-id 20070828202244.GA21106@alvh.no-ip.org
Whole thread Raw
In response to Question regarding autovacuum  (Karl Denninger <karl@denninger.net>)
Responses Re: Question regarding autovacuum
List pgsql-general
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?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: Karl Denninger
Date:
Subject: Question regarding autovacuum
Next
From: Kevin Neufeld
Date:
Subject: Re: PickSplit method of 2 columns ... error