Re: Predicate locking

From: Vlad Arkhipov <arhipov(at)dc(dot)baikal(dot)ru>
To:
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Predicate locking
Date: 2011-04-30 03:24:09
Message-ID: 4DBB80D9.6040409@dc.baikal.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alastair Turner 2011-04-30 08:10:40 Copy/paste from psql - was: Changing the continuation-line prompt in psql?
Previous Message Bruce Momjian 2011-04-30 02:29:01 Re: Sync Rep v19