Re: SP-GiST versus index-only scans - Mailing list pgsql-hackers

From Jesper Krogh
Subject Re: SP-GiST versus index-only scans
Date
Msg-id 4EE8EB04.50107@krogh.cc
Whole thread Raw
In response to SP-GiST versus index-only scans  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: SP-GiST versus index-only scans  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 2011-12-14 19:00, Tom Lane wrote:
> So the problem is that we have to either disallow such opclass designs,
> or support per-opclass rather than per-index-AM decisions about whether
> index-only scans are possible.

Just a quick comment, for some queries like the famous
select count(*) from table where column @@ to_tsquery('something');
I do think index-only-scans does make sense even on indices
where the original tuple cannot be re-constructed. This also goes
for gin indices as well.

.. and yes, I do have a real-world application that would utillize this.
(and love it)

Jesper
-- 
Jesper



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH] PostgreSQL fails to build with 32bit MinGW-w64
Next
From: Tom Lane
Date:
Subject: Re: SP-GiST versus index-only scans