postgrespro / pgsphere

PgSphere provides spherical data types, functions, operators, and indexing for PostgreSQL.
https://pgsphere.org
BSD 3-Clause "New" or "Revised" License
16 stars 15 forks source link

Configurable smoc_gin_ops index resolution #86

Closed df7cb closed 8 months ago

df7cb commented 8 months ago

Back when smoc GIN indexes were implemented, indexes did not support opclass options yet; that was added only later in PG 13.

Add an "order" parameter on the smoc_gin_ops opclass to allow picking the smoc index granularity between level 0 and 12. (Larger levels do not fit into the internal int32 datatype anymore.)

Example: create index on sky using gin (coverage smoc_gin_ops (order = 8))