Postgres Pro
Downloads
Home   >   mailing lists

Re: Index-only scans and non-MVCC snapshots - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Index-only scans and non-MVCC snapshots
Date
Msg-id 20140627142019.GL7340@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: Index-only scans and non-MVCC snapshots  (Ryan Johnson <ryan.johnson@cs.utoronto.ca>)
Responses Re: Index-only scans and non-MVCC snapshots
List pgsql-hackers
Tree view 
Ryan Johnson wrote:
> On 26/06/2014 11:04 PM, Alvaro Herrera wrote:
> >Ryan Johnson wrote:
> >>As part of a research project, I'm trying to change Read Committed
> >>isolation to use HeapTupleSatisfiesNow rather than acquiring a new
> >>snapshot at every command [1].
> >Are you aware of this?
> >
> >commit 813fb0315587d32e3b77af1051a0ef517d187763
> >Author: Robert Haas <rhaas@postgresql.org>
> >Date:   Thu Aug 1 10:46:19 2013 -0400
> >
> >     Remove SnapshotNow and HeapTupleSatisfiesNow.
>
> That would be wonderful news... if snapshots weren't so darned
> expensive to create.

I take it you aren't aware of this other effort, either:
http://archives.postgresql.org/message-id/539AD153.9000004@vmware.com

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

pgsql-hackers by date:

Previous
From: Vik Fearing
Date:
Subject: Re: change alter user to be a true alias for alter role
Next
From: Michael Paquier
Date:
Subject: Re: WAL replay bugs