Re: Problems Vacuum'ing

On Fri, Apr 02, 2004 at 07:35:20PM -0500, Tom Lane wrote:
> jseymour(at)LinxNet(dot)com (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?
If this is so, why does it matter that he has open transaction on a
different database?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
www.google.com: interfaz de línea de comando para la web.