strange autovacuum behaviour

From: Stefano Nichele <stefano(dot)nichele(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: strange autovacuum behaviour
Date: 2009-02-09 17:43:43
Message-ID: 49906B4F.5040509@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,
I have a couple of questions about autovacuum/vacuum behavior.

On my production system, I set autovacuum ON since it's pretty hard to
me find a good timeframe for vacuum (the system is pretty busy over the day)
Last week the system was really slow and running vacuum manually the
performance was really improved.
So now I would like to understand why autovacuum did not work as
expected (at least for me). Any ideas ?

Other question.
Yesterday I noticed another strange thing. autovacuum was off since the
aforementioned issue and a vacuum scheduled at 06:00 UTC.
Checking pg_stat_all_tables (last_autovacuum field) I saw that at 05:30
UTC an autovacuum was performed for almost all the tables. After 30 min
(at 06:00) vacuum started and for about 2 hours, vacuum and autovacuum
were running simultaneously.

Why autovacuum (that was OFF) started ? For preventing transaction ID
wraparound ? Is it right that in such case all the tables are
(auto)vacuumed ?

My database is about 35 GB and the most updated table (in terms of
insert/delete/update) is indeed the biggest one (3.6 GB of data, 3.2 GB
primary key index, 1.5 GB another index) and I'm using postgres 8.2.9.

Thanks in advance for any suggestion.

Cheers,
ste

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John Lister 2009-02-09 19:20:40 Re: database corruption help
Previous Message Tom Lane 2009-02-09 17:31:33 Re: database corruption help