Alvaro,
I see autovacuum process starting in avarage every 5 minutes
(table contains 30.000 records, and update rate is about 1000records /min).
But what is strange is that the number of pages allocated to the table are constant (at least for this hour: 500)
and number of pages allocated to indexes are constantly growing (109 -> 145, 92 -> 250!!!, 194->256)
But as I stated in first post after a while it gets worse and worse (thousands of allocated pages for the same number of records..)
Tomasz
I see autovacuum process starting in avarage every 5 minutes
(table contains 30.000 records, and update rate is about 1000records /min).
But what is strange is that the number of pages allocated to the table are constant (at least for this hour: 500)
and number of pages allocated to indexes are constantly growing (109 -> 145, 92 -> 250!!!, 194->256)
But as I stated in first post after a while it gets worse and worse (thousands of allocated pages for the same number of records..)
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 3:54:14 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 3:54:14 PM
Subject: Re: [GENERAL] autovacumm not working ?
Tomasz Rakowski wrote:
> 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 ?
The insert should be enough. You do see the autovacuum process starting
on that database, right?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
> 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 ?
The insert should be enough. You do see the autovacuum process starting
on that database, right?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Got a little couch potato?
Check out fun summer activities for kids.
