From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Don't trust deferred-unique indexes for join removal. |
Date: | 2011-10-23 04:44:47 |
Message-ID: | E1RHpvT-0001nY-Bv@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Don't trust deferred-unique indexes for join removal.
The uniqueness condition might fail to hold intra-transaction, and assuming
it does can give incorrect query results. Per report from Marti Raudsepp,
though this is not his proposed patch.
Back-patch to 9.0, where both these features were introduced. In the
released branches, add the new IndexOptInfo field to the end of the struct,
to try to minimize ABI breakage for third-party code that may be examining
that struct.
Branch
------
REL9_1_STABLE
Details
-------
http://git.postgresql.org/pg/commitdiff/18661c67e96ff4a81ab3844843a73676d161db0c
Modified Files
--------------
src/backend/nodes/outfuncs.c | 1 +
src/backend/optimizer/path/indxpath.c | 7 ++++---
src/backend/optimizer/util/plancat.c | 6 ++++++
src/backend/utils/adt/selfuncs.c | 4 +++-
src/include/nodes/relation.h | 3 +++
5 files changed, 17 insertions(+), 4 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-10-23 18:36:06 | pgsql: Improve git_changelog's handling of inconsistent commit ordering |
Previous Message | Tom Lane | 2011-10-22 22:24:00 | pgsql: Support synchronization of snapshots through an export/import pr |