Re: serializable read only deferrable - Mailing list pgsql-hackers

From Tom Lane
Subject Re: serializable read only deferrable
Date
Msg-id 26546.1291569212@sss.pgh.pa.us
Whole thread Raw
In response to serializable read only deferrable  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: serializable read only deferrable  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> I'm reviving the discussion on the subject topic because I just had
> an epiphany which makes it seem simple to implement.  The concept of
> this is that if you start a SERIALIZABLE READ ONLY transaction in an
> SSI environment when certain conditions are true, it doesn't need to
> acquire predicate locks or test for rw-conflicts.

I assume this would have to be a "hard" definition of READ ONLY, not
the rather squishy definition we use now?  How would we manage the
compatibility implications?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: FK's to refer to rows in inheritance child
Next
From: Andrew Dunstan
Date:
Subject: Re: FK's to refer to rows in inheritance child