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/float4_bloom_ops (class) BRIN classes

  BRIN operator class for float4; member of float_bloom_ops.

  1011121314151617181920
• brin/float4_minmax_multi_ops (class) BRIN classes

  BRIN operator class for float4; member of float_minmax_multi_ops.

  1011121314151617181920
• brin/float4_minmax_ops (class) BRIN classes

  BRIN operator class for float4; member of float_minmax_ops.

  1011121314151617181920
• brin/float8_bloom_ops (class) BRIN classes

  BRIN operator class for float8; member of float_bloom_ops.

  1011121314151617181920
• brin/float8_minmax_multi_ops (class) BRIN classes

  BRIN operator class for float8; member of float_minmax_multi_ops.

  1011121314151617181920
• brin/float8_minmax_ops (class) BRIN classes

  BRIN operator class for float8; member of float_minmax_ops.

  1011121314151617181920
• brin/inet_bloom_ops (class) BRIN classes

  BRIN operator class for inet; member of network_bloom_ops.

  1011121314151617181920
• brin/inet_inclusion_ops (class) BRIN classes

  BRIN operator class for inet; member of network_inclusion_ops.

  1011121314151617181920
• brin/inet_minmax_multi_ops (class) BRIN classes

  BRIN operator class for inet; member of network_minmax_multi_ops.

  1011121314151617181920
• brin/inet_minmax_ops (class) BRIN classes

  BRIN operator class for inet; member of network_minmax_ops.

  1011121314151617181920
• brin/int2_bloom_ops (class) BRIN classes

  BRIN operator class for int2; member of integer_bloom_ops.

  1011121314151617181920
• brin/int2_minmax_multi_ops (class) BRIN classes

  BRIN operator class for int2; member of integer_minmax_multi_ops.

  1011121314151617181920
• brin/int2_minmax_ops (class) BRIN classes

  BRIN operator class for int2; member of integer_minmax_ops.

  1011121314151617181920
• brin/int4_bloom_ops (class) BRIN classes

  BRIN operator class for int4; member of integer_bloom_ops.

  1011121314151617181920
• brin/int4_minmax_multi_ops (class) BRIN classes

  BRIN operator class for int4; member of integer_minmax_multi_ops.

  1011121314151617181920
• brin/int4_minmax_ops (class) BRIN classes

  BRIN operator class for int4; member of integer_minmax_ops.

  1011121314151617181920
• brin/int8_bloom_ops (class) BRIN classes

  BRIN operator class for int8; member of integer_bloom_ops.

  1011121314151617181920
• brin/int8_minmax_multi_ops (class) BRIN classes

  BRIN operator class for int8; member of integer_minmax_multi_ops.

  1011121314151617181920
• brin/int8_minmax_ops (class) BRIN classes

  BRIN operator class for int8; member of integer_minmax_ops.

  1011121314151617181920
• brin/interval_bloom_ops (class) BRIN classes

  BRIN operator class for interval; member of interval_bloom_ops.

  1011121314151617181920
• brin/interval_minmax_multi_ops (class) BRIN classes

  BRIN operator class for interval; member of interval_minmax_multi_ops.

  1011121314151617181920
• brin/interval_minmax_ops (class) BRIN classes

  BRIN operator class for interval; member of interval_minmax_ops.

  1011121314151617181920
• brin/macaddr8_bloom_ops (class) BRIN classes

  BRIN operator class for macaddr8; member of macaddr8_bloom_ops.

  1011121314151617181920
• brin/macaddr8_minmax_multi_ops (class) BRIN classes

  BRIN operator class for macaddr8; member of macaddr8_minmax_multi_ops.

  1011121314151617181920
• brin/macaddr8_minmax_ops (class) BRIN classes

  BRIN operator class for macaddr8; member of macaddr8_minmax_ops.

  1011121314151617181920
• brin/macaddr_bloom_ops (class) BRIN classes

  BRIN operator class for macaddr; member of macaddr_bloom_ops.

  1011121314151617181920
• brin/macaddr_minmax_multi_ops (class) BRIN classes

  BRIN operator class for macaddr; member of macaddr_minmax_multi_ops.

  1011121314151617181920
• brin/macaddr_minmax_ops (class) BRIN classes

  BRIN operator class for macaddr; member of macaddr_minmax_ops.

  1011121314151617181920
• brin/name_bloom_ops (class) BRIN classes

  BRIN operator class for name; member of name_bloom_ops.

  1011121314151617181920
• brin/name_minmax_ops (class) BRIN classes

  BRIN operator class for name; member of name_minmax_ops.

  1011121314151617181920
• brin/numeric_bloom_ops (class) BRIN classes

  BRIN operator class for numeric; member of numeric_bloom_ops.

  1011121314151617181920
• brin/numeric_minmax_multi_ops (class) BRIN classes

  BRIN operator class for numeric; member of numeric_minmax_multi_ops.

  1011121314151617181920
• brin/numeric_minmax_ops (class) BRIN classes

  BRIN operator class for numeric; member of numeric_minmax_ops.

  1011121314151617181920
• brin/oid_bloom_ops (class) BRIN classes

  BRIN operator class for oid; member of oid_bloom_ops.

  1011121314151617181920
• brin/oid_minmax_multi_ops (class) BRIN classes

  BRIN operator class for oid; member of oid_minmax_multi_ops.

  1011121314151617181920
• brin/oid_minmax_ops (class) BRIN classes

  BRIN operator class for oid; member of oid_minmax_ops.

  1011121314151617181920
• brin/pg_lsn_bloom_ops (class) BRIN classes

  BRIN operator class for pg_lsn; member of pg_lsn_bloom_ops.

  1011121314151617181920
• brin/pg_lsn_minmax_multi_ops (class) BRIN classes

  BRIN operator class for pg_lsn; member of pg_lsn_minmax_multi_ops.

  1011121314151617181920
• brin/pg_lsn_minmax_ops (class) BRIN classes

  BRIN operator class for pg_lsn; member of pg_lsn_minmax_ops.

  1011121314151617181920
• brin/range_inclusion_ops (class) BRIN classes

  BRIN operator class for anyrange; member of range_inclusion_ops.

  1011121314151617181920
• brin/reltime_minmax_ops (class) BRIN classes not in 18

  Not recorded in the selected version.

  1011121314151617181920
• brin/text_bloom_ops (class) BRIN classes

  BRIN operator class for text; member of text_bloom_ops.

  1011121314151617181920
• brin/text_minmax_ops (class) BRIN classes

  BRIN operator class for text; member of text_minmax_ops.

  1011121314151617181920
• brin/tid_bloom_ops (class) BRIN classes

  BRIN operator class for tid; member of tid_bloom_ops.

  1011121314151617181920
• brin/tid_minmax_multi_ops (class) BRIN classes

  BRIN operator class for tid; member of tid_minmax_multi_ops.

  1011121314151617181920
• brin/tid_minmax_ops (class) BRIN classes

  BRIN operator class for tid; member of tid_minmax_ops.

  1011121314151617181920
• brin/time_bloom_ops (class) BRIN classes

  BRIN operator class for time; member of time_bloom_ops.

  1011121314151617181920
• brin/time_minmax_multi_ops (class) BRIN classes

  BRIN operator class for time; member of time_minmax_multi_ops.

  1011121314151617181920
• brin/time_minmax_ops (class) BRIN classes

  BRIN operator class for time; member of time_minmax_ops.

  1011121314151617181920
• brin/timestamp_bloom_ops (class) BRIN classes

  BRIN operator class for timestamp; member of datetime_bloom_ops.

  1011121314151617181920
• brin/timestamp_minmax_multi_ops (class) BRIN classes

  BRIN operator class for timestamp; member of datetime_minmax_multi_ops.

  1011121314151617181920
• brin/timestamp_minmax_ops (class) BRIN classes

  BRIN operator class for timestamp; member of datetime_minmax_ops.

  1011121314151617181920
• brin/timestamptz_bloom_ops (class) BRIN classes

  BRIN operator class for timestamptz; member of datetime_bloom_ops.

  1011121314151617181920
• brin/timestamptz_minmax_multi_ops (class) BRIN classes

  BRIN operator class for timestamptz; member of datetime_minmax_multi_ops.

  1011121314151617181920
• brin/timestamptz_minmax_ops (class) BRIN classes

  BRIN operator class for timestamptz; member of datetime_minmax_ops.

  1011121314151617181920
• brin/timetz_bloom_ops (class) BRIN classes

  BRIN operator class for timetz; member of timetz_bloom_ops.

  1011121314151617181920
• brin/timetz_minmax_multi_ops (class) BRIN classes

  BRIN operator class for timetz; member of timetz_minmax_multi_ops.

  1011121314151617181920
• brin/timetz_minmax_ops (class) BRIN classes

  BRIN operator class for timetz; member of timetz_minmax_ops.

  1011121314151617181920
• brin/uuid_bloom_ops (class) BRIN classes

  BRIN operator class for uuid; member of uuid_bloom_ops.

  1011121314151617181920
• brin/uuid_minmax_multi_ops (class) BRIN classes

  BRIN operator class for uuid; member of uuid_minmax_multi_ops.

  1011121314151617181920
• brin/uuid_minmax_ops (class) BRIN classes

  BRIN operator class for uuid; member of uuid_minmax_ops.

  1011121314151617181920
• brin/varbit_minmax_ops (class) BRIN classes

  BRIN operator class for varbit; member of varbit_minmax_ops.

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

  Not recorded in the selected version.

  1011121314151617181920
• brin/bit_minmax_ops (family) BRIN families

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

  1011121314151617181920
• brin/box_inclusion_ops (family) BRIN families

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

  1011121314151617181920
• brin/bpchar_bloom_ops (family) BRIN families

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

  1011121314151617181920
• brin/bpchar_minmax_ops (family) BRIN families

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

  1011121314151617181920
• brin/bytea_bloom_ops (family) BRIN families

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

  1011121314151617181920
• brin/bytea_minmax_ops (family) BRIN families

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

  1011121314151617181920
• brin/char_bloom_ops (family) BRIN families

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

  1011121314151617181920
• brin/char_minmax_ops (family) BRIN families

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

  1011121314151617181920
• brin/datetime_bloom_ops (family) BRIN families

  BRIN operator family containing 3 classes, 3 operator strategies and 18 support functions in this source build.

  1011121314151617181920
• brin/datetime_minmax_multi_ops (family) BRIN families

  BRIN operator family containing 3 classes, 45 operator strategies and 18 support functions in this source build.

  1011121314151617181920
• brin/datetime_minmax_ops (family) BRIN families

  BRIN operator family containing 3 classes, 45 operator strategies and 12 support functions in this source build.

  1011121314151617181920
• brin/float_bloom_ops (family) BRIN families

  BRIN operator family containing 2 classes, 2 operator strategies and 12 support functions in this source build.

  1011121314151617181920
• brin/float_minmax_multi_ops (family) BRIN families

  BRIN operator family containing 2 classes, 20 operator strategies and 12 support functions in this source build.

  1011121314151617181920
• brin/float_minmax_ops (family) BRIN families

  BRIN operator family containing 2 classes, 20 operator strategies and 8 support functions in this source build.

  1011121314151617181920
• brin/integer_bloom_ops (family) BRIN families

  BRIN operator family containing 3 classes, 3 operator strategies and 18 support functions in this source build.

  1011121314151617181920
• brin/integer_minmax_multi_ops (family) BRIN families

  BRIN operator family containing 3 classes, 45 operator strategies and 18 support functions in this source build.

  1011121314151617181920
• brin/integer_minmax_ops (family) BRIN families

  BRIN operator family containing 3 classes, 45 operator strategies and 12 support functions in this source build.

  1011121314151617181920
• brin/interval_bloom_ops (family) BRIN families

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

  1011121314151617181920
• brin/interval_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/interval_minmax_ops (family) BRIN families

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

  1011121314151617181920
• brin/macaddr8_bloom_ops (family) BRIN families

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

  1011121314151617181920
• brin/macaddr8_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/macaddr8_minmax_ops (family) BRIN families

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

  1011121314151617181920
• brin/macaddr_bloom_ops (family) BRIN families

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

  1011121314151617181920
• brin/macaddr_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/macaddr_minmax_ops (family) BRIN families

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

  1011121314151617181920
• brin/name_bloom_ops (family) BRIN families

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

  1011121314151617181920
• brin/name_minmax_ops (family) BRIN families

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

  1011121314151617181920
• brin/network_bloom_ops (family) BRIN families

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

  1011121314151617181920
• brin/network_inclusion_ops (family) BRIN families

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

  1011121314151617181920
• brin/network_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/network_minmax_ops (family) BRIN families

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

  1011121314151617181920
• brin/numeric_bloom_ops (family) BRIN families

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

  1011121314151617181920
• brin/numeric_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/numeric_minmax_ops (family) BRIN families

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

  1011121314151617181920
• brin/oid_bloom_ops (family) BRIN families

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

  1011121314151617181920
• brin/oid_minmax_multi_ops (family) BRIN families

  BRIN operator family containing 1 classes, 5 operator strategies and 6 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.