Re: tsearch2 's access method?

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: 沈一枫 <alphahunters(at)163(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: tsearch2 's access method?
Date: 2005-10-20 08:41:09
Message-ID: 43575825.6030304@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

沈一枫 wrote:
> the basic structures to implement the index is :
>
> 1.B- tree or the alike.
>
> 2.hash structures
>
Not only. R-tree, SS-tree, kd-tree, RD-tree etc

> So the question is arise:In the tsearch2 model, I thought the general
> access method is GiST tree, a tree this like B- tree.
>
> But when I saw the crc32_sz() function to hash the tsvector type, the
> index implementation again turns to be a hash list,
>
>
> which is the right? hash structures or tree like B tree to implment the
> index?

None of them. Tsearch2 use signature tree, which is very close to RD-tree.

GiST (its realisation in pgsql) can store tree likes to R-tree or B-tree (with
some limitations, such as now pgsql's GiST doesn't support order).

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2005-10-20 09:21:55 some interes. doc about job scheduling
Previous Message Richard Huxton 2005-10-20 08:38:05 Re: changing create table