Re: Snapshot synchronization, again... - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Snapshot synchronization, again...
Date
Msg-id 26171.1298915996@sss.pgh.pa.us
Whole thread Raw
In response to Re: Snapshot synchronization, again...  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Snapshot synchronization, again...  (Jim Nasby <jim@nasby.net>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Sun, Feb 27, 2011 at 8:33 PM, Joachim Wieland <joe@mcknight.de> wrote:
>> Remember that it's not only about saving shared memory, it's also
>> about making sure that the snapshot reflects a state of the database
>> that has actually existed at some point in the past.

> But you can do all of this with files too, can't you?  Just remove or
> truncate the file when the snapshot is no longer valid.

Yeah.  I think adopting a solution similar to 2PC state files is a very
reasonable way to go here.  This isn't likely to be a high-usage or
performance-critical feature, so it's not essential to keep the
information in shared memory for performance reasons.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Hammond
Date:
Subject: mysql2pgsql.perl update
Next
From: Josh Berkus
Date:
Subject: Re: Why our counters need to be time-based WAS: WIP: cross column correlation ...