Postgres Pro
Downloads
Home   >   mailing lists

Re: Help tuning autovacuum - seeing lots of relation - Mailing list pgsql-performance

From Tom Lane
Subject Re: Help tuning autovacuum - seeing lots of relation
Date
Msg-id 9961.1150899424@sss.pgh.pa.us
Whole thread Raw
In response to Re: Help tuning autovacuum - seeing lots of relation  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-performance
Tree view 
Csaba Nagy <nagy@ecircle-ag.com> 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

pgsql-performance by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: Help tuning autovacuum - seeing lots of relation
Next
From: nicky
Date:
Subject: Speeding up query, Joining 55mil and 43mil records.