| From: | "Larry Rosenman" <ler(at)lerctr(dot)org> |
|---|---|
| To: | "'Jim C(dot) Nasby'" <jim(at)nasby(dot)net>, "'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 20:59:22 |
| Message-ID: | 034b01c6f2f8$4f875c00$0202fea9@SURGIENT.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
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(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Duncan McDonald | 2006-10-18 23:37:35 | Re: Missing Earth Distance Functions Under Debian |
| Previous Message | Jim C. Nasby | 2006-10-18 19:10:27 | Re: [PERFORM] autovacuum on a -mostly- r/o table |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ioana Danes | 2006-10-18 21:02:01 | Re: Postgresql 8.1.4 - performance issues for select on view using max |
| Previous Message | Ioana Danes | 2006-10-18 20:34:34 | Re: Postgresql 8.1.4 - performance issues for select on view using max |