Re: autovacumm not working ?

Tomasz Rakowski wrote:
> Matthew,
>
>   Thank you for reply.
>
>   I was trying to configure autovacuum for given table to be more aggressive (min=100, scale factor=0.01).
>   Then waited for autovacuum to be activated for given table
>   (watching  Server status window; about 1000 updates/min, 30.000 rows
>   in the table, so didn't have to wait too long).

Did you reload (pg_ctl reload) after changing the postgresql.conf
settings?  Also note that you can alter values for a specific table by
putting them in the pg_autovacuum table.

--
Alvaro Herrera                  http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"I am amazed at [the pgsql-sql] mailing list for the wonderful support, and
lack of hesitasion in answering a lost soul's question, I just wished the rest
of the mailing list could be like this."                               (Fotis)
               (http://archives.postgresql.org/pgsql-sql/2006-06/msg00265.php)