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) ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
