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