[fulltext]Gin index full scan

Поиск
Список
Период
Сортировка
От esemba
Тема [fulltext]Gin index full scan
Дата
Msg-id 23482754.post@talk.nabble.com
обсуждение исходный текст
Ответы Re: [fulltext]Gin index full scan  (Stuart Bishop <stuart@stuartbishop.net>)
Список 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 по дате отправления:

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: Remote access
Следующее
От: Cristina M
Дата:
Сообщение: Problem with estimating pages for a table