Herouth Maoz <herouth@xxxxxxxxxxxxx> writes: > Indeed autovacuum started working on some of the tables. At least one of these tables was one that I have trimmed up using CLUSTER. So I was watching that autovacuum process carefully. And then suddenly it was gone, after working for 20-odd hours. And I had even more dead tuples in pg_stat_user_tables for that table than before. > Looking at the log, I get this: > 2011-02-06 15:21:42 IST ERROR: canceling autovacuum task > 2011-02-06 15:21:42 IST CONTEXT: automatic vacuum of table "reports.alerts.smsq__archive" > Why? Most likely, some other session requested an exclusive lock on the table. Autovacuum will quit to avoid blocking the other query. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
