pgsql: A couple of marginal performance hacks for the information_schema - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: A couple of marginal performance hacks for the information_schema
Date
Msg-id 20090214204836.803367559ED@cvs.postgresql.org
Whole thread Raw
List 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 by date:

Previous
From: sas@pgfoundry.org (User Sas)
Date:
Subject: slony1-ctl - slony-ctl: First import
Next
From: mha@pgfoundry.org (User Mha)
Date:
Subject: pginstaller - pginst: Update chinese translation.