Re: No Index-Only Scan on Partial Index

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: No Index-Only Scan on Partial Index
Date: 2013-10-03 17:50:08
Message-ID: 524DAE50.6050103@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

David,

> 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.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2013-10-03 17:50:39 Re: record identical operator - Review
Previous Message Magnus Hagander 2013-10-03 17:49:39 Re: hstore extension version screwup