diff options
| author | Teodor Sigaev <teodor@sigaev.ru> | 2016-03-30 18:42:36 +0300 |
|---|---|---|
| committer | Teodor Sigaev <teodor@sigaev.ru> | 2016-03-30 18:42:36 +0300 |
| commit | acdf2a8b372aec1da09370fca77ff7dccac7646d (patch) | |
| tree | bbba6257f0428d6a1e7d36e9919429274a75e70a /src/include/catalog/pg_amproc.h | |
| parent | 87545f541278ffde4fa1ccf396affbc4e9d59a23 (diff) | |
| download | postgresql-acdf2a8b372aec1da09370fca77ff7dccac7646d.tar.gz | |
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
Diffstat (limited to 'src/include/catalog/pg_amproc.h')
| -rw-r--r-- | src/include/catalog/pg_amproc.h | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/src/include/catalog/pg_amproc.h b/src/include/catalog/pg_amproc.h index f0ae008704..00320b4c33 100644 --- a/src/include/catalog/pg_amproc.h +++ b/src/include/catalog/pg_amproc.h @@ -443,6 +443,11 @@ DATA(insert ( 4017 25 25 2 4028 )); DATA(insert ( 4017 25 25 3 4029 )); DATA(insert ( 4017 25 25 4 4030 )); DATA(insert ( 4017 25 25 5 4031 )); +DATA(insert ( 5000 603 603 1 5012 )); +DATA(insert ( 5000 603 603 2 5013 )); +DATA(insert ( 5000 603 603 3 5014 )); +DATA(insert ( 5000 603 603 4 5015 )); +DATA(insert ( 5000 603 603 5 5016 )); /* BRIN opclasses */ /* minmax bytea */ |