Re: Performance issue after creating partitions

Teja Jakkidi <teja(dot)jakkidi05(at)gmail(dot)com> writes:
> Anyone ever encountered the below situation as what I am noticing with partitions?

You haven't shown us your query, so any answer would be blind speculation.

However, in the spirit of blind speculation, I'm wondering if you're
expecting those range constraints to propagate across a join. They
won't; you'd need to duplicate the conditions for the other table.

That is, if you have WHERE+JOIN/ON conditions amounting to

WHERE a.a = b.b AND b.b = constant

the planner is able to derive "a.a = constant" on the assumption of
transitivity, and use that to constrain the scan of table a (ie,
use an index, reject partitions at plan time, etc). But no such
deduction happens for

WHERE a.a = b.b AND b.b >= constant

If you want a constrained scan of a, you need to write it out:

WHERE a.a = b.b AND b.b >= constant AND a.a >= constant

regards, tom lane