From: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
---|---|
To: | Andres Freund <andres(at)2ndquadrant(dot)com> |
Cc: | Kevin Grittner <kgrittn(at)ymail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: SSI freezing bug |
Date: | 2013-10-04 11:09:56 |
Message-ID: | 524EA204.8080800@vmware.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Korotkov | 2013-10-04 11:13:18 | Re: GIN improvements part 1: additional information |
Previous Message | Andres Freund | 2013-10-04 11:02:06 | Re: SSI freezing bug |