Alvaro,
I changed autovacuum parametrs for this specific table in pg_autovacuum
insert into pg_autovacuum (vacrelid,enabled,vac_base_thresh, vac_scale_factor, anl_base_thresh, anl_scale_factor,
vac_cost_delay, vac_cost_limit, freeze_min_age, freeze_max_age)
values ( (select oid from pg_class where relname='t_ais_position'), True, 100, 0.01 , 100, 0.02, -1, -1, -1, -1 )
Should I somehow let autovacuum deamon know about new table configuration or above insert is enough ?
Tomasz
I changed autovacuum parametrs for this specific table in pg_autovacuum
insert into pg_autovacuum (vacrelid,enabled,vac_base_thresh, vac_scale_factor, anl_base_thresh, anl_scale_factor,
vac_cost_delay, vac_cost_limit, freeze_min_age, freeze_max_age)
values ( (select oid from pg_class where relname='t_ais_position'), True, 100, 0.01 , 100, 0.02, -1, -1, -1, -1 )
Should I somehow let autovacuum deamon know about new table configuration or above insert is enough ?
Tomasz
----- Original Message ----
From: Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx>
To: Tomasz Rakowski <mourawi@xxxxxxxxx>
Cc: Matthew T. O'Connor <matthew@xxxxxxxx>; pgsql-general@xxxxxxxxxxxxxx
Sent: Wednesday, June 27, 2007 2:50:40 PM
Subject: Re: [GENERAL] autovacumm not working ?
From: Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx>
To: Tomasz Rakowski <mourawi@xxxxxxxxx>
Cc: Matthew T. O'Connor <matthew@xxxxxxxx>; pgsql-general@xxxxxxxxxxxxxx
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)
> 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)
Pinpoint customers who are looking for what you sell.
