]> granicus.if.org Git - postgresql/commit
Add an index on pg_inherits.inhparent, and use it to avoid seqscans in
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 29 Dec 2009 22:00:14 +0000 (22:00 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 29 Dec 2009 22:00:14 +0000 (22:00 +0000)
commit540e69a0613bad2b6ad15b237a8df27110f4b213
tree13931f0f72e5b4008eeb823aa7301039684b3d85
parent649b5ec7c8a3050a30bd6d36003ba3a681c9a198
Add an index on pg_inherits.inhparent, and use it to avoid seqscans in
find_inheritance_children().  This is a complete no-op in databases without
any inheritance.  In databases where there are just a few entries in
pg_inherits, it could conceivably be a small loss.  However, in databases with
many inheritance parents, it can be a big win.
src/backend/catalog/pg_inherits.c
src/backend/commands/tablecmds.c
src/include/catalog/catversion.h
src/include/catalog/indexing.h