From: | Rural Hunter <ruralhunter(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Why auto vacuum almost running all the time on one toast table? |
Date: | 2012-06-12 07:50:11 |
Message-ID: | 4FD6F4B3.8050509@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
v9.1.3 on Ubuntu 10.04 server. I have one table which has frequent
insert and weekly deletion, no update. Recently, I found the auto vacuum
on the toast table of it almost running all the time. each run took
around 1 hour. I don't think there are so many inerts so that it reaches
the auto vacuum criteria(20%? changes). And there is no such frequent
auto vacuum on the main table. The last auto vacuum of the main table is
on 3rd Jun. what might cause this behavior?
# grep pg_toast_16922 postgresql-2012-06-12_000000.log
2012-06-12 01:22:56 CST [(at)] CONTEXT: automatic vacuum of table
"oodb.pg_toast.pg_toast_16922"
2012-06-12 04:27:49 CST [(at)] CONTEXT: automatic vacuum of table
"oodb.pg_toast.pg_toast_16922"
2012-06-12 06:58:02 CST [(at)] CONTEXT: automatic vacuum of table
"oodb.pg_toast.pg_toast_16922"
2012-06-12 09:27:38 CST [(at)] CONTEXT: automatic vacuum of table
"oodb.pg_toast.pg_toast_16922"
2012-06-12 12:17:33 CST [(at)] CONTEXT: automatic vacuum of table
"oodb.pg_toast.pg_toast_16922"
2012-06-12 15:05:31 CST [(at)] CONTEXT: automatic vacuum of table
"oodb.pg_toast.pg_toast_16922"
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2012-06-12 08:11:26 | Re: How to setup PostgreSQL using Windows Authentication? |
Previous Message | Peter Cheung | 2012-06-12 02:00:01 | How to setup PostgreSQL using Windows Authentication? |