Search Postgresql Archives

Re: GiST index slower than seqscan

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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@xxxxxxxxx
                                                   WWW: http://www.sigaev.ru/


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux