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

[fulltext]Gin index full scan

From: esemba <esemba(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: [fulltext]Gin index full scan
Date: 2009-05-11 13:04:39
Message-ID: 23482754.post@talk.nabble.com (view raw or flat)
Thread:
Lists: pgsql-general
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.

Lukas
-- 
View this message in context: http://www.nabble.com/-fulltext-Gin-index-full-scan-tp23482754p23482754.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


Responses

pgsql-general by date

Next:From: Cristina MDate: 2009-05-11 14:31:19
Subject: Problem with estimating pages for a table
Previous:From: Jasen BettsDate: 2009-05-11 13:00:23
Subject: Re: Remote access

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