Re: RTREE on points - Mailing list pgsql-sql

From Jeff Hoffmann
Subject Re: RTREE on points
Date
Msg-id 3ADC7E8F.7569BABD@propertykey.com
Whole thread Raw
In response to RTREE on points  ("Julian Scarfe" <julian@avbrief.com>)
Responses Re: RTREE on points
Re: RTREE on points
List pgsql-sql
Tom Lane wrote:
> 
> I don't recall any such thing having been removed, but it does seem
> peculiar that there are no GIST opclasses in the standard distribution.
> How the heck did the GIST index code get developed/tested without some
> opclasses?

doing some digging at berkeley, i found the original pggist patch file
that created the gist access method & gist_box_ops opclass (among
others).  i'm assuming that patch was the basis for what was originally
introduced, so i don't know why it didn't get included with everything
else.  it looks like there are a lot of calls to internal postgresql box
comparison functions that would need to get converted to the new calling
convention, but it should be pretty straightforward to get it to work
with a recent version of postgresql.   it does seem pretty silly to have
it in there if you don't have any built-in way of using it, if for no
other reason than to be able to test if the feature even works. 

-- 

Jeff Hoffmann
PropertyKey.com


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] drastic reduction in speed of inserts as the table grows
Next
From: Tom Lane
Date:
Subject: Re: RTREE on points