pgsql: A couple of marginal performance hacks for the information_schema

Поиск
Список
Период
Сортировка
От tgl@postgresql.org (Tom Lane)
Тема pgsql: A couple of marginal performance hacks for the information_schema
Дата
Msg-id 20090214204836.803367559ED@cvs.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
A couple of marginal performance hacks for the information_schema views:
replace the old recursive-SQL-function implementation of _pg_keysequal()
with use of the built-in array containment operators, and change
table_constraints' UNION to UNION ALL.  Per discussion with Octavio Alvarez.

initdb not forced since this doesn't affect results, but you'd need to
initdb or reload the information_schema to see the new definitions.

Modified Files:
--------------
    pgsql/src/backend/catalog:
        information_schema.sql (r1.51 -> r1.52)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/information_schema.sql?r1=1.51&r2=1.52)

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

Предыдущее
От: sas@pgfoundry.org (User Sas)
Дата:
Сообщение: slony1-ctl - slony-ctl: First import
Следующее
От: mha@pgfoundry.org (User Mha)
Дата:
Сообщение: pginstaller - pginst: Update chinese translation.