Обсуждение: Logging autovacuum

Hi All;

I wonder is there a way to force autovacuum events to be logged to the
postgres log ?


Thanks in advance

On Mon, 2008-12-01 at 21:35 -0700, Kevin Kempter wrote:
>
> Hi All;
>
> I wonder is there a way to force autovacuum events to be logged to the
> postgres log ?

I believe they are, if you turn it up to DEBUG or DEBUG2.

Joshua D. Drake

>
>
> Thanks in advance
>
--
PostgreSQL
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997

Kevin Kempter wrote:
>
>
> Hi All;
>
> I wonder is there a way to force autovacuum events to be logged to the
> postgres log ?

See the log_autovacuum_min_duration parameter (new in 8.3)

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support