Michael Graham <mgraham@xxxxxxxxx> writes: > Ah! This looks like it is very much the issue. Since I've got around > 150GB of data that should be truncatable and a select every ~2s. > Just to confirm would postgres write: > 2011-08-03 16:09:55 BST ERROR: canceling autovacuum task > 2011-08-03 16:09:55 BST CONTEXT: automatic vacuum of table > "traffic.public.logdata5queue" > Under those circumstances? Yup ... If you do a manual VACUUM, it won't allow itself to get kicked off the lock ... but as noted upthread, that will mean your other queries get blocked till it's done. Not sure there's any simple fix for this that doesn't involve some downtime. 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
