Hi Tom,
Did you hear about any solution that is similar to oracle`s global index ? Is there any way to query all the partitions with one index?
2018-02-04 17:39 GMT+02:00 Tom Lane <tgl@xxxxxxxxxxxxx>:
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
