Re: [HACKERS] HOT and autovacuum

2008-03-04 Thread Alvaro Herrera
Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> 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 au

Re: [HACKERS] HOT and autovacuum

2008-03-03 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> 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 anythi

[HACKERS] HOT and autovacuum

2008-03-03 Thread Alvaro Herrera
Hi, 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 w