Skip site navigation (1) Skip section navigation (2)

Regression - Query requires full scan, GIN doesn't support it

From: Stuart Bishop <stuart(at)stuartbishop(dot)net>
To: PgSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Regression - Query requires full scan, GIN doesn't support it
Date: 2007-06-19 05:25:53
Message-ID: 467768E1.3040704@stuartbishop.net (view raw or flat)
Thread:
Lists: pgsql-general
Hi.

I recently converted a load of GIST indexes used by tsearch2 to GIN, as my
app is read heavy. We now occasionally get the exception:

    Query requires full scan, GIN doesn't support it

Thankfully it is happening very rarely, but as the querys are generated from
user input we can't stop this entirely.

Is this a permanent limitation of GIN, or is a fix possible?

Is a fix being worked on?

If a fix is forthcoming, will it be available in the 8.2 series or only 8.3+?

(It certainly looks like a bug to me, as the relevant queries work if the
index is dropped, and queries working or failing depending on the existence
of an index seems rather wrong to me.)

Only relevant discussion on this I can find is
http://archives.postgresql.org/pgsql-hackers/2007-01/msg01581.php. There
appear to be no replies visible though :-(

-- 
Stuart Bishop <stuart(at)stuartbishop(dot)net>
http://www.stuartbishop.net/

Responses

pgsql-general by date

Next:From: chaDate: 2007-06-19 05:40:31
Subject: pg_dump to include multiple tables
Previous:From: marcelo CortezDate: 2007-06-19 04:41:21
Subject: Re: help with libpq program

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group