pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedLogging autovacuum
3+ messages / 3 participants
[nested] [flat]
* Logging autovacuum
@ 2008-12-02 04:35 Kevin Kempter <kevink@consistentstate.com>
2008-12-02 05:42 ` Re: Logging autovacuum Joshua D. Drake <jd@commandprompt.com>
2008-12-02 13:46 ` Re: Logging autovacuum Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 2 replies; 3+ messages in thread
From: Kevin Kempter @ 2008-12-02 04:35 UTC (permalink / raw)
To: pgsql-admin
Hi All;
I wonder is there a way to force autovacuum events to be logged to the
postgres log ?
Thanks in advance
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Logging autovacuum
2008-12-02 04:35 Logging autovacuum Kevin Kempter <kevink@consistentstate.com>
@ 2008-12-02 05:42 ` Joshua D. Drake <jd@commandprompt.com>
1 sibling, 0 replies; 3+ messages in thread
From: Joshua D. Drake @ 2008-12-02 05:42 UTC (permalink / raw)
To: Kevin Kempter <kevink@consistentstate.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Logging autovacuum
2008-12-02 04:35 Logging autovacuum Kevin Kempter <kevink@consistentstate.com>
@ 2008-12-02 13:46 ` Alvaro Herrera <alvherre@commandprompt.com>
1 sibling, 0 replies; 3+ messages in thread
From: Alvaro Herrera @ 2008-12-02 13:46 UTC (permalink / raw)
To: Kevin Kempter <kevink@consistentstate.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-12-02 13:46 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-12-02 04:35 Logging autovacuum Kevin Kempter <kevink@consistentstate.com>
2008-12-02 05:42 ` Joshua D. Drake <jd@commandprompt.com>
2008-12-02 13:46 ` Alvaro Herrera <alvherre@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox