Re: default_transaction_isolation = serializable causes crash under Hot Standby

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <simon(at)2ndQuadrant(dot)com>
Cc: <robertmhaas(at)gmail(dot)com>,<pgsql-hackers(at)postgresql(dot)org>, <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: default_transaction_isolation = serializable causes crash under Hot Standby
Date: 2012-04-29 19:18:59
Message-ID: 4F9D4DD30200002500047568@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Simon Riggs wrote:
> On Sun, Apr 29, 2012 at 5:54 PM, Kevin Grittner
> 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.

I think I know where to do that. I'll give it a shot.

-Kevin

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2012-04-29 19:43:19 Re: default_transaction_isolation = serializable causes crash under Hot Standby
Previous Message Kevin Grittner 2012-04-29 18:36:27 Re: Re: xReader, double-effort (was: Temporary tables under hot standby)