Re: Compatibility GUC for serializable

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Compatibility GUC for serializable
Date: 2011-01-10 18:47:17
Message-ID: 4D2AFFD502000025000391F4@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Josh Berkus <josh(at)agliodbs(dot)com> wrote:

> my clients have tended to use SELECT FOR UPDATE instead of
> SERIALIZABLE.

If they're not using SERIALIZABLE, this patch will have no impact on
them at all. If they are using SELECT FOR UPDATE *with*
SERIALIZABLE, everything will function exactly as it is except that
there may be some serialization failures which they weren't getting
before, either from the inevitable (but hopefully minimal) false
positives inherent in the technique or because they missed covering
something.

Since SSI doesn't introduce any blocking, and causes no behavior
changes beyond triggering serialization failures when it seems that
an anomaly may otherwise result, there's really nothing else to go
wrong.

Well, if there are no bugs we've missed in these few thousand lines
of code, that is. Given the size and complexity of the patch, it'd
be surprising if we've squashed them all just yet. We've tried....

-Kevin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Cédric Villemain 2011-01-10 19:13:18 Re: Streaming base backups
Previous Message Josh Berkus 2011-01-10 18:35:49 Re: Compatibility GUC for serializable