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 <t...@sss.pgh.pa.us>: > Mariel Cherkassky <mariel.cherkas...@gmail.com> 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 >
