Re: [HACKERS] vacuum bug

2003-07-01 Thread Christopher Kings-Lynne
> There would be *zero* activity on a table undergoing vacuum full, unless > your app has found a way around vacuum full's exclusive lock. You sure > this wasn't a plain vacuum? Hmm...correct. So I don't know what happened. > > Then vacuum full failed after a while: > > ERROR: simple_heap_upda

Re: [HACKERS] vacuum bug

2003-07-01 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > I was running a long-running vacuum full, and then halfway thru that our > background vacuum process started. As well as this, there was light > activity on a users table from which vacuum full was removing 9 rows. There would be *zero*

[HACKERS] vacuum bug

2003-07-01 Thread Christopher Kings-Lynne
Hi, I was running a long-running vacuum full, and then halfway thru that our background vacuum process started. As well as this, there was light activity on a users table from which vacuum full was removing 9 rows. Then vacuum full failed after a while: ERROR: simple_heap_update: tuple con