PostgreSQL

PostgreSQL Elephant Logo

64.2. Built-in Operator Classes

The core PostgreSQL distribution includes the GIN operator classes shown in Table 64.1. (Some of the optional modules described in Appendix F provide additional GIN operator classes.)

Table 64.1. Built-in GIN Operator Classes

Name Indexed Data Type Indexable Operators

array_ops

anyarray

&& <@ = @>

jsonb_ops

jsonb

? ?& `+?

` `@>+`

jsonb_path_ops

jsonb

@>

tsvector_ops

tsvector

+

Of the two operator classes for type jsonb, jsonb_ops is the default. jsonb_path_ops supports fewer operators but offers better performance for those operators. See Section 8.14.4 for details.


Prev Up Next

64.1. Introduction

Home

64.3. Extensibility

Copyright © 1996-2023 The PostgreSQL Global Development Group