Re: WIP: Deferrable unique constraints - Mailing list pgsql-hackers

From Dean Rasheed
Subject Re: WIP: Deferrable unique constraints
Date
Msg-id 8e2dbb700907120614n3bdaa150xf01933289d9e7c74@mail.gmail.com
Whole thread Raw
In response to WIP: Deferrable unique constraints  (Dean Rasheed <dean.a.rasheed@googlemail.com>)
Responses Re: WIP: Deferrable unique constraints
List pgsql-hackers
Here is an updated version of this patch which should apply to HEAD,
with updated docs, regression tests, pg_dump and psql \d.

It works well for small numbers of temporary uniqueness violations,
and at least as well (in fact about twice as fast) as deferred FK
checks for large numbers of deferred checks.

I propose trying to improve performance and scalability for large
numbers of deferred checks in a separate patch.

 - Dean

Attachment

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: *_collapse_limit, geqo_threshold
Next
From: Andrew Dunstan
Date:
Subject: Re: Upgrading our minimum required flex version for 8.5