Skip site navigation (1) Skip section navigation (2)

Why auto vacuum almost running all the time on one toast table?

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 (view raw or flat)
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"

Responses

pgsql-admin by date

Next:From: Craig RingerDate: 2012-06-12 08:11:26
Subject: Re: How to setup PostgreSQL using Windows Authentication?
Previous:From: Peter CheungDate: 2012-06-12 02:00:01
Subject: How to setup PostgreSQL using Windows Authentication?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group