Re: SSI freezing bug - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: SSI freezing bug
Date
Msg-id 524EA204.8080800@vmware.com
Whole thread Raw
In response to Re: SSI freezing bug  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
On 04.10.2013 14:02, Andres Freund wrote:
> But locks on those still can have meaning, right? From my very limited
> understanding of predicate.c/SSI I don't see why we cannot have
> meaningful conflicts on tuples that are already vacuumable. You'd need
> some curiously interleaved transactions, sure, but it seems possible?

To conflict with a lock, a backend would need to read or update the 
tuple the lock is on. If the tuple is vacuumable, it's no longer visible 
to anyone, so no backend can possibly read or update it anymore.

- Heikki



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: SSI freezing bug
Next
From: Alexander Korotkov
Date:
Subject: Re: GIN improvements part 1: additional information