Postgres Pro
Downloads
Home   >   mailing lists

Re: No Index-Only Scan on Partial Index - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: No Index-Only Scan on Partial Index
Date
Msg-id 524DAE50.6050103@agliodbs.com
Whole thread Raw
In response to No Index-Only Scan on Partial Index  ("David E. Wheeler" <david@justatheory.com>)
Responses Re: No Index-Only Scan on Partial Index
List pgsql-hackers
Tree view 
David,

> But anyway, I still don’t understand why, if the function used to store the value is immutable (as upper_inf() is),
whyPostgres 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

pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: hstore extension version screwup
Next
From: Kevin Grittner
Date:
Subject: Re: record identical operator - Review