Michael Graham <mgraham@bloxx.com> 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