]> granicus.if.org Git - postgresql/commit
A couple of marginal performance hacks for the information_schema views:
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 14 Feb 2009 20:48:36 +0000 (20:48 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 14 Feb 2009 20:48:36 +0000 (20:48 +0000)
commit3f7626e9f2821ba084f3c31fddd9777ba7be6018
tree4a6aa2c9c9c1111385390e5922a40811b81c2cad
parentca5646fc824abe606e2cc78dff89631b0e875e27
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.
src/backend/catalog/information_schema.sql