Re: [GENERAL] RE: [HACKERS] Indexing for geographic objects?

2000-12-05 Thread Bernard Frankpitt
Edmar Wiggers wrote: > > It seems that R-trees become inefficient when the number of dimensions > increase. Has anyone thoght of a transparent way to use Peano codes (hhcode > in Oracle lingo), and use B-tree indexes instead? > Do you have a reference, or more information on what a Peano code i

[GENERAL] RE: [HACKERS] Indexing for geographic objects?

2000-12-05 Thread Edmar Wiggers
It seems that R-trees become inefficient when the number of dimensions increase. Has anyone thoght of a transparent way to use Peano codes (hhcode in Oracle lingo), and use B-tree indexes instead? Also, I've read that R-trees sometimes suffer a lot when an update overflows a node in the index. T

[GENERAL] Re: [HACKERS] Indexing for geographic objects?

2000-11-27 Thread Tom Lane
[EMAIL PROTECTED] writes: > Tom Lane wrote: >> Do you have any problem with releasing your stuff under the Postgres >> distribution terms (BSD license)? > No, I don't see any problem with the BSD license, or any other > license, for that matter. I just had some reservations about releasing > stuf

[GENERAL] Re: [HACKERS] Indexing for geographic objects?

2000-11-27 Thread Tom Lane
[EMAIL PROTECTED] writes: > Tom Lane wrote: >> Michael Ansley <[EMAIL PROTECTED]> writes: Remember also that the GiST library has been integrated into PG, (my brother is doing some thesis workon that at the moment), >> >> Yeah? Does it still work? > You bet. One would otherwise be hea

[GENERAL] RE: [HACKERS] Indexing for geographic objects?

2000-11-27 Thread Michael Ansley
Title: RE: [HACKERS] Indexing for geographic objects? To be honest, Tom, I've always seen GiST not just as a great feature, but as an essential feature.  Using Stonebraker's definition of an object-relational database (which I tend to do, as it's the only one that I've read about in depth), w

[GENERAL] Re: [HACKERS] Indexing for geographic objects?

2000-11-26 Thread Tom Lane
Michael Ansley <[EMAIL PROTECTED]> writes: > Remember also that the GiST library has been integrated into PG, (my brother > is doing some thesis workon that at the moment), Yeah? Does it still work? Since the GIST code is not tested by any standard regress test, and is so poorly documented that

[GENERAL] RE: [HACKERS] Indexing for geographic objects?

2000-11-26 Thread Michael Ansley
Title: RE: [HACKERS] Indexing for geographic objects? Hi, Remember also that the GiST library has been integrated into PG, (my brother is doing some thesis workon that at the moment), and you can create new index types relatively quickly (assuming that you understand the indexing theory ;-)

[GENERAL] Re: [HACKERS] Indexing for geographic objects?

2000-11-25 Thread Tom Lane
Franck Martin <[EMAIL PROTECTED]> writes: > I would greatly appreciate if someone could guide me through the > methodology to build an index for a custom type or point me to some > readings where the algorithm is explained (web, book, etc...). The Programmer's Guide chapter "Interfacing Extension