Sibte Abbas napisał(a):
On 6/20/07, Ireneusz Pluta <[EMAIL PROTECTED]> wrote:
Hello,
How can I make sure that autovacuum is running, beyond believing that
all autovacuum_ settings in
postgresql.conf are set correctly?
In the 8.1 I could see:
LOG: autovacuum: processing database "test"
in the log.
But I can't find it in the 8.2.4.
I could see some developers discussions about making changes to
logging autovacuum activity, however
could not track the discussion tight enough to find what the final
solution is.
Thanks
Ireneusz Pluta
ps -ef | grep autovacuum.
It does not show it. I run freebsd, does it matter?
Anyway, I found that I may enable logging autovacuum messages by setting:
log_min_messages = debug1
in postgresql.conf
I found it from postgresql-8.2.4/src/backend/postmaster/autovacuum.c, where I
read in line 420:
ereport(DEBUG1,
(errmsg("autovacuum: processing database \"%s\"", db->name)));
and this is what the developers were discussing and I did not understand
initially.
Sorry for the noise.
Ireneusz Pluta
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
