Optimize query for information_schema.constraint_column_usage
The way the old query was written prevented some join optimizations
because the join conditions were hidden inside a CASE expression. With
a large number of constraints, the query became unreasonably slow. The
new query performs much better.
From: Alexey Bashtanov <bashtanov(at)imap(dot)cc>
Reviewed-by: Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/e3a58c8835a2cd428b8534dd8df30a7cb96c976b
Modified Files
--------------
src/backend/catalog/information_schema.sql | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)