Re: [fulltext]Gin index full scan - Mailing list pgsql-general

From Stuart Bishop
Subject Re: [fulltext]Gin index full scan
Date
Msg-id 6bc73d4c0905172221s3b1b2a58yafbe19800f8b44b7@mail.gmail.com
Whole thread Raw
In response to [fulltext]Gin index full scan  (esemba <esemba@gmail.com>)
List pgsql-general
On Mon, May 11, 2009 at 8:04 PM, esemba <esemba@gmail.com> wrote:
>
> I've a table with tsvector column named meta_vector. Over this column there
> is a gin index. When I execute query like:
> select id from theses where meta_vector @@@ to_tsquery('cs', 'foo | (!bar)')
>
> I get an errror message: query requires full scan, which is not supported by
> GIN indexes.
>
> The weird thing is, that when I drop the index, or disable index scans, it
> works. Why can't the planner just use full scans instead of index scans on
> such the queries? Thanks for help.

You can search the archives for the last time this was brought up.
Apparently, it isn't an easy fix. People hoped to have it addressed
for 8.4 but I don't know if it made it. Unfortunately, this makes GIN
indexes unusable for many applications such as text searching using
arbitrary user queries. GIST indexes work, but perform worse for
reads.

--
Stuart Bishop <stuart@stuartbishop.net>
http://www.stuartbishop.net/

pgsql-general by date:

Previous
From: Paolo Saul
Date:
Subject: Is this a bug or a feature? Column visibility in subquery from outer query
Next
From: jub4@email.cz
Date:
Subject: pg_dump and 2gb limit on windows and version 8.1.3