Postgres Pro
Downloads
Home   >   mailing lists

Re: autovacumm not working ? - Mailing list pgsql-general

From Tomasz Rakowski
Subject Re: autovacumm not working ?
Date
Msg-id 72470.47747.qm@web37111.mail.mud.yahoo.com
Whole thread Raw
In response to autovacumm not working ?  (Tomasz Rakowski <mourawi@yahoo.com>)
Responses Re: autovacumm not working ?  (Matthew O'Connor <matthew@zeut.net>)
List pgsql-general
Tree view
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@commandprompt.com>
To: Tomasz Rakowski <mourawi@yahoo.com>
Cc: Matthew T. O'Connor <matthew@zeut.net>; pgsql-general@postgresql.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


Got a little couch potato?
Check out fun summer activities for kids.

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: autovacumm not working ?
Next
From: "Danyelle Gragsone"
Date:
Subject: Re: postgres and webmin