61.2. Built-in Operator Classes
The core Postgres Pro distribution includes the SP-GiST operator classes shown in Table 61.1.
Table 61.1. Built-in SP-GiST Operator Classes
|Name||Indexed Data Type||Indexable Operators||Ordering Operators|
|any range type|
Of the two operator classes for type
quad_point_ops is the default.
kd_point_ops supports the same operators but uses a different index data structure that may offer better performance in some applications.
poly_ops operator classes support the
<-> ordering operator, which enables the k-nearest neighbor (
k-NN) search over indexed point, circle, or polygon datasets.