Home • Explore • Blog • CI
☰



postgresql
11th chunk of `doc/src/sgml/brin.sgml`
4f022eecab956ba277cfe704cbaa1045a19784bb1d6d07180000000100000fa0
 <row><entry><literal>&lt; (time,time)</literal></entry></row>
    <row><entry><literal>&lt;= (time,time)</literal></entry></row>
    <row><entry><literal>&gt; (time,time)</literal></entry></row>
    <row><entry><literal>&gt;= (time,time)</literal></entry></row>

    <row>
     <entry valign="middle" morerows="4"><literal>time_minmax_multi_ops</literal></entry>
     <entry><literal>= (time,time)</literal></entry>
    </row>
    <row><entry><literal>&lt; (time,time)</literal></entry></row>
    <row><entry><literal>&lt;= (time,time)</literal></entry></row>
    <row><entry><literal>&gt; (time,time)</literal></entry></row>
    <row><entry><literal>&gt;= (time,time)</literal></entry></row>

    <row>
     <entry valign="middle"><literal>timetz_bloom_ops</literal></entry>
     <entry><literal>= (timetz,timetz)</literal></entry>
    </row>

    <row>
     <entry valign="middle" morerows="4"><literal>timetz_minmax_ops</literal></entry>
     <entry><literal>= (timetz,timetz)</literal></entry>
    </row>
    <row><entry><literal>&lt; (timetz,timetz)</literal></entry></row>
    <row><entry><literal>&lt;= (timetz,timetz)</literal></entry></row>
    <row><entry><literal>&gt; (timetz,timetz)</literal></entry></row>
    <row><entry><literal>&gt;= (timetz,timetz)</literal></entry></row>

    <row>
     <entry valign="middle" morerows="4"><literal>timetz_minmax_multi_ops</literal></entry>
     <entry><literal>= (timetz,timetz)</literal></entry>
    </row>
    <row><entry><literal>&lt; (timetz,timetz)</literal></entry></row>
    <row><entry><literal>&lt;= (timetz,timetz)</literal></entry></row>
    <row><entry><literal>&gt; (timetz,timetz)</literal></entry></row>
    <row><entry><literal>&gt;= (timetz,timetz)</literal></entry></row>

    <row>
     <entry valign="middle"><literal>uuid_bloom_ops</literal></entry>
     <entry><literal>= (uuid,uuid)</literal></entry>
    </row>

    <row>
     <entry valign="middle" morerows="4"><literal>uuid_minmax_ops</literal></entry>
     <entry><literal>= (uuid,uuid)</literal></entry>
    </row>
    <row><entry><literal>&lt; (uuid,uuid)</literal></entry></row>
    <row><entry><literal>&gt; (uuid,uuid)</literal></entry></row>
    <row><entry><literal>&lt;= (uuid,uuid)</literal></entry></row>
    <row><entry><literal>&gt;= (uuid,uuid)</literal></entry></row>

    <row>
     <entry valign="middle" morerows="4"><literal>uuid_minmax_multi_ops</literal></entry>
     <entry><literal>= (uuid,uuid)</literal></entry>
    </row>
    <row><entry><literal>&lt; (uuid,uuid)</literal></entry></row>
    <row><entry><literal>&gt; (uuid,uuid)</literal></entry></row>
    <row><entry><literal>&lt;= (uuid,uuid)</literal></entry></row>
    <row><entry><literal>&gt;= (uuid,uuid)</literal></entry></row>

    <row>
     <entry valign="middle" morerows="4"><literal>varbit_minmax_ops</literal></entry>
     <entry><literal>= (varbit,varbit)</literal></entry>
    </row>
    <row><entry><literal>&lt; (varbit,varbit)</literal></entry></row>
    <row><entry><literal>&gt; (varbit,varbit)</literal></entry></row>
    <row><entry><literal>&lt;= (varbit,varbit)</literal></entry></row>
    <row><entry><literal>&gt;= (varbit,varbit)</literal></entry></row>
   </tbody>
  </tgroup>
 </table>

  <sect3 id="brin-builtin-opclasses--parameters">
   <title>Operator Class Parameters</title>

   <para>
    Some of the built-in operator classes allow specifying parameters affecting
    behavior of the operator class.  Each operator class has its own set of
    allowed parameters.  Only the <literal>bloom</literal> and <literal>minmax-multi</literal>
    operator classes allow specifying parameters:
   </para>

   <para>
    bloom operator classes accept these parameters:
   </para>

   <variablelist>
   <varlistentry>
    <term><literal>n_distinct_per_range</literal></term>
    <listitem>
    <para>
     Defines the estimated number of distinct non-null values in the block
     range, used by <acronym>BRIN</acronym> bloom indexes for sizing of the
     Bloom
Title: BRIN Operator Classes and Parameters
Summary
The text continues to list various BRIN operator classes for different data types, including time, timetz, uuid, and varbit, each supporting operators such as equality, less than, greater than, and range-specific operators, and then introduces the concept of operator class parameters, specifically for bloom and minmax-multi operator classes, which allow customization of behavior, including the estimated number of distinct non-null values in a block range for bloom indexes.