Re: autovacuum on updated rows - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: autovacuum on updated rows
Date
Msg-id 20051113190553.GH29473@surnet.cl
Whole thread Raw
In response to Re: autovacuum on updated rows  (Stephen Byers <stephenabyers@yahoo.com>)
List pgsql-admin
Stephen Byers wrote:
> Sorry for noise.  It turns out that little pound sign in front bit me !!
> #autovacuum = on

So, does it work after you activate it?  Please note that there's a
threshold in the number of tuples that will need to be modified for
a vacuum operation to be launched.  For such a small table you may want
to lower the threshold a bit.  See the docs on the pg_autovacuum system
catalog, in the "internals" chapter.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-admin by date:

Previous
From: "Tomeh, Husam"
Date:
Subject: Re: read only user
Next
From: "Thomas F. O'Connell"
Date:
Subject: Re: Open connections details