[COMMITTERS] pgsql: Optimize query for information_schema.constraint_column_usage

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема [COMMITTERS] pgsql: Optimize query for information_schema.constraint_column_usage
Дата
Msg-id E1ceszx-000275-Ra@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
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@imap.cc>
Reviewed-by: Ashutosh Bapat <ashutosh.bapat@enterprisedb.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(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: [COMMITTERS] pgsql: doc: Fix typos
Следующее
От: Magnus Hagander
Дата:
Сообщение: [COMMITTERS] pgsql: Fix help message for pg_basebackup -R