Re: Speed Question
От | Noah Silverman |
---|---|
Тема | Re: Speed Question |
Дата | |
Msg-id | 2FB53415-16C1-11D7-A512-000393AA8F3C@allresearch.com обсуждение исходный текст |
Ответ на | Re: Speed Question (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-performance |
Does anyone know how/where I can find the contrib/btree_gist stuff and how I use it, and are there docs for it. Thanks, -N On Saturday, December 21, 2002, at 03:28 PM, Tom Lane wrote: > Manfred Koizar <mkoi-pg@aon.at> writes: >> ... where "similar" means that the value of each attribute lies within >> a small range around the value of the corresponding attribute of the >> reference object? > >> I don't know, whether GiST or R-Tree could help. > > If the problem is multidimensional range search then GIST might be just > the ticket. I am not sure if you'd need to do any coding though. It > looks like contrib/btree_gist provides the necessary operator class, > but > only for int4 and timestamp datatypes. > > I think that our r-tree code is restricted to two-dimensional indexing, > so it wouldn't help. > > regards, tom lane >
В списке pgsql-performance по дате отправления: