Tomasz Rakowski wrote:
> 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 ?
No, this was only true in versions previous to 8.1.
Unless you stop the database in "immediate" mode. If you do that, then
all the information that autovacuum uses is lost. If you use "smart" or
"fast" it should work fine.
Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J
"Porque francamente, si para saber manejarse a uno mismo hubiera que
rendir examen... ¿Quién es el machito que tendría carnet?" (Mafalda)
In response to
pgsql-general by date
|Next:||From: Bruce McAlister||Date: 2007-06-28 15:40:13|
|Subject: Re: AutoVacuum Behaviour Question|
|Previous:||From: Tom Lane||Date: 2007-06-28 15:33:09|
|Subject: Re: autovacumm not working ? |