Jim Nasby <jim.na...@bluetreble.com> writes: > On 1/29/15 4:02 PM, Robert Haas wrote: >> I don't think this is true, and I don't think it's been true for a >> long time, if ever. The difference between a manual vacuum and >> autovacuum is that autovacuum commits suicide when it conflicts with >> somebody else's lock request, and a manual vacuum doesn't.
> Any idea where we set that up? The relevant logic is in the deadlock detector, which will cancel an autovacuum transaction if it is blocking somebody else's lock request. regards, tom lane -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers