Searching a gin index

Поиск
Список
Период
Сортировка
От James Dooley
Тема Searching a gin index
Дата
Msg-id c01aff630902060559t56dc2da7je00363441f8f4911@mail.gmail.com
обсуждение исходный текст
Ответы Re: Searching a gin index  (Oleg Bartunov <oleg@sai.msu.su>)
Re: Searching a gin index  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
Hi again,

I have set my configuration as default and I have created a GIN index on three columns, like this

create index textsearch_index on products using gin(strip( to_tsvector( 'my_config', title || '' || description || '' || name)))

Searching these columns the way I have

... AND (title || '' || description || '' || name) @@ plainto_tsquery('car')

seems not to be correct since it's taking as much time as non-indexed. Also changing the word car to cars returns nothing even though

select * from plainto_tsquery('cars')

returns 'car'

Could you please point me in the right direction ?

James

В списке pgsql-general по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Pet Peeves?
Следующее
От: milos.babic@gmail.com
Дата:
Сообщение: warm database, tape device backup