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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rural Hunter <ruralhunter(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Why auto vacuum almost running all the time on one toast table?
Date: 2012-06-12 16:50:55
Message-ID: 18647.1339519855@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Rural Hunter <ruralhunter(at)gmail(dot)com> writes:
> 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?

Hm, is the autovacuum managing to complete, or is it getting kicked off
before it can complete?  It would help to see the messages those
CONTEXT lines are attached to; and/or you might check pg_stat_all_tables
to see when the last completed autovacuum was for both the main table
and its toast table.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Fujii MasaoDate: 2012-06-12 17:49:11
Subject: Re: pg_basebackup blocking all queries with horrible performance
Previous:From: Magnus HaganderDate: 2012-06-12 14:27:43
Subject: Re: could not rename temporary statistics file "pg_stat_tmp/pgstat.tmp" to "pg_stat_tmp/pgstat.stat": No such file or directory

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