Re: default_transaction_isolation = serializable causes crash under Hot Standby - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: default_transaction_isolation = serializable causes crash under Hot Standby
Date
Msg-id CA+U5nMLmyQbQ5-SpE3MAC-DdkZgzC8vFCTtDXjP9YUuYfjimPA@mail.gmail.com
Whole thread Raw
In response to Re: default_transaction_isolation = serializable causes crash under Hot Standby  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
On Sun, Apr 29, 2012 at 5:54 PM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
> Simon Riggs  wrote:
>
>> The only way default_transaction_isolation = serializable would be
>> acceptable when hot_standby = on is if we silently downgrade the
>> isolation level to read committed. That way everything just works,
>> albeit not quite as requested. So I think that's the best way
>> forwards.
>
> I guess I don't see much alternative.  Did you want to code that (I
> seem to remember you saying that in an earlier post) or would you
> like me to do it?

I'll happily do that, unless you wish to.

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


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Future In-Core Replication
Next
From: Peter Eisentraut
Date:
Subject: Re: smart shutdown at end of transaction (was: Default mode for shutdown)