git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 87545f5) | patch
Introduce SP-GiST operator class over box.
2016年3月30日 15:42:36 +0000 (18:42 +0300)
2016年3月30日 15:42:36 +0000 (18:42 +0300)
commit acdf2a8b372aec1da09370fca77ff7dccac7646d
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
12 files changed:
doc/src/sgml/spgist.sgml diff | blob | blame | history
src/backend/utils/adt/Makefile diff | blob | blame | history
src/backend/utils/adt/geo_spgist.c [new file with mode: 0644] blob
src/include/catalog/pg_amop.h diff | blob | blame | history
src/include/catalog/pg_amproc.h diff | blob | blame | history
src/include/catalog/pg_opclass.h diff | blob | blame | history
src/include/catalog/pg_opfamily.h diff | blob | blame | history
src/include/catalog/pg_proc.h diff | blob | blame | history
src/include/utils/geo_decls.h diff | blob | blame | history
src/test/regress/expected/box.out diff | blob | blame | history
src/test/regress/expected/opr_sanity.out diff | blob | blame | history
src/test/regress/sql/box.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /