On Tue, Jul 24, 2012 at 2:11 PM, Steve Singer <ssin...@ca.afilias.info> wrote: > On 12-07-24 01:48 PM, Robert Haas wrote: >> I am running into a lot of customer situations where the customer >> reports that "canceling autovacuum task" shows up in the logs, and >> it's unclear whether this is happening often enough to matter, and >> even more unclear what's causing it. > > Could autovacuum be compacting a lot of space at the end of the table. This > is described > in the thread > http://archives.postgresql.org/message-id/4d8df88e.7080...@yahoo.com
You (and Andres) may well be right, but I think the way we find out is to add some better logging. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers