Skip site navigation (1) Skip section navigation (2)

pgsql: A couple of marginal performance hacks for the information_schema

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: A couple of marginal performance hacks for the information_schema
Date: 2009-02-14 20:48:36
Message-ID: 20090214204836.803367559ED@cvs.postgresql.org (view raw or flat)
Thread:
Lists: 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

Next:From: User MhaDate: 2009-02-15 11:28:14
Subject: pginstaller - pginst: Update chinese translation.
Previous:From: User SasDate: 2009-02-13 17:12:22
Subject: slony1-ctl - slony-ctl: First import

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group