News for hackers. Stuff that matters.
Re:Working around a case where the Postgres planner is “not ... by talos on Monday August 02, 2021 @03:47PM (#28041715)
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`.

There are no comments on this comment yet.