| From: | "David E(dot) Wheeler" <david(at)justatheory(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: No Index-Only Scan on Partial Index |
| Date: | 2013-10-03 20:24:32 |
| Message-ID: | 59E7BF9A-2F05-4C4D-9D5A-02498192992C@justatheory.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Oct 3, 2013, at 10:50 AM, Josh Berkus <josh(at)agliodbs(dot)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.1345072858@sss.pgh.pa.us
• http://www.postgresql.org/message-id/79C7D74D-59B0-4D97-A5E5-55553EF299AA@justatheory.com
Best,
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2013-10-03 20:26:36 | Re: [GENERAL] currval and DISCARD ALL |
| Previous Message | Robert Haas | 2013-10-03 20:23:50 | pgsql: Add DISCARD SEQUENCES command. |