Re: getting rid of SnapshotNow - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: getting rid of SnapshotNow
Date
Msg-id 20130719172017.GD4130@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: getting rid of SnapshotNow  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: getting rid of SnapshotNow
List pgsql-hackers
Robert Haas escribió:

> 4. If we use GetActiveSnapshot, all the comments about about a fresh
> MVCC snapshot still apply.  However, the snapshot in question could be
> even more stale, especially in repeatable read or serializable mode.
> However, this might be thought a more consistent behavior than what we
> have now.  And I'm guessing that this function is typically run as its
> own transaction, so in practice this doesn't seem much different from
> an MVCC snapshot, only cheaper.
>
> At the moment, I dislike #2 and slightly prefer #4 to #3.

+1 for #4, and if we ever need more then we can provide a non-default
way to get at #2.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: FKey not enforced resulting in broken Dump/Reload
Next
From: Tom Lane
Date:
Subject: Re: AGG_PLAIN thinks sorts are free