Bill Moran <[EMAIL PROTECTED]> writes: > In response to Alvaro Herrera <[EMAIL PROTECTED]>: >> Of course they are able to complete, but the point is that they would >> not remove the tuples that would be visible to that idle open >> transaction.
> I would expect that, but the OP claimed that vacuum full waited until > the other transaction was finished. No, she didn't claim that. As far as I see she was just complaining about the failure to remove dead tuples: > > > > If I have a running transaction in database1 and try to vacuum > > > > database2 but the dead tuples in database2 cannot be removed. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/