Csaba Nagy <nagy@xxxxxxxxxxxxxx> 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
