| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Tomasz Rakowski <mourawi(at)yahoo(dot)com> |
| Cc: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: autovacumm not working ? |
| Date: | 2007-06-28 15:34:11 |
| Message-ID: | 20070628153411.GH5300@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce McAlister | 2007-06-28 15:40:13 | Re: AutoVacuum Behaviour Question |
| Previous Message | Tom Lane | 2007-06-28 15:33:09 | Re: autovacumm not working ? |