From: | Florian Pflug <fgp(dot)phlo(dot)org(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Hannu Krosing <hannu(at)skype(dot)net>, Magnus Hagander <magnus(at)hagander(dot)net>, Marko Kreen <markokr(at)gmail(dot)com>, Jan Wieck <JanWieck(at)Yahoo(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Skytools committed without hackers discussion/review |
Date: | 2007-10-10 23:51:05 |
Message-ID: | 470D6569.2060907@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
Tom Lane wrote:
> Florian Pflug <fgp(dot)phlo(dot)org(at)gmail(dot)com> writes:
>> Tom Lane wrote:
>>> I think txid_current_snapshot should read ActiveSnapshot. If the user
>>> wants to get a beginning-of-xact rather than beginning-of-statement
>>> snapshot from it, he should be required to call it in a serializable
>>> transaction.
>
>> Hm... does txid require that the snapshot it uses a valid in the sense that
>> its xmin follows OldestXmin? If not, we could keep the snapshot around for
>> txid, but still update our published xmin - which seems to be the main
>> reason we care about getting rid of old snapshots at all.
>
> Why should we complicate the main code like that for txid? I have not heard
> any argument why the function should be examining SerializableSnapshot
> instead of the current transaction snapshot.
I wouldn't know. I just wanted to say that even if it needs to examine
SerializableSnapshot, that won't clash with the xmin optimizations planned for
8.4, as long as the snapshot won't be used for actual queries.
greetings, Florian Pflug
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2007-10-11 01:27:18 | Re: Skytools committed without hackers discussion/review |
Previous Message | Jan Wieck | 2007-10-10 23:37:53 | Re: Skytools committed without hackers discussion/review |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-10-11 00:20:13 | Plan invalidation vs temp sequences |
Previous Message | Jan Wieck | 2007-10-10 23:37:53 | Re: Skytools committed without hackers discussion/review |