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 16:54:30
Message-ID: 4F9D2BF6020000250004754B@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2012-04-29 17:02:47 Re: Re: xReader, double-effort (was: Temporary tables under hot standby)
Previous Message Tom Lane 2012-04-29 16:41:56 Re: smart shutdown at end of transaction (was: Default mode for shutdown)