65.2. Built-in Operator Classes
The core PostgreSQL distribution includes the SP-GiST operator classes shown in Table 65.1.
Table 65.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 or polygon data sets.