Re: autovacumm not working ?

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

----- 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 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

____________________________________________________________________________________
Yahoo! oneSearch: Finally, mobile search
that gives answers, not web links.
http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC