Re: SP-GiST versus index-only scans

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