]> granicus.if.org Git - postgresql/commit
Create hooks to let a loadable plugin monitor (or even replace) the planner
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 25 May 2007 17:54:25 +0000 (17:54 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 25 May 2007 17:54:25 +0000 (17:54 +0000)
commit604ffd280b955100e5fc24649ee4d42a6f3ebf35
treecd4ef43c9f931f86c6e33b58d03ea498b722aa0b
parentce5b24abedd3db058c832aabb19940935b2903ae
Create hooks to let a loadable plugin monitor (or even replace) the planner
and/or create plans for hypothetical situations; in particular, investigate
plans that would be generated using hypothetical indexes.  This is a
heavily-rewritten version of the hooks proposed by Gurjeet Singh for his
Index Advisor project.  In this formulation, the index advisor can be
entirely a loadable module instead of requiring a significant part to be
in the core backend, and plans can be generated for hypothetical indexes
without requiring the creation and rolling-back of system catalog entries.

The index advisor patch as-submitted is not compatible with these hooks,
but it needs significant work anyway due to other 8.2-to-8.3 planner
changes.  With these hooks in the core backend, development of the advisor
can proceed as a pgfoundry project.
src/backend/commands/explain.c
src/backend/commands/prepare.c
src/backend/executor/nodeBitmapIndexscan.c
src/backend/executor/nodeIndexscan.c
src/backend/optimizer/plan/planner.c
src/backend/optimizer/util/plancat.c
src/include/commands/explain.h
src/include/optimizer/plancat.h
src/include/optimizer/planner.h