Mark Steben wrote: > I am contemplating implementing partitioning in Postgres v 11. I am > reading the documentation and came across this statement in the > Constraint Exclusion section: > Constraint exclusion only works when the query's WHERE clause > contains constants (or externally supplied parameters). > Is this true also in Partition pruning? I don't see a similar > statement in that section. In v11, partition pruning will also work at query execution time, that is, you don't have to use a constant. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
