From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: getting rid of SnapshotNow |
Date: | 2013-07-26 14:10:46 |
Message-ID: | 15345.1374847846@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-odbc |
Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Fri, Jul 26, 2013 at 9:18 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Robert Haas <robertmhaas(at)gmail(dot)com> writes:
>>> Well, that's still used in _bt_check_unique, unique_key_recheck
>>> (trigger function to do a deferred uniqueness check), RI_FKey_check,
>>> and rather extensively by sepgsql. I don't really have much desire to
>>> do the work to get rid of it, though.
>> Hm. I agree the first three may be all right, but I can't help
>> suspecting that sepgsql is doing the wrong thing here.
> sepgsql is using SnapshotSelf to find the old version of a tuple that
> was updated by the core code just before.
Oh. OK, then it reduces to the same case as the other three, ie we're
looking at tuples we know to be update-locked.
> [ interesting ruminations snipped ]
Yeah, removing SnapshotNow catalog access certainly opens the doors
for a lot of new thinking.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2013-07-26 14:16:49 | Re: getting rid of SnapshotNow |
Previous Message | Greg Smith | 2013-07-26 13:52:45 | Re: Design proposal: fsync absorb linear slider |
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2013-07-26 14:16:49 | Re: getting rid of SnapshotNow |
Previous Message | Robert Haas | 2013-07-26 13:50:32 | Re: getting rid of SnapshotNow |