Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx> writes: > Great, it solved the issue. Seems problematic that the planner do full > scans on all partitions in the first case isnt it ? Seems like a bug ? to_date isn't an immutable function (it depends on timezone and possibly some other GUC settings). So there's a limited amount that the planner can do with it. regards, tom lane
