Victor Yegorov <vyegorov@gmail.com> writes: > How can I enforce pruning to kick in for the initial expressions?
You already found out: use constants. The planner can't remove partitions on the basis of clauses involving volatile, or even stable, functions, because their results might be different at runtime.
Do you mean constants are the only way here?
I.e. there is absolutely no way to use any of the "current date / timestamp" functions available?
I've been trying to wrap current expressions into immutable functions, like `date_trunc`, without any luck.