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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
