| From: | "Jim C(dot) Nasby" <jim(at)nasby(dot)net> |
|---|---|
| To: | Tobias Brox <tobias(at)nordicbet(dot)com> |
| Cc: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, Csaba Nagy <nagy(at)ecircle-ag(dot)com>, Edoardo Ceccarelli <eddy(at)axa(dot)it>, postgres performance list <pgsql-performance(at)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] autovacuum on a -mostly- r/o table |
| Date: | 2006-10-18 19:10:27 |
| Message-ID: | 20061018191027.GM85041@nasby.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Larry Rosenman | 2006-10-18 20:59:22 | Re: [PERFORM] autovacuum on a -mostly- r/o table |
| Previous Message | Tom Lane | 2006-10-18 17:59:59 | Re: Problems with VACUUM and "dead row versions cannot be removed yet" |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-10-18 19:17:34 | Re: Optimization of this SQL sentence |
| Previous Message | Jim C. Nasby | 2006-10-18 19:01:18 | Re: Performance Optimization for Dummies 2 - the SQL |