Csaba Nagy <[EMAIL PROTECTED]> writes:
>> So, it appears my autovacuum is just NOT working... I must have screwed
>> something up, but I cannot see what.
> Is it possible that you have long running transactions ?
The other question I was wondering about is if autovacuum is actually
choosing to vacuum the target table or not. The only way to check that
in 8.1 is to crank log_min_messages up to DEBUG2 and then trawl through
the postmaster log looking for "autovac" messages.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
