Hi, On 2015-06-10 16:19:27 -0700, Peter Geoghegan wrote: > Currently, speculative insertion (the INSERT ... ON CONFLICT DO UPDATE > executor/storage infrastructure) uses checkUnique == > UNIQUE_CHECK_PARTIAL for unique indexes, which is a constant > originally only used by deferred unique constraints. It occurred to me > that this has a number of disadvantages: > ... > Attached patch updates speculative insertion along these lines. > ... > The patch also updates the AM interface documentation (the part > covering unique indexes). It seems quite natural to me to document the > theory of operation for speculative insertion there.
I'm not arguing against any of this - but I don't think this needs to be on the 9.5 open items list. I plan to remove from there. Greetings, Andres Freund -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers