pgsql: Introduce SP-GiST operator class over box.
От | Teodor Sigaev |
---|---|
Тема | pgsql: Introduce SP-GiST operator class over box. |
Дата | |
Msg-id | E1alIMG-0001Ut-O6@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Introduce SP-GiST operator class over box. Patch implements quad-tree over boxes, naive approach of 2D quad tree will not work for any non-point objects because splitting space on node is not efficient. The idea of pathc is treating 2D boxes as 4D points, so, object will not overlap (in 4D space). The performance tests reveal that this technique especially beneficial with too much overlapping objects, so called "spaghetti data". Author: Alexander Lebedev with editorization by Emre Hasegeli and me Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/acdf2a8b372aec1da09370fca77ff7dccac7646d Modified Files -------------- doc/src/sgml/spgist.sgml | 18 + src/backend/utils/adt/Makefile | 4 +- src/backend/utils/adt/geo_spgist.c | 699 +++++++++++++++++++++++++++++++ src/include/catalog/pg_amop.h | 16 + src/include/catalog/pg_amproc.h | 5 + src/include/catalog/pg_opclass.h | 1 + src/include/catalog/pg_opfamily.h | 1 + src/include/catalog/pg_proc.h | 11 + src/include/utils/geo_decls.h | 6 + src/test/regress/expected/box.out | 240 +++++++++++ src/test/regress/expected/opr_sanity.out | 6 +- src/test/regress/sql/box.sql | 62 +++ 12 files changed, 1066 insertions(+), 3 deletions(-)
В списке pgsql-committers по дате отправления: