GiST a second class citizen?
От | Paul Ramsey |
---|---|
Тема | GiST a second class citizen? |
Дата | |
Msg-id | 3DEABABB.3050408@refractions.net обсуждение исходный текст |
Ответы |
Re: GiST a second class citizen?
|
Список | pgsql-hackers |
The PostGIS project has been making use of GiST for about a year now and (thanks to the excellent work of Oleg and Teodor) have found it to be a most excellent indexing system. We are about to apply for some government R&D funding, and one of our potential subprojects is creating GiST bindings for all the standard SQL PostgreSQL types. Why? Well, because our spatial indexes are GiST, providing bindings for the standard types allows us to do multi-key indexes which combine spatial and non-spatial data. That would be pretty unique in the DMBS world as it stands right now. So far, GiST is integrated into the main tree, but all the bindings seem to be kept outside, in contrib (ltree, btree, rtree). If there were a complete set of GiST b-tree bindings available for the builtin types, where would/should they reside? Would I be completely out-to-lunch if I suggested that the GiST bindings might even replace the standard ones? The ability to multikey indexes of wierd-and-crazy-types with normal-boring-types seems like a halmark of a Real Live Object-Relational DBMS. Thoughts? Paul
В списке pgsql-hackers по дате отправления: