Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> I'm seeing a 8.3 database whose autovacuum-initiated vacuums are being
> cancelled and I am not sure of the cause. I am wondering if a HOT
> cleanup round on a page could try to acquire locks on it that would
> conflict with autovacuum (basically anything that conflicts with a
> vacuum lock). This would cause autovacuum to commit hara-kiri.
This is nonsense, no? A buffer cleanup lock is an LWLock not a lock
manager lock.
regards, tom lane