On Oct 3, 2013, at 10:50 AM, Josh Berkus <j...@agliodbs.com> wrote: >> >> But anyway, I still don’t understand why, if the function used to store the >> value is immutable (as upper_inf() is), why Postgres doesn't do an index >> scan. Is this something that could be improved in the planner? > > Yes. This is clearly a TODO.
Added it here: https://wiki.postgresql.org/wiki/Todo#Optimizer_.2F_Executor Teach the planner how to better use partial indexes for index-only scans • http://www.postgresql.org/message-id/25141.1345072...@sss.pgh.pa.us • http://www.postgresql.org/message-id/79c7d74d-59b0-4d97-a5e5-55553ef29...@justatheory.com Best, David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
