| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Dean Rasheed <dean(dot)a(dot)rasheed(at)googlemail(dot)com>, David Fetter <david(at)fetter(dot)org>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: WIP: Deferrable unique constraints |
| Date: | 2009-07-27 18:21:47 |
| Message-ID: | 1248718907.18098.10.camel@monkey-cat.sm.truviso.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, 2009-07-27 at 13:14 -0400, Tom Lane wrote:
> The main thing that is bothering me is something Dean pointed out at
> the very beginning: the patch will not scale well for large numbers of
> conflicts.
The way I see it, there are two strategies:
(a) build up a list as you go, and check it later
(b) do a check of the full table at once
Is there another reasonable option?
The patch seems like a reasonable implementation of (a), so what it's
missing is the ability to fall back to (b) when the list gets too large
(compared with available memory or relative to the table size).
Are you suggesting that we wait until (b) is implemented, or do you
envision something else entirely?
Regards,
Jeff Davis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dean Rasheed | 2009-07-27 18:38:42 | Re: WIP: Deferrable unique constraints |
| Previous Message | Pavel Stehule | 2009-07-27 17:59:56 | Re: proposal: support empty string as separator for string_to_array |