Re: Autovacuum improvements

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Darcy Buskermolen <darcy(at)ok-connect(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Subject: Re: Autovacuum improvements
Date: 2007-01-14 16:45:24
Message-ID: 45AA5E24.9020302@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


> While we are talking autovacuum improvements, I'd like to also see some better
> logging, something that is akin to the important information of vacuum
> verbose being logged to a table or baring that the error_log. I'd like to be
> able to see what was done, and how long it took to do for each relation
> touched by av. A thought, having this information may even be usefull for
> the above thought of scheduler because we may be able to build some sort of
> predictive scheduling into this.

This plays back to the vacuum summary idea that I requested:

http://archives.postgresql.org/pgsql-hackers/2005-07/msg00451.php

(Man our new search engine is so much better than the old one :))

Joshua D. Drake

>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavan Deolasee 2007-01-14 18:51:15 Re: Autovacuum Improvements
Previous Message Darcy Buskermolen 2007-01-14 16:27:15 Re: Autovacuum improvements

Browse pgsql-patches by date

  From Date Subject
Next Message Matthew T. O'Connor 2007-01-14 19:39:15 Re: Autovacuum improvements
Previous Message Darcy Buskermolen 2007-01-14 16:27:15 Re: Autovacuum improvements