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 <[email protected]> Reviewed-by: Ashutosh Bapat <[email protected]> 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(-) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
