From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rural Hunter <ruralhunter@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Why auto vacuum almost running all the time on one toast table?
Date: Tue, 12 Jun 2012 12:50:55 -0400
Message-ID: <18647.1339519855@sss.pgh.pa.us> (raw)
In-Reply-To: <4FD6F4B3.8050509@gmail.com>
References: <4FD6F4B3.8050509@gmail.com>
Rural Hunter <ruralhunter@gmail.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, ruralhunter@gmail.com
Subject: Re: Why auto vacuum almost running all the time on one toast table?
In-Reply-To: <18647.1339519855@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox