public inbox for [email protected]  

help / color / mirror / Atom feed

From: Heikki Linnakangas <[email protected]>
To: Robert Haas <[email protected]>
Cc: Simon Riggs <[email protected]>
Cc: Joshua Tolley <[email protected]>
Cc: pgsql-docs <[email protected]>
Subject: Re: hot standby documentation
Date: Wed, 23 Jun 2010 22:29:54 +0300
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<1277319234.25074.2466.camel@ebony>
	<[email protected]>

On 23/06/10 22:05, Robert Haas wrote:
> On Wed, Jun 23, 2010 at 2:53 PM, Simon Riggs<[email protected]>  wrote:
>> We could also allow SELECT ... FOR SHARE during Hot Standby, simply by
>> making it same as normal SELECT, without any ill effects.
>
> True.

Not really. It won't matter while the standby is in read-only mode, but 
as soon as the server is promoted to master, you could have other 
backends modifying rows that the still-running "SELECT ... FOR SHARED" 
transaction should have locked.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

view thread (8+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: hot standby documentation
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox