Re: GiST index slower than seqscan

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: GiST index slower than seqscan
Дата
Msg-id 4448E439.2010900@sigaev.ru
обсуждение исходный текст
Ответ на Re: GiST index slower than seqscan  (CG <cgg007@yahoo.com>)
Список pgsql-general

> When I said full text, I meant substring. Please correct me if I am wrong, but
> tsearch would be useful for finding words in a paragraph, not characters in a
> word (or small group of words) ... If I had fields 'Hello World!', 'Low Tide',
> and 'Following Day' they would all be hits for a search on 'low' ...
>

Ok, I see

> I bet you meant ltree/ltree.h ... I'll give that a try and see what happens!
> Thank you!

Ltree index structure is mixed by BTree and signature tree. You don't need Btree
part as I understand...

I don't know efficient index structure to support queries you want... May be
Oleg knows...


--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: setting the environment locale - linux, windows
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: A few questions about ltree