Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] autovacuum on a -mostly- r/o table - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: [ADMIN] autovacuum on a -mostly- r/o table
Date
Msg-id 20061018191027.GM85041@nasby.net
Whole thread Raw
In response to Re: [ADMIN] autovacuum on a -mostly- r/o table  (Tobias Brox <tobias@nordicbet.com>)
Responses Re: [ADMIN] autovacuum on a -mostly- r/o table  ("Larry Rosenman" <ler@lerctr.org>)
List pgsql-performance
Tree view 
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)

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Performance Optimization for Dummies 2 - the SQL
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Optimization of this SQL sentence