Wiki / Operator Families

Index operator classes and families, strategy operators and support functions.

Reading PostgreSQL 18.6.

Find an entry GroupAll groupsB-tree classes (48)B-tree families (40)BRIN classes (74)BRIN families (59)GIN classes (4)GIN families (4)GiST classes (9)GiST families (10)Hash classes (44)Hash families (38)SP-GiST classes (7)SP-GiST families (7) Apply

344 entries; 323 recorded in PostgreSQL 18.6.

• brin/oid_minmax_ops (family) BRIN families

  BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.

  1011121314151617181920
• brin/pg_lsn_bloom_ops (family) BRIN families

  BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.

  1011121314151617181920
• brin/pg_lsn_minmax_multi_ops (family) BRIN families

  BRIN operator family containing 1 classes, 5 operator strategies and 6 support functions in this source build.

  1011121314151617181920
• brin/pg_lsn_minmax_ops (family) BRIN families

  BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.

  1011121314151617181920
• brin/range_inclusion_ops (family) BRIN families

  BRIN operator family containing 1 classes, 14 operator strategies and 7 support functions in this source build.

  1011121314151617181920
• brin/reltime_minmax_ops (family) BRIN families not in 18

  Not recorded in the selected version.

  1011121314151617181920
• brin/text_bloom_ops (family) BRIN families

  BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.

  1011121314151617181920
• brin/text_minmax_ops (family) BRIN families

  BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.

  1011121314151617181920
• brin/tid_bloom_ops (family) BRIN families

  BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.

  1011121314151617181920
• brin/tid_minmax_multi_ops (family) BRIN families

  BRIN operator family containing 1 classes, 5 operator strategies and 6 support functions in this source build.

  1011121314151617181920
• brin/tid_minmax_ops (family) BRIN families

  BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.

  1011121314151617181920
• brin/time_bloom_ops (family) BRIN families

  BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.

  1011121314151617181920
• brin/time_minmax_multi_ops (family) BRIN families

  BRIN operator family containing 1 classes, 5 operator strategies and 6 support functions in this source build.

  1011121314151617181920
• brin/time_minmax_ops (family) BRIN families

  BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.

  1011121314151617181920
• brin/timetz_bloom_ops (family) BRIN families

  BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.

  1011121314151617181920
• brin/timetz_minmax_multi_ops (family) BRIN families

  BRIN operator family containing 1 classes, 5 operator strategies and 6 support functions in this source build.

  1011121314151617181920
• brin/timetz_minmax_ops (family) BRIN families

  BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.

  1011121314151617181920
• brin/uuid_bloom_ops (family) BRIN families

  BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.

  1011121314151617181920
• brin/uuid_minmax_multi_ops (family) BRIN families

  BRIN operator family containing 1 classes, 5 operator strategies and 6 support functions in this source build.

  1011121314151617181920
• brin/uuid_minmax_ops (family) BRIN families

  BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.

  1011121314151617181920
• brin/varbit_minmax_ops (family) BRIN families

  BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.

  1011121314151617181920
• gin/array_ops (class) GIN classes

  GIN operator class for anyarray; member of array_ops.

  1011121314151617181920
• gin/jsonb_ops (class) GIN classes

  GIN operator class for jsonb; member of jsonb_ops.

  1011121314151617181920
• gin/jsonb_path_ops (class) GIN classes

  GIN operator class for jsonb; member of jsonb_path_ops.

  1011121314151617181920
• gin/tsvector_ops (class) GIN classes

  GIN operator class for tsvector; member of tsvector_ops.

  1011121314151617181920
• gin/array_ops (family) GIN families

  GIN operator family containing 1 classes, 4 operator strategies and 4 support functions in this source build.

  1011121314151617181920
• gin/jsonb_ops (family) GIN families

  GIN operator family containing 1 classes, 6 operator strategies and 5 support functions in this source build.

  1011121314151617181920
• gin/jsonb_path_ops (family) GIN families

  GIN operator family containing 1 classes, 3 operator strategies and 5 support functions in this source build.

  1011121314151617181920
• gin/tsvector_ops (family) GIN families

  GIN operator family containing 1 classes, 2 operator strategies and 6 support functions in this source build.

  1011121314151617181920
• gist/box_ops (class) GiST classes

  GiST operator class for box; member of box_ops.

  1011121314151617181920
• gist/circle_ops (class) GiST classes

  GiST operator class for circle; member of circle_ops.

  1011121314151617181920
• gist/inet_ops (class) GiST classes

  GiST operator class for inet; member of network_ops.

  1011121314151617181920
• gist/multirange_ops (class) GiST classes

  GiST operator class for anymultirange; member of multirange_ops.

  1011121314151617181920
• gist/point_ops (class) GiST classes

  GiST operator class for point; member of point_ops.

  1011121314151617181920
• gist/poly_ops (class) GiST classes

  GiST operator class for polygon; member of poly_ops.

  1011121314151617181920
• gist/range_ops (class) GiST classes

  GiST operator class for anyrange; member of range_ops.

  1011121314151617181920
• gist/tsquery_ops (class) GiST classes

  GiST operator class for tsquery; member of tsquery_ops.

  1011121314151617181920
• gist/tsvector_ops (class) GiST classes

  GiST operator class for tsvector; member of tsvector_ops.

  1011121314151617181920
• gist/box_ops (family) GiST families

  GiST operator family containing 1 classes, 13 operator strategies and 7 support functions in this source build.

  1011121314151617181920
• gist/circle_ops (family) GiST families

  GiST operator family containing 1 classes, 13 operator strategies and 8 support functions in this source build.

  1011121314151617181920
• gist/jsonb_ops (family) GiST families not in 18

  Not recorded in the selected version.

  1011121314151617181920
• gist/multirange_ops (family) GiST families

  GiST operator family containing 1 classes, 18 operator strategies and 7 support functions in this source build.

  1011121314151617181920
• gist/network_ops (family) GiST families

  GiST operator family containing 1 classes, 11 operator strategies and 8 support functions in this source build.

  1011121314151617181920
• gist/point_ops (family) GiST families

  GiST operator family containing 1 classes, 11 operator strategies and 9 support functions in this source build.

  1011121314151617181920
• gist/poly_ops (family) GiST families

  GiST operator family containing 1 classes, 13 operator strategies and 8 support functions in this source build.

  1011121314151617181920
• gist/range_ops (family) GiST families

  GiST operator family containing 1 classes, 18 operator strategies and 7 support functions in this source build.

  1011121314151617181920
• gist/tsquery_ops (family) GiST families

  GiST operator family containing 1 classes, 2 operator strategies and 6 support functions in this source build.

  1011121314151617181920
• gist/tsvector_ops (family) GiST families

  GiST operator family containing 1 classes, 1 operator strategies and 8 support functions in this source build.

  1011121314151617181920
• hash/abstime_ops (class) Hash classes not in 18

  Not recorded in the selected version.

  1011121314151617181920
• hash/aclitem_ops (class) Hash classes

  Hash operator class for aclitem; member of aclitem_ops.

  1011121314151617181920
• hash/array_ops (class) Hash classes

  Hash operator class for anyarray; member of array_ops.

  1011121314151617181920
• hash/bool_ops (class) Hash classes

  Hash operator class for bool; member of bool_ops.

  1011121314151617181920
• hash/bpchar_ops (class) Hash classes

  Hash operator class for bpchar; member of bpchar_ops.

  1011121314151617181920
• hash/bpchar_pattern_ops (class) Hash classes

  Hash operator class for bpchar; member of bpchar_pattern_ops.

  1011121314151617181920
• hash/bytea_ops (class) Hash classes

  Hash operator class for bytea; member of bytea_ops.

  1011121314151617181920
• hash/char_ops (class) Hash classes

  Hash operator class for char; member of char_ops.

  1011121314151617181920
• hash/cid_ops (class) Hash classes

  Hash operator class for cid; member of cid_ops.

  1011121314151617181920
• hash/cidr_ops (class) Hash classes

  Hash operator class for inet; member of network_ops.

  1011121314151617181920
• hash/date_ops (class) Hash classes

  Hash operator class for date; member of date_ops.

  1011121314151617181920
• hash/enum_ops (class) Hash classes

  Hash operator class for anyenum; member of enum_ops.

  1011121314151617181920
• hash/float4_ops (class) Hash classes

  Hash operator class for float4; member of float_ops.

  1011121314151617181920
• hash/float8_ops (class) Hash classes

  Hash operator class for float8; member of float_ops.

  1011121314151617181920
• hash/inet_ops (class) Hash classes

  Hash operator class for inet; member of network_ops.

  1011121314151617181920
• hash/int2_ops (class) Hash classes

  Hash operator class for int2; member of integer_ops.

  1011121314151617181920
• hash/int4_ops (class) Hash classes

  Hash operator class for int4; member of integer_ops.

  1011121314151617181920
• hash/int8_ops (class) Hash classes

  Hash operator class for int8; member of integer_ops.

  1011121314151617181920
• hash/interval_ops (class) Hash classes

  Hash operator class for interval; member of interval_ops.

  1011121314151617181920
• hash/jsonb_ops (class) Hash classes

  Hash operator class for jsonb; member of jsonb_ops.

  1011121314151617181920
• hash/macaddr8_ops (class) Hash classes

  Hash operator class for macaddr8; member of macaddr8_ops.

  1011121314151617181920
• hash/macaddr_ops (class) Hash classes

  Hash operator class for macaddr; member of macaddr_ops.

  1011121314151617181920
• hash/multirange_ops (class) Hash classes

  Hash operator class for anymultirange; member of multirange_ops.

  1011121314151617181920
• hash/name_ops (class) Hash classes

  Hash operator class for name; member of text_ops.

  1011121314151617181920
• hash/numeric_ops (class) Hash classes

  Hash operator class for numeric; member of numeric_ops.

  1011121314151617181920
• hash/oid8_ops (class) Hash classes not in 18

  Not recorded in the selected version.

  1011121314151617181920
• hash/oid_ops (class) Hash classes

  Hash operator class for oid; member of oid_ops.

  1011121314151617181920
• hash/oidvector_ops (class) Hash classes

  Hash operator class for oidvector; member of oidvector_ops.

  1011121314151617181920
• hash/pg_lsn_ops (class) Hash classes

  Hash operator class for pg_lsn; member of pg_lsn_ops.

  1011121314151617181920
• hash/range_ops (class) Hash classes

  Hash operator class for anyrange; member of range_ops.

  1011121314151617181920
• hash/record_ops (class) Hash classes

  Hash operator class for record; member of record_ops.

  1011121314151617181920
• hash/reltime_ops (class) Hash classes not in 18

  Not recorded in the selected version.

  1011121314151617181920
• hash/text_ops (class) Hash classes

  Hash operator class for text; member of text_ops.

  1011121314151617181920
• hash/text_pattern_ops (class) Hash classes

  Hash operator class for text; member of text_pattern_ops.

  1011121314151617181920
• hash/tid_ops (class) Hash classes

  Hash operator class for tid; member of tid_ops.

  1011121314151617181920
• hash/time_ops (class) Hash classes

  Hash operator class for time; member of time_ops.

  1011121314151617181920
• hash/timestamp_ops (class) Hash classes

  Hash operator class for timestamp; member of timestamp_ops.

  1011121314151617181920
• hash/timestamptz_ops (class) Hash classes

  Hash operator class for timestamptz; member of timestamptz_ops.

  1011121314151617181920
• hash/timetz_ops (class) Hash classes

  Hash operator class for timetz; member of timetz_ops.

  1011121314151617181920
• hash/uuid_ops (class) Hash classes

  Hash operator class for uuid; member of uuid_ops.

  1011121314151617181920
• hash/varchar_ops (class) Hash classes

  Hash operator class for text; member of text_ops.

  1011121314151617181920
• hash/varchar_pattern_ops (class) Hash classes

  Hash operator class for text; member of text_pattern_ops.

  1011121314151617181920
• hash/xid8_ops (class) Hash classes

  Hash operator class for xid8; member of xid8_ops.

  1011121314151617181920
• hash/xid_ops (class) Hash classes

  Hash operator class for xid; member of xid_ops.

  1011121314151617181920
• hash/abstime_ops (family) Hash families not in 18

  Not recorded in the selected version.

  1011121314151617181920
• hash/aclitem_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/array_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/bool_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/bpchar_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/bpchar_pattern_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/bytea_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/char_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920

RecordedFirst recordedInterface or attribute changeNo longer recorded

Squares indicate presence in sampled builds, not first introduction. Select a square for the same-version definition and sources.

Changes in PostgreSQL 18.6 · Export JSON

Reading this collection

Classes and families are separate identities. Family operators include cross-type members; strategy and support-function numbers have meanings specific to the index method. Extension-created objects are outside the core inventory.