Manfred Koizar <mkoi-pg(at)aon(dot)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
In response to
pgsql-performance by date
|Next:||From: Gerhard Haering||Date: 2002-12-23 01:18:46|
|Subject: Re: PerformPortalClose warning in 7.3|
|Previous:||From: Noah Silverman||Date: 2002-12-21 20:17:53|
|Subject: Re: Speed Question|