Mike Pultz wrote
> Is there something I'm missing?

What version are you using?

Now() is a volatile function so the planner cannot omit partitions.

Replace that with a constant and now it can.

David J.




--
View this message in context: 
http://postgresql.nabble.com/Problem-with-constraint-exclusion-on-partitions-tp5831541p5831548.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to