Re: GiST index slower than seqscan

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: cgg007(at)yahoo(dot)com
Cc: postgresql listserv <pgsql-general(at)postgresql(dot)org>
Subject: Re: GiST index slower than seqscan
Date: 2006-04-21 13:55:05
Message-ID: 4448E439.2010900@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adam Majer 2006-04-21 14:00:17 Upgrade of Windows MSI installations (version 8.0)
Previous Message Martijn van Oosterhout 2006-04-21 13:42:11 Re: setting the environment locale - linux, windows