Re: [PATCH] SQL assertions prototype - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [PATCH] SQL assertions prototype
Date
Msg-id 52C9BC46.1010505@gmx.net
Whole thread Raw
In response to Re: [PATCH] SQL assertions prototype  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: [PATCH] SQL assertions prototype
List pgsql-hackers
On 12/18/13, 2:22 PM, Andres Freund wrote:
> It would only force serialization for transactions that modify tables
> covered by the assert, that doesn't seem to bad. Anything covered by an
> assert shoulnd't be modified frequently, otherwise you'll run into major
> performance problems.

I think that makes sense.  If you want to use assertions, you need to
run in serializable mode, otherwise you get an error if you modify
anything covered by an assertion.

In the future, someone could enhance this for other isolation levels,
but as Josh has pointed out, that would likely just be reimplementing
SSI with big locks.




pgsql-hackers by date:

Previous
From: Mark Dilger
Date:
Subject: Re: In-core regression tests for replication, cascading, archiving, PITR, etc. Michael Paquier
Next
From: Peter Eisentraut
Date:
Subject: Re: [PATCH] SQL assertions prototype