| 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: | Whole Thread | Raw Message | 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 |