How restart of database server influances autovacuum process ?
I think that somewhere on this mailing list I read that autovacuum in such case looses some important information and after database server restart will not behave as expected until VACUUM ANALYZE is executed. Is it true ?
Tomasz Rakowski
----- Original Message ---- From: Alvaro Herrera <alvherre@commandprompt.com> To: Tomasz Rakowski <mourawi@yahoo.com> Cc: Matthew T. O'Connor <matthew@zeut.net>; pgsql-general@postgresql.org Sent: Wednesday, June 27, 2007 2:50:40 PM Subject: Re: [GENERAL] 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.