Re: Lazy Snapshots - Mailing list pgsql-hackers

From simon@2ndquadrant.com
Subject Re: Lazy Snapshots
Date
Msg-id 316903078.9934.1250880090693.JavaMail.open-xchange@oxltgw02.schlund.de
Whole thread Raw
In response to Re: Lazy Snapshots  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Lazy Snapshots  (Gokulakannan Somasundaram <gokul007@gmail.com>)
List pgsql-hackers

On 18 August 2009 at 16:18 Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Simon, this concept is completely broken, as far as I can tell.

Thanks for the precise example.

Yes, I agree it is not going to work when there could be more than one row version in the relation. Which doesn't leave useful wriggle room, so not pursuing this further.

What a shame.

As discussed on -perform, it does seem as if we might have retrospectively calculated snapshots if we had the right data structure. But that's a different set of thoughts for another day.

Best Regards, Simon Riggs



pgsql-hackers by date:

Previous
From: "simon@2ndquadrant.com"
Date:
Subject: Re: Lazy Snapshots
Next
From: James Pye
Date:
Subject: still a wip, plpython3