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

From esemba
Subject [fulltext]Gin index full scan
Date
Msg-id 23482754.post@talk.nabble.com
Whole thread Raw
Responses Re: [fulltext]Gin index full scan  (Stuart Bishop <stuart@stuartbishop.net>)
List 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.


pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Remote access
Next
From: Cristina M
Date:
Subject: Problem with estimating pages for a table