The core PostgreSQL distribution includes the SP-GiST operator classes shown in Table 63.1.
Table 63.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 | <
<=
=
>
>=
~<=~
~<~
~>=~
~>~
|
inet_ops | inet, cidr | &&
>>
>>=
>
>=
<>
<<
<<=
<
<=
=
|
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.