Re: Index-only scans with btree_gist

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

In response to

Responses

Browse pgsql-hackers by date

  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