Re: SSI and Hot Standby - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: SSI and Hot Standby
Date
Msg-id 1295565090.1803.6122.camel@ebony
Whole thread Raw
In response to SSI and Hot Standby  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: SSI and Hot Standby  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: SSI and Hot Standby  (Florian Pflug <fgp@phlo.org>)
Re: SSI and Hot Standby  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, 2011-01-19 at 19:05 -0600, Kevin Grittner wrote:

> The idea is that whenever we see a valid snapshot which would yield
> a truly serializable view of the data for a READ ONLY transaction,
> we add a WAL record with that snapshot information. 

You haven't explained why this approach is the way forwards. What other
options have been ruled out, and why. The above approach doesn't sound
particularly viable to me.

It's not clear to me what the reason is that this doesn't just work on
HS already. If you started there it might help.

-- Simon Riggs           http://www.2ndQuadrant.com/books/PostgreSQL Development, 24x7 Support, Training and Services



pgsql-hackers by date:

Previous
From: Daniel Farina
Date:
Subject: Re: One Role, Two Passwords
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Large object corruption during 'piped' pg_restore