Skip site navigation (1) Skip section navigation (2)

Re: Speed Question

From: Noah Silverman <noah(at)allresearch(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Manfred Koizar <mkoi-pg(at)aon(dot)at>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Speed Question
Date: 2002-12-23 21:55:01
Message-ID: 2FB53415-16C1-11D7-A512-000393AA8F3C@allresearch.com (view raw or flat)
Thread:
Lists: 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(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: Bruno Wolff IIIDate: 2002-12-24 20:16:38
Subject: View performance
Previous:From: Tom LaneDate: 2002-12-23 02:36:27
Subject: Re: PerformPortalClose warning in 7.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group