Philip Warner <pjw@rhyme.com.au> writes:
> It seems that the optimizer does not know about (or calculate values of)
> constant expressions when determining strategy.
Datetime calculations are not considered constant-foldable. See
prior discussions, eg thread "Constant propagation and similar issues"
in pghackers on 11-Sep.
regards, tom lane