Re: Predicate locking - Mailing list pgsql-hackers

From Vlad Arkhipov
Subject Re: Predicate locking
Date
Msg-id 4DBB80D9.6040409@dc.baikal.ru
Whole thread Raw
In response to Re: Predicate locking  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
29.04.2011 21:18, Kevin Grittner wrote:
> Vlad Arkhipov  wrote:
>
>    
>> But even if it would work it would not help me anyways. Because my
>> constraint is much more complex and depends on other tables, I
>> cannot express it in terms of exclusion constraints.
>>      
>
> Are you aware of the changes to the SERIALIZABLE transaction
> isolation level in the upcoming 9.1 release?
>
> http://wiki.postgresql.org/wiki/Serializable
> http://wiki.postgresql.org/wiki/SSI
>
> If you can wait for that, it might be just what you're looking for.
>
> -Kevin
>
>    
I would not like to make the whole transaction serializable because of 
performance and concurrency reasons.


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Sync Rep v19
Next
From: Alastair Turner
Date:
Subject: Copy/paste from psql - was: Changing the continuation-line prompt in psql?