On Oct 3, 2013, at 10:50 AM, Josh Berkus <[email protected]> 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/[email protected] • http://www.postgresql.org/message-id/[email protected] Best, David -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
