Re: Skytools committed without hackers discussion/review

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

In response to

Browse pgsql-committers by date

  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

Browse pgsql-hackers by date

  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