Skip to content
Snippets Groups Projects
Select Git revision
  • benchmark-tools
  • postgres-lambda
  • master default
  • REL9_4_25
  • REL9_5_20
  • REL9_6_16
  • REL_10_11
  • REL_11_6
  • REL_12_1
  • REL_12_0
  • REL_12_RC1
  • REL_12_BETA4
  • REL9_4_24
  • REL9_5_19
  • REL9_6_15
  • REL_10_10
  • REL_11_5
  • REL_12_BETA3
  • REL9_4_23
  • REL9_5_18
  • REL9_6_14
  • REL_10_9
  • REL_11_4
23 results

explain.h

  • Tom Lane's avatar
    604ffd28
    Create hooks to let a loadable plugin monitor (or even replace) the planner · 604ffd28
    Tom Lane authored
    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.
    604ffd28
    History
    Create hooks to let a loadable plugin monitor (or even replace) the planner
    Tom Lane authored
    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.