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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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)

Browse pgsql-committers by date

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