Dean Rasheed <dean.a.rash...@googlemail.com> writes: > [ latest deferrable-unique patch ]
I'm starting to look at this now. I haven't read the patch itself yet, but I went through the discussion thread. I'm not sure whether we have actually decided that we want to commit this, as opposed to treating it as an investigation exercise. 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 reason this bothers me is that from what I recall of past complaints about our lack of deferred unique checks, the *primary* use case is things like "update foo set id = id + 1". So I'm afraid that this might be a toy implementation that's not useful in practice. The three likely responses to this objection seem to be 1. "You're right, we should reject the patch until that's fixed." 2. "You're wrong, the patch is perfectly useful as-is." 3. "You're right, but we should commit anyway because it will be fixed later." I don't think I'm going to believe #3 though, because there's no concrete design for a fix on the table, much less a commitment to implement it. Comments? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers