Re: User-facing aspects of serializable transactions

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Robert Haas" <robertmhaas(at)gmail(dot)com>
Cc: "<Markus Wanner" <markus(at)bluegap(dot)ch>, "Heikki Linnakangas" <heikki(dot)linnakangas(at)enterprisedb(dot)com>, "Greg Stark" <stark(at)enterprisedb(dot)com>, "Jeff Davis" <pgsql(at)j-davis(dot)com>, "Bruce Momjian" <bruce(at)momjian(dot)us>, "<pgsql-hackers(at)postgresql(dot)org>" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: User-facing aspects of serializable transactions
Date: 2009-06-04 16:55:45
Message-ID: 4A27B641020000250002750B@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Thu, Jun 4, 2009 at 11:32 AM, Kevin Grittner
> <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
>> I was going to try to scare up some resources to advance this if we
>> could get to some consensus. I don't get the feeling we're there
>> yet. Suggestions welcome.
>
> I think I might've said this before, but I think you need to do (or
> get someone with knowledge of the code to do) more looking at the
> lock bookkeeping that's required to make the SIREAD stuff work and
> try to figure out if it's even feasible for PostgreSQL and what the
> performance costs would be (an idea of how much code complexity this
> would introduce would be good too). A lot of the "lack of
> consensus" at this point looks to me more like "lack of being sure
> whether this can actually work". I don't know that we're going to
> get any closer to consensus without some less-handwavy answer to
> that question.

I'd feel a lot more comfortable about trying to go that route if there
weren't heavy hitters insisting that "no serialization failures
without a reason that can be easily explained to users" is a
requirement. I don't believe it will ever work that way, so I see no
point moving farther. Either that requirement needs to be removed, or
someone who thinks it can be made to work that way will have to take
up the cause if this is to go anywhere.

I do agree, wholeheartedly, that if we get consensus on functional
requirements, the next step would be to identify the specific changes
required. In other words, I haven't forgotten your previous
suggestion, and it seems like the *next* step if we can wrap *this*
one.

-Kevin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2009-06-04 17:08:46 Re: [COMMITTERS] pgsql: Initialise perl library as documented in perl API.
Previous Message Dickson S. Guedes 2009-06-04 16:41:09 Re: Synchronous replication: status of standby side