Internals//SP-GiST Indexes: Built-in Operator Classes

The core PostgreSQL distribution includes the SP-GiST operator classes shown in Table 62-1.

Table 62-1. Built-in SP-GiST Operator Classes

Name	Indexed Data Type	Indexable Operators
`kd_point_ops`	`point`	`<<` `<@` `<^` `>>` `>^` `~=`
`quad_point_ops`	`point`	`<<` `<@` `<^` `>>` `>^` `~=`
`range_ops`	any range type	`&&` `&<` `&>` `-\|-` `<<` `<@` `=` `>>` `@>`
`box_ops`	`box`	`<<` `&<` `&&` `&>` `>>` `~=` `@>` `<@` `&<\|` `<<\|` `\|>>` `\|&>`
`text_ops`	`text`	`<` `<=` `=` `>` `>=` `~<=~` `~<~` `~>=~` `~>~`

Of the two operator classes for type point, quad_point_ops is the default. kd_point_ops supports the same operators but uses a different index data structure which may offer better performance in some applications.

Prev		Next
Introduction	Up	Extensibility

Links:

https://www.postgresql.org/docs/9.6/static/spgist-builtin-opclasses.html

doc_PostgreSQL

2016-10-12 11:33:34

Comments

Popular Articles

Internals//GiST Indexes: Built-in Operator Classes The core PostgreSQL distribution includes the GiST operator classes shown in Table 61-1. (Some of the optional modules described in Appendix F provid

Internals//BRIN Indexes: Built-in Operator Classes The core PostgreSQL distribution includes the BRIN operator classes shown in Table 64-1. The minmax operator classes store the minimum and the maximu

Internals//SP-GiST Indexes SP-GiST is an abbreviation for space-partitioned GiST. SP-GiST supports partitioned search trees, which facilitate development of a wide range of dif

Internals//GIN Indexes: Built-in Operator Classes The core PostgreSQL distribution includes the GIN operator classes shown in Table 63-1. (Some of the optional modules described in Appendix F provide

Internals//SP-GiST Indexes: Implementation This section covers implementation details and other tricks that are useful for implementers of SP-GiST operator classes to know. 62.4.1. SP-GiST Li