Horton

Re: postgresql 10.1 wrong plan in when using partitions bug

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>
Cc: Andreas Kretschmer <andreas@a-kretschmer.de>, pgsql-performance@lists.postgresql.org
Date: 2018-02-04T15:39:11Z
Lists: pgsql-performance 
Mariel Cherkassky <mariel.cherkassky@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