From: Larry Rosenman <ler@lerctr.org>
To: '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 15:59:22 -0500
Message-ID: <034b01c6f2f8$4f875c00$0202fea9@SURGIENT.COM> (raw)
In-Reply-To: <20061018191027.GM85041@nasby.net>
Jim C. Nasby wrote:
> 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.
It does NOT. It's just the timestamp of the END of the vacuum / analyze.
(I'm the author of the patch).
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
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: ler@lerctr.org, 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: <034b01c6f2f8$4f875c00$0202fea9@SURGIENT.COM>
* 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