Simon Riggs <simon@2ndquadrant.com> writes:
> IMHO the only way to do joins that access partitions is to do the
> constraint exclusion at run time, but I can see thats a longer
> conversation than I can start right now.
My experience in Oracle was that you can see three different types of
partition plans
1) Plans that the planner can statically deduce will access specific partitions. This is basically what Postgres has
now.
2) Plans that the planner can statically deduce will only access a limited number of partitions but which partitions
willbe determined at run-time. This is sort of like how Postgres handles index scans in subqueries where the value
beinglooked up is a parameter.
3) Plans that expect to span all the partitions because it can't find any constraint in the query from which it can
deducewhich partitions to look at.
Option 2 happens both for joins, and also for simple lookups where the value
being looked up is a parameter in a prepared query. My personal inclination is
that prepared queries are the way of the future so I think this is an
important case.
--
greg