From: | Paul Ramsey <pramsey(at)cleverelephant(dot)ca> |
---|---|
To: | Jeff Davis <pgsql(at)j-davis(dot)com> |
Cc: | Viktor Rosenfeld <listuser36(at)googlemail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: R-Trees in PostgreSQL |
Date: | 2009-11-03 00:42:43 |
Message-ID: | 30fe546d0911021642u2c76ee95t1e1e8c8aafd32d9b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Also for one-dimensional ranges, consider contrib/seg
P.
On Mon, Nov 2, 2009 at 4:41 PM, Jeff Davis <pgsql(at)j-davis(dot)com> wrote:
> On Tue, 2009-11-03 at 00:25 +0100, Viktor Rosenfeld wrote:
>> I'd like to know what kind of functions I have to implement for a R-Tree
>> index on numeric columns,
>
> NUMERIC is scalar, so an R-Tree doesn't make much sense. You can install
> btree_gist (a contrib module) to be able to use numeric columns as part
> of a GiST index.
>
> If you have more complex spatial data, you should look into PostGIS.
>
> Regards,
> Jeff Davis
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2009-11-03 01:01:46 | Re: Help with postgresql memory issue |
Previous Message | Jeff Davis | 2009-11-03 00:41:19 | Re: R-Trees in PostgreSQL |