On Fri, 2 Apr 2004, Alvaro Herrera wrote: > On Fri, Apr 02, 2004 at 07:35:20PM -0500, Tom Lane wrote: > > [EMAIL PROTECTED] (Jim Seymour) writes: > > > Again the difference: With WebObjects running, deleting rows and > > > trying to vacuum immediately, even full, fails. Shut-down WebObjects > > > and I can. > > > > WebObjects is evidently holding an open transaction. Ergo, anything > > deleted after the start of that transaction isn't vacuumable. You need > > to do something about the client-side logic that is holding an open > > transaction without doing anything ... > > But, if I read the code correctly, the oldest xmin vacuum cares about > for a non-shared relation should be local to the database, shouldn't it?
AFAICS it's the oldest transaction at the start of any of the transactions in this database, not the oldest transaction of any transaction in this database. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
