Обсуждение: Re: default_transaction_isolation = serializable causes crash under Hot Standby

Поиск
Список
Период
Сортировка

Re: default_transaction_isolation = serializable causes crash under Hot Standby

От
"Kevin Grittner"
Дата:
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?
-Kevin


Re: default_transaction_isolation = serializable causes crash under Hot Standby

От
Simon Riggs
Дата:
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