Re: autovacumm not working ?

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-27 21:50:40
Message-ID: 20070627215040.GB28580@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2007-06-27 21:59:51 Re: Checking for a number
Previous Message Alvaro Herrera 2007-06-27 21:48:23 Re: AutoVacuum Behaviour Question