Re: Question regarding autovacuum - Mailing list pgsql-general

From Tom Lane
Subject Re: Question regarding autovacuum
Date
Msg-id 3988.1188335347@sss.pgh.pa.us
Whole thread Raw
In response to Question regarding autovacuum  (Karl Denninger <karl@denninger.net>)
Responses Re: Question regarding autovacuum  (Karl Denninger <karl@denninger.net>)
Question regarding autovacuum in 8.1  (Denis Gasparin <denis@edistar.com>)
List pgsql-general
Karl Denninger <karl@denninger.net> writes:
> But... .shouldn't autovacuum prevent this?  Is there some way to look in
> a log somewhere and see if and when the autovacuum is being run - and on
> what?

There's no log messages (at the default log verbosity anyway).  But you
could look into the pg_stat views for the last vacuum time for each table.

            regards, tom lane

pgsql-general by date:

Previous
From: Karl Denninger
Date:
Subject: Re: Question regarding autovacuum
Next
From: Steve Crawford
Date:
Subject: Re: Question regarding autovacuum