From: | Tomasz Rakowski <mourawi(at)yahoo(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)commandprompt(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:27:20 |
Message-ID: | 840159.93479.qm@web37101.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)commandprompt(dot)com>
To: Tomasz Rakowski <mourawi(at)yahoo(dot)com>
Cc: Matthew T. O'Connor <matthew(at)zeut(dot)net>; pgsql-general(at)postgresql(dot)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.
--
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)
____________________________________________________________________________________Ready for the edge of your seat?
Check out tonight's top picks on Yahoo! TV.
http://tv.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-06-28 15:33:09 | Re: autovacumm not working ? |
Previous Message | Tomasz Rakowski | 2007-06-28 15:22:34 | Re: autovacumm not working ? |