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 <[EMAIL PROTECTED]> To: Tomasz Rakowski <[EMAIL PROTECTED]> Cc: Matthew T. O'Connor <[EMAIL PROTECTED]>; 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 ____________________________________________________________________________________ Yahoo! oneSearch: Finally, mobile search that gives answers, not web links. http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC
