Обсуждение: tsearch2 's access method?

Поиск
Список
Период
Сортировка

tsearch2 's access method?

От
"沈一枫"
Дата:

the basic structures to implement  the index is :

1.B- tree or the alike.

2.hash structures

 

 

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? 

 

 




 






想 要 一 个 快 n 倍 的 免 费 邮 箱 吗 ?
126 专 业 电 子 邮 局 ―― 全 球 领 先 的 中 文 邮 箱 服 商 带 你 进 入 极 速 之 旅

Re: tsearch2 's access method?

От
Teodor Sigaev
Дата:

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