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.
Please login to continue.