| From: | Andreas Karlsson <andreas(at)proxel(dot)se> |
|---|---|
| To: | hlinnaka(at)iki(dot)fi, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
| Cc: | Anastasia Lubennikova <lubennikovaav(at)gmail(dot)com> |
| Subject: | Re: Index-only scans with btree_gist |
| Date: | 2015-03-29 01:30:54 |
| Message-ID: | 551755CE.6060708@proxel.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 03/29/2015 03:25 AM, Andreas Karlsson wrote:
> On 03/28/2015 09:36 PM, Andreas Karlsson wrote:
>> Thanks! Do you know if it is possible to add index-only scan support to
>> range indexes? I have never looked at those and do not know if they are
>> lossy.
>
> Seems like range types are not compressed at all so implementing
> index-only scans was trivial. A patch is attached.
Noticed a couple of typos, so to avoid having them sneak into the code
here is a version without them.
--
Andreas Karlsson
| Attachment | Content-Type | Size |
|---|---|---|
| index-only-ranges-v2.patch | text/x-patch | 4.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabien COELHO | 2015-03-29 08:58:17 | Re: PATCH: pgbench - merging transaction logs |
| Previous Message | Andreas Karlsson | 2015-03-29 01:25:06 | Re: Index-only scans with btree_gist |