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