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:25:06
Message-ID: 55175472.408@proxel.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

--
Andreas Karlsson

Attachment Content-Type Size
index-only-ranges-v1.patch text/x-patch 4.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Karlsson 2015-03-29 01:30:54 Re: Index-only scans with btree_gist
Previous Message Gavin Flower 2015-03-29 00:21:58 Re: Rounding to even for numeric data type