From: Jim C. Nasby <jim@nasby.net>
To: Tobias Brox <tobias@nordicbet.com>
Cc: Matthew T. O'Connor <matthew@zeut.net>
Cc: Csaba Nagy <nagy@ecircle-ag.com>
Cc: Edoardo Ceccarelli <eddy@axa.it>
Cc: postgres performance list <pgsql-performance@postgresql.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: [PERFORM] autovacuum on a -mostly- r/o table
Date: Wed, 18 Oct 2006 14:10:27 -0500
Message-ID: <20061018191027.GM85041@nasby.net> (raw)
In-Reply-To: <20061015145212.GA13175@oppetid.no>
References: <20061015095259.GA24002@oppetid.no>
<453248DA.7050806@zeut.net>
<20061015145212.GA13175@oppetid.no>
On Sun, Oct 15, 2006 at 04:52:12PM +0200, Tobias Brox wrote:
> Are there any logs that can help me, and eventually, are there any
> ready-made scripts for checking when autovacuum is running, and
> eventually for how long it keeps its transactions? I'll probably write
> up something myself if not.
8.2 adds some stats on when autovac last ran, per-table. I don't
remember if it reports how long it took to vacuum the table, but that
would probably be useful info.
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
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-performance@postgresql.org
Cc: jim@nasby.net, tobias@nordicbet.com, matthew@zeut.net, nagy@ecircle-ag.com, eddy@axa.it, pgsql-admin@postgresql.org
Subject: Re: [PERFORM] autovacuum on a -mostly- r/o table
In-Reply-To: <20061018191027.GM85041@nasby.net>
* 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