|
|
|
|
|
by talos
1774 days ago
|
|
I definitely agree with you, but in this case the Postgres team itself frames the suboptimal behavior as such: > However, PostgreSQL's planner is currently not very smart about such cases. (From https://www.postgresql.org/docs/10/indexes-index-only-scans....) I suspect this is just a rough edge. Many types of functions may not be consistent, and therefore would need to be re-executed on the original data. Perhaps some of the planner functionality here predates function notation like `IMMUTABLE`. |
|