| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Noah Misch <noah(at)leadboat(dot)com>, pgsql-hackers(at)postgresql(dot)org, pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] getting rid of SnapshotNow |
| Date: | 2013-07-22 20:23:14 |
| Message-ID: | CA+TgmoYCsEFGdWrN1AjGzbB1Dqg8+QhQiGoGhcV3kjwtcpt+EQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-odbc |
On Fri, Jul 19, 2013 at 1:20 PM, Alvaro Herrera
<alvherre(at)2ndquadrant(dot)com> wrote:
>> 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.
OK, done.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2013-07-22 20:26:53 | Re: proposal - psql - show longest tables |
| Previous Message | Greg Smith | 2013-07-22 20:23:04 | Re: Performance Improvement by reducing WAL for Update Operation |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | onur gulsevgi | 2013-07-23 14:39:32 | Re: Fwd: configure: error: unixODBC library "odbcinst" not found while trying to compile odbc |
| Previous Message | Dev Kumkar | 2013-07-22 19:00:35 | Re: Fwd: configure: error: unixODBC library "odbcinst" not found while trying to compile odbc |