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-27 23:14:50
Message-ID: 5515E46A.50706@proxel.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 03/26/2015 10:31 PM, Heikki Linnakangas wrote:
> I've pushed Anastasia's patch to support index-only scans with GiST, and
> it's time to add opclasses support for all the opclasses that are not
> lossy. I think at least all the btree_gist opclasses need to be
> supported, it would be pretty surprising if they didn't support
> index-only scans, while some more complex opclasses did.
>
> Attached is a WIP patch for that. It covers all the varlen types that
> btree_gist supports, and int2, int4 and oid. The rest of the fixed-width
> types should be just a matter of copy-pasting. I'll continue adding
> those, but wanted to let people know I'm working on this.

Would it also be worth doing the same for the inet_ops class for
inet/cidr? I have hacked a quick WIP patch which I believe should work,
but have not looked into the index only scan code enough to be sure.

--
Andreas Karlsson

Attachment Content-Type Size
index-only-inet-v1.patch text/x-patch 3.0 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2015-03-27 23:26:24 Re: Rounding to even for numeric data type
Previous Message Michael Paquier 2015-03-27 21:44:40 Rounding to even for numeric data type