63.2. Built-in Operator Classes
The corePostgres Pro distribution includes theGIN operator classes shown inTable 63.1. (Some of the optional modules described inAppendix F provide additionalGIN operator classes.)
Table 63.1. Built-inGIN 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 typejsonb,jsonb_ops is the default.jsonb_path_ops supports fewer operators but offers better performance for those operators. SeeSection 8.14.4 for details.