1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>68.2. Built-in Operator Classes</title><link rel="stylesheet" type="text/css" href="stylesheet.css" /><link rev="made" href="pgsql-docs@lists.postgresql.org" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="prev" href="brin-intro.html" title="68.1. Introduction" /><link rel="next" href="brin-extensibility.html" title="68.3. Extensibility" /></head><body id="docContent" class="container-fluid col-10"><div xmlns="http://www.w3.org/TR/xhtml1/transitional" class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">68.2. Built-in Operator Classes</th></tr><tr><td width="10%" align="left"><a accesskey="p" href="brin-intro.html" title="68.1. Introduction">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="brin.html" title="Chapter 68. BRIN Indexes">Up</a></td><th width="60%" align="center">Chapter 68. BRIN Indexes</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 14.5 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="brin-extensibility.html" title="68.3. Extensibility">Next</a></td></tr></table><hr></hr></div><div class="sect1" id="BRIN-BUILTIN-OPCLASSES"><div class="titlepage"><div><div><h2 class="title" style="clear: both">68.2. Built-in Operator Classes</h2></div></div></div><div class="toc"><dl class="toc"><dt><span class="sect2"><a href="brin-builtin-opclasses.html#BRIN-BUILTIN-OPCLASSES--PARAMETERS">68.2.1. Operator Class Parameters</a></span></dt></dl></div><p>
The core <span class="productname">PostgreSQL</span> distribution
includes the <acronym class="acronym">BRIN</acronym> operator classes shown in
<a class="xref" href="brin-builtin-opclasses.html#BRIN-BUILTIN-OPCLASSES-TABLE" title="Table 68.1. Built-in BRIN Operator Classes">Table 68.1</a>.
</p><p>
The <em class="firstterm">minmax</em>
operator classes store the minimum and the maximum values appearing
in the indexed column within the range. The <em class="firstterm">inclusion</em>
operator classes store a value which includes the values in the indexed
column within the range. The <em class="firstterm">bloom</em> operator
classes build a Bloom filter for all values in the range. The
<em class="firstterm">minmax-multi</em> operator classes store multiple
minimum and maximum values, representing values appearing in the indexed
column within the range.
</p><div class="table" id="BRIN-BUILTIN-OPCLASSES-TABLE"><p class="title"><strong>Table 68.1. Built-in <acronym class="acronym">BRIN</acronym> Operator Classes</strong></p><div class="table-contents"><table class="table" summary="Built-in BRIN Operator Classes" border="1"><colgroup><col /><col /></colgroup><thead><tr><th>Name</th><th>Indexable Operators</th></tr></thead><tbody><tr><td rowspan="5" valign="middle"><code class="literal">bit_minmax_ops</code></td><td><code class="literal">= (bit,bit)</code></td></tr><tr><td><code class="literal">< (bit,bit)</code></td></tr><tr><td><code class="literal">> (bit,bit)</code></td></tr><tr><td><code class="literal"><= (bit,bit)</code></td></tr><tr><td><code class="literal">>= (bit,bit)</code></td></tr><tr><td rowspan="13" valign="middle"><code class="literal">box_inclusion_ops</code></td><td><code class="literal">@> (box,point)</code></td></tr><tr><td><code class="literal"><< (box,box)</code></td></tr><tr><td><code class="literal">&< (box,box)</code></td></tr><tr><td><code class="literal">&> (box,box)</code></td></tr><tr><td><code class="literal">>> (box,box)</code></td></tr><tr><td><code class="literal"><@ (box,box)</code></td></tr><tr><td><code class="literal">@> (box,box)</code></td></tr><tr><td><code class="literal">~= (box,box)</code></td></tr><tr><td><code class="literal">&& (box,box)</code></td></tr><tr><td><code class="literal"><<| (box,box)</code></td></tr><tr><td><code class="literal">&<| (box,box)</code></td></tr><tr><td><code class="literal">|&> (box,box)</code></td></tr><tr><td><code class="literal">|>> (box,box)</code></td></tr><tr><td valign="middle"><code class="literal">bpchar_bloom_ops</code></td><td><code class="literal">= (character,character)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">bpchar_minmax_ops</code></td><td><code class="literal">= (character,character)</code></td></tr><tr><td><code class="literal">< (character,character)</code></td></tr><tr><td><code class="literal"><= (character,character)</code></td></tr><tr><td><code class="literal">> (character,character)</code></td></tr><tr><td><code class="literal">>= (character,character)</code></td></tr><tr><td valign="middle"><code class="literal">bytea_bloom_ops</code></td><td><code class="literal">= (bytea,bytea)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">bytea_minmax_ops</code></td><td><code class="literal">= (bytea,bytea)</code></td></tr><tr><td><code class="literal">< (bytea,bytea)</code></td></tr><tr><td><code class="literal"><= (bytea,bytea)</code></td></tr><tr><td><code class="literal">> (bytea,bytea)</code></td></tr><tr><td><code class="literal">>= (bytea,bytea)</code></td></tr><tr><td valign="middle"><code class="literal">char_bloom_ops</code></td><td><code class="literal">= ("char","char")</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">char_minmax_ops</code></td><td><code class="literal">= ("char","char")</code></td></tr><tr><td><code class="literal">< ("char","char")</code></td></tr><tr><td><code class="literal"><= ("char","char")</code></td></tr><tr><td><code class="literal">> ("char","char")</code></td></tr><tr><td><code class="literal">>= ("char","char")</code></td></tr><tr><td valign="middle"><code class="literal">date_bloom_ops</code></td><td><code class="literal">= (date,date)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">date_minmax_ops</code></td><td><code class="literal">= (date,date)</code></td></tr><tr><td><code class="literal">< (date,date)</code></td></tr><tr><td><code class="literal"><= (date,date)</code></td></tr><tr><td><code class="literal">> (date,date)</code></td></tr><tr><td><code class="literal">>= (date,date)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">date_minmax_multi_ops</code></td><td><code class="literal">= (date,date)</code></td></tr><tr><td><code class="literal">< (date,date)</code></td></tr><tr><td><code class="literal"><= (date,date)</code></td></tr><tr><td><code class="literal">> (date,date)</code></td></tr><tr><td><code class="literal">>= (date,date)</code></td></tr><tr><td valign="middle"><code class="literal">float4_bloom_ops</code></td><td><code class="literal">= (float4,float4)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">float4_minmax_ops</code></td><td><code class="literal">= (float4,float4)</code></td></tr><tr><td><code class="literal">< (float4,float4)</code></td></tr><tr><td><code class="literal">> (float4,float4)</code></td></tr><tr><td><code class="literal"><= (float4,float4)</code></td></tr><tr><td><code class="literal">>= (float4,float4)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">float4_minmax_multi_ops</code></td><td><code class="literal">= (float4,float4)</code></td></tr><tr><td><code class="literal">< (float4,float4)</code></td></tr><tr><td><code class="literal">> (float4,float4)</code></td></tr><tr><td><code class="literal"><= (float4,float4)</code></td></tr><tr><td><code class="literal">>= (float4,float4)</code></td></tr><tr><td valign="middle"><code class="literal">float8_bloom_ops</code></td><td><code class="literal">= (float8,float8)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">float8_minmax_ops</code></td><td><code class="literal">= (float8,float8)</code></td></tr><tr><td><code class="literal">< (float8,float8)</code></td></tr><tr><td><code class="literal"><= (float8,float8)</code></td></tr><tr><td><code class="literal">> (float8,float8)</code></td></tr><tr><td><code class="literal">>= (float8,float8)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">float8_minmax_multi_ops</code></td><td><code class="literal">= (float8,float8)</code></td></tr><tr><td><code class="literal">< (float8,float8)</code></td></tr><tr><td><code class="literal"><= (float8,float8)</code></td></tr><tr><td><code class="literal">> (float8,float8)</code></td></tr><tr><td><code class="literal">>= (float8,float8)</code></td></tr><tr><td rowspan="6" valign="middle"><code class="literal">inet_inclusion_ops</code></td><td><code class="literal"><< (inet,inet)</code></td></tr><tr><td><code class="literal"><<= (inet,inet)</code></td></tr><tr><td><code class="literal">>> (inet,inet)</code></td></tr><tr><td><code class="literal">>>= (inet,inet)</code></td></tr><tr><td><code class="literal">= (inet,inet)</code></td></tr><tr><td><code class="literal">&& (inet,inet)</code></td></tr><tr><td valign="middle"><code class="literal">inet_bloom_ops</code></td><td><code class="literal">= (inet,inet)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">inet_minmax_ops</code></td><td><code class="literal">= (inet,inet)</code></td></tr><tr><td><code class="literal">< (inet,inet)</code></td></tr><tr><td><code class="literal"><= (inet,inet)</code></td></tr><tr><td><code class="literal">> (inet,inet)</code></td></tr><tr><td><code class="literal">>= (inet,inet)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">inet_minmax_multi_ops</code></td><td><code class="literal">= (inet,inet)</code></td></tr><tr><td><code class="literal">< (inet,inet)</code></td></tr><tr><td><code class="literal"><= (inet,inet)</code></td></tr><tr><td><code class="literal">> (inet,inet)</code></td></tr><tr><td><code class="literal">>= (inet,inet)</code></td></tr><tr><td valign="middle"><code class="literal">int2_bloom_ops</code></td><td><code class="literal">= (int2,int2)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">int2_minmax_ops</code></td><td><code class="literal">= (int2,int2)</code></td></tr><tr><td><code class="literal">< (int2,int2)</code></td></tr><tr><td><code class="literal">> (int2,int2)</code></td></tr><tr><td><code class="literal"><= (int2,int2)</code></td></tr><tr><td><code class="literal">>= (int2,int2)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">int2_minmax_multi_ops</code></td><td><code class="literal">= (int2,int2)</code></td></tr><tr><td><code class="literal">< (int2,int2)</code></td></tr><tr><td><code class="literal">> (int2,int2)</code></td></tr><tr><td><code class="literal"><= (int2,int2)</code></td></tr><tr><td><code class="literal">>= (int2,int2)</code></td></tr><tr><td valign="middle"><code class="literal">int4_bloom_ops</code></td><td><code class="literal">= (int4,int4)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">int4_minmax_ops</code></td><td><code class="literal">= (int4,int4)</code></td></tr><tr><td><code class="literal">< (int4,int4)</code></td></tr><tr><td><code class="literal">> (int4,int4)</code></td></tr><tr><td><code class="literal"><= (int4,int4)</code></td></tr><tr><td><code class="literal">>= (int4,int4)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">int4_minmax_multi_ops</code></td><td><code class="literal">= (int4,int4)</code></td></tr><tr><td><code class="literal">< (int4,int4)</code></td></tr><tr><td><code class="literal">> (int4,int4)</code></td></tr><tr><td><code class="literal"><= (int4,int4)</code></td></tr><tr><td><code class="literal">>= (int4,int4)</code></td></tr><tr><td valign="middle"><code class="literal">int8_bloom_ops</code></td><td><code class="literal">= (bigint,bigint)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">int8_minmax_ops</code></td><td><code class="literal">= (bigint,bigint)</code></td></tr><tr><td><code class="literal">< (bigint,bigint)</code></td></tr><tr><td><code class="literal">> (bigint,bigint)</code></td></tr><tr><td><code class="literal"><= (bigint,bigint)</code></td></tr><tr><td><code class="literal">>= (bigint,bigint)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">int8_minmax_multi_ops</code></td><td><code class="literal">= (bigint,bigint)</code></td></tr><tr><td><code class="literal">< (bigint,bigint)</code></td></tr><tr><td><code class="literal">> (bigint,bigint)</code></td></tr><tr><td><code class="literal"><= (bigint,bigint)</code></td></tr><tr><td><code class="literal">>= (bigint,bigint)</code></td></tr><tr><td valign="middle"><code class="literal">interval_bloom_ops</code></td><td><code class="literal">= (interval,interval)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">interval_minmax_ops</code></td><td><code class="literal">= (interval,interval)</code></td></tr><tr><td><code class="literal">< (interval,interval)</code></td></tr><tr><td><code class="literal"><= (interval,interval)</code></td></tr><tr><td><code class="literal">> (interval,interval)</code></td></tr><tr><td><code class="literal">>= (interval,interval)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">interval_minmax_multi_ops</code></td><td><code class="literal">= (interval,interval)</code></td></tr><tr><td><code class="literal">< (interval,interval)</code></td></tr><tr><td><code class="literal"><= (interval,interval)</code></td></tr><tr><td><code class="literal">> (interval,interval)</code></td></tr><tr><td><code class="literal">>= (interval,interval)</code></td></tr><tr><td valign="middle"><code class="literal">macaddr_bloom_ops</code></td><td><code class="literal">= (macaddr,macaddr)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">macaddr_minmax_ops</code></td><td><code class="literal">= (macaddr,macaddr)</code></td></tr><tr><td><code class="literal">< (macaddr,macaddr)</code></td></tr><tr><td><code class="literal"><= (macaddr,macaddr)</code></td></tr><tr><td><code class="literal">> (macaddr,macaddr)</code></td></tr><tr><td><code class="literal">>= (macaddr,macaddr)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">macaddr_minmax_multi_ops</code></td><td><code class="literal">= (macaddr,macaddr)</code></td></tr><tr><td><code class="literal">< (macaddr,macaddr)</code></td></tr><tr><td><code class="literal"><= (macaddr,macaddr)</code></td></tr><tr><td><code class="literal">> (macaddr,macaddr)</code></td></tr><tr><td><code class="literal">>= (macaddr,macaddr)</code></td></tr><tr><td valign="middle"><code class="literal">macaddr8_bloom_ops</code></td><td><code class="literal">= (macaddr8,macaddr8)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">macaddr8_minmax_ops</code></td><td><code class="literal">= (macaddr8,macaddr8)</code></td></tr><tr><td><code class="literal">< (macaddr8,macaddr8)</code></td></tr><tr><td><code class="literal"><= (macaddr8,macaddr8)</code></td></tr><tr><td><code class="literal">> (macaddr8,macaddr8)</code></td></tr><tr><td><code class="literal">>= (macaddr8,macaddr8)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">macaddr8_minmax_multi_ops</code></td><td><code class="literal">= (macaddr8,macaddr8)</code></td></tr><tr><td><code class="literal">< (macaddr8,macaddr8)</code></td></tr><tr><td><code class="literal"><= (macaddr8,macaddr8)</code></td></tr><tr><td><code class="literal">> (macaddr8,macaddr8)</code></td></tr><tr><td><code class="literal">>= (macaddr8,macaddr8)</code></td></tr><tr><td valign="middle"><code class="literal">name_bloom_ops</code></td><td><code class="literal">= (name,name)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">name_minmax_ops</code></td><td><code class="literal">= (name,name)</code></td></tr><tr><td><code class="literal">< (name,name)</code></td></tr><tr><td><code class="literal"><= (name,name)</code></td></tr><tr><td><code class="literal">> (name,name)</code></td></tr><tr><td><code class="literal">>= (name,name)</code></td></tr><tr><td valign="middle"><code class="literal">numeric_bloom_ops</code></td><td><code class="literal">= (numeric,numeric)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">numeric_minmax_ops</code></td><td><code class="literal">= (numeric,numeric)</code></td></tr><tr><td><code class="literal">< (numeric,numeric)</code></td></tr><tr><td><code class="literal"><= (numeric,numeric)</code></td></tr><tr><td><code class="literal">> (numeric,numeric)</code></td></tr><tr><td><code class="literal">>= (numeric,numeric)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">numeric_minmax_multi_ops</code></td><td><code class="literal">= (numeric,numeric)</code></td></tr><tr><td><code class="literal">< (numeric,numeric)</code></td></tr><tr><td><code class="literal"><= (numeric,numeric)</code></td></tr><tr><td><code class="literal">> (numeric,numeric)</code></td></tr><tr><td><code class="literal">>= (numeric,numeric)</code></td></tr><tr><td valign="middle"><code class="literal">oid_bloom_ops</code></td><td><code class="literal">= (oid,oid)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">oid_minmax_ops</code></td><td><code class="literal">= (oid,oid)</code></td></tr><tr><td><code class="literal">< (oid,oid)</code></td></tr><tr><td><code class="literal">> (oid,oid)</code></td></tr><tr><td><code class="literal"><= (oid,oid)</code></td></tr><tr><td><code class="literal">>= (oid,oid)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">oid_minmax_multi_ops</code></td><td><code class="literal">= (oid,oid)</code></td></tr><tr><td><code class="literal">< (oid,oid)</code></td></tr><tr><td><code class="literal">> (oid,oid)</code></td></tr><tr><td><code class="literal"><= (oid,oid)</code></td></tr><tr><td><code class="literal">>= (oid,oid)</code></td></tr><tr><td valign="middle"><code class="literal">pg_lsn_bloom_ops</code></td><td><code class="literal">= (pg_lsn,pg_lsn)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">pg_lsn_minmax_ops</code></td><td><code class="literal">= (pg_lsn,pg_lsn)</code></td></tr><tr><td><code class="literal">< (pg_lsn,pg_lsn)</code></td></tr><tr><td><code class="literal">> (pg_lsn,pg_lsn)</code></td></tr><tr><td><code class="literal"><= (pg_lsn,pg_lsn)</code></td></tr><tr><td><code class="literal">>= (pg_lsn,pg_lsn)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">pg_lsn_minmax_multi_ops</code></td><td><code class="literal">= (pg_lsn,pg_lsn)</code></td></tr><tr><td><code class="literal">< (pg_lsn,pg_lsn)</code></td></tr><tr><td><code class="literal">> (pg_lsn,pg_lsn)</code></td></tr><tr><td><code class="literal"><= (pg_lsn,pg_lsn)</code></td></tr><tr><td><code class="literal">>= (pg_lsn,pg_lsn)</code></td></tr><tr><td rowspan="14" valign="middle"><code class="literal">range_inclusion_ops</code></td><td><code class="literal">= (anyrange,anyrange)</code></td></tr><tr><td><code class="literal">< (anyrange,anyrange)</code></td></tr><tr><td><code class="literal"><= (anyrange,anyrange)</code></td></tr><tr><td><code class="literal">>= (anyrange,anyrange)</code></td></tr><tr><td><code class="literal">> (anyrange,anyrange)</code></td></tr><tr><td><code class="literal">&& (anyrange,anyrange)</code></td></tr><tr><td><code class="literal">@> (anyrange,anyelement)</code></td></tr><tr><td><code class="literal">@> (anyrange,anyrange)</code></td></tr><tr><td><code class="literal"><@ (anyrange,anyrange)</code></td></tr><tr><td><code class="literal"><< (anyrange,anyrange)</code></td></tr><tr><td><code class="literal">>> (anyrange,anyrange)</code></td></tr><tr><td><code class="literal">&< (anyrange,anyrange)</code></td></tr><tr><td><code class="literal">&> (anyrange,anyrange)</code></td></tr><tr><td><code class="literal">-|- (anyrange,anyrange)</code></td></tr><tr><td valign="middle"><code class="literal">text_bloom_ops</code></td><td><code class="literal">= (text,text)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">text_minmax_ops</code></td><td><code class="literal">= (text,text)</code></td></tr><tr><td><code class="literal">< (text,text)</code></td></tr><tr><td><code class="literal"><= (text,text)</code></td></tr><tr><td><code class="literal">> (text,text)</code></td></tr><tr><td><code class="literal">>= (text,text)</code></td></tr><tr><td valign="middle"><code class="literal">tid_bloom_ops</code></td><td><code class="literal">= (tid,tid)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">tid_minmax_ops</code></td><td><code class="literal">= (tid,tid)</code></td></tr><tr><td><code class="literal">< (tid,tid)</code></td></tr><tr><td><code class="literal">> (tid,tid)</code></td></tr><tr><td><code class="literal"><= (tid,tid)</code></td></tr><tr><td><code class="literal">>= (tid,tid)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">tid_minmax_multi_ops</code></td><td><code class="literal">= (tid,tid)</code></td></tr><tr><td><code class="literal">< (tid,tid)</code></td></tr><tr><td><code class="literal">> (tid,tid)</code></td></tr><tr><td><code class="literal"><= (tid,tid)</code></td></tr><tr><td><code class="literal">>= (tid,tid)</code></td></tr><tr><td valign="middle"><code class="literal">timestamp_bloom_ops</code></td><td><code class="literal">= (timestamp,timestamp)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">timestamp_minmax_ops</code></td><td><code class="literal">= (timestamp,timestamp)</code></td></tr><tr><td><code class="literal">< (timestamp,timestamp)</code></td></tr><tr><td><code class="literal"><= (timestamp,timestamp)</code></td></tr><tr><td><code class="literal">> (timestamp,timestamp)</code></td></tr><tr><td><code class="literal">>= (timestamp,timestamp)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">timestamp_minmax_multi_ops</code></td><td><code class="literal">= (timestamp,timestamp)</code></td></tr><tr><td><code class="literal">< (timestamp,timestamp)</code></td></tr><tr><td><code class="literal"><= (timestamp,timestamp)</code></td></tr><tr><td><code class="literal">> (timestamp,timestamp)</code></td></tr><tr><td><code class="literal">>= (timestamp,timestamp)</code></td></tr><tr><td valign="middle"><code class="literal">timestamptz_bloom_ops</code></td><td><code class="literal">= (timestamptz,timestamptz)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">timestamptz_minmax_ops</code></td><td><code class="literal">= (timestamptz,timestamptz)</code></td></tr><tr><td><code class="literal">< (timestamptz,timestamptz)</code></td></tr><tr><td><code class="literal"><= (timestamptz,timestamptz)</code></td></tr><tr><td><code class="literal">> (timestamptz,timestamptz)</code></td></tr><tr><td><code class="literal">>= (timestamptz,timestamptz)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">timestamptz_minmax_multi_ops</code></td><td><code class="literal">= (timestamptz,timestamptz)</code></td></tr><tr><td><code class="literal">< (timestamptz,timestamptz)</code></td></tr><tr><td><code class="literal"><= (timestamptz,timestamptz)</code></td></tr><tr><td><code class="literal">> (timestamptz,timestamptz)</code></td></tr><tr><td><code class="literal">>= (timestamptz,timestamptz)</code></td></tr><tr><td valign="middle"><code class="literal">time_bloom_ops</code></td><td><code class="literal">= (time,time)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">time_minmax_ops</code></td><td><code class="literal">= (time,time)</code></td></tr><tr><td><code class="literal">< (time,time)</code></td></tr><tr><td><code class="literal"><= (time,time)</code></td></tr><tr><td><code class="literal">> (time,time)</code></td></tr><tr><td><code class="literal">>= (time,time)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">time_minmax_multi_ops</code></td><td><code class="literal">= (time,time)</code></td></tr><tr><td><code class="literal">< (time,time)</code></td></tr><tr><td><code class="literal"><= (time,time)</code></td></tr><tr><td><code class="literal">> (time,time)</code></td></tr><tr><td><code class="literal">>= (time,time)</code></td></tr><tr><td valign="middle"><code class="literal">timetz_bloom_ops</code></td><td><code class="literal">= (timetz,timetz)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">timetz_minmax_ops</code></td><td><code class="literal">= (timetz,timetz)</code></td></tr><tr><td><code class="literal">< (timetz,timetz)</code></td></tr><tr><td><code class="literal"><= (timetz,timetz)</code></td></tr><tr><td><code class="literal">> (timetz,timetz)</code></td></tr><tr><td><code class="literal">>= (timetz,timetz)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">timetz_minmax_multi_ops</code></td><td><code class="literal">= (timetz,timetz)</code></td></tr><tr><td><code class="literal">< (timetz,timetz)</code></td></tr><tr><td><code class="literal"><= (timetz,timetz)</code></td></tr><tr><td><code class="literal">> (timetz,timetz)</code></td></tr><tr><td><code class="literal">>= (timetz,timetz)</code></td></tr><tr><td valign="middle"><code class="literal">uuid_bloom_ops</code></td><td><code class="literal">= (uuid,uuid)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">uuid_minmax_ops</code></td><td><code class="literal">= (uuid,uuid)</code></td></tr><tr><td><code class="literal">< (uuid,uuid)</code></td></tr><tr><td><code class="literal">> (uuid,uuid)</code></td></tr><tr><td><code class="literal"><= (uuid,uuid)</code></td></tr><tr><td><code class="literal">>= (uuid,uuid)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">uuid_minmax_multi_ops</code></td><td><code class="literal">= (uuid,uuid)</code></td></tr><tr><td><code class="literal">< (uuid,uuid)</code></td></tr><tr><td><code class="literal">> (uuid,uuid)</code></td></tr><tr><td><code class="literal"><= (uuid,uuid)</code></td></tr><tr><td><code class="literal">>= (uuid,uuid)</code></td></tr><tr><td rowspan="5" valign="middle"><code class="literal">varbit_minmax_ops</code></td><td><code class="literal">= (varbit,varbit)</code></td></tr><tr><td><code class="literal">< (varbit,varbit)</code></td></tr><tr><td><code class="literal">> (varbit,varbit)</code></td></tr><tr><td><code class="literal"><= (varbit,varbit)</code></td></tr><tr><td><code class="literal">>= (varbit,varbit)</code></td></tr></tbody></table></div></div><br class="table-break" /><div class="sect2" id="BRIN-BUILTIN-OPCLASSES--PARAMETERS"><div class="titlepage"><div><div><h3 class="title">68.2.1. Operator Class Parameters</h3></div></div></div><p>
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 <code class="literal">bloom</code> and <code class="literal">minmax-multi</code>
operator classes allow specifying parameters:
</p><p>
bloom operator classes accept these parameters:
</p><div class="variablelist"><dl class="variablelist"><dt><span class="term"><code class="literal">n_distinct_per_range</code></span></dt><dd><p>
Defines the estimated number of distinct non-null values in the block
range, used by <acronym class="acronym">BRIN</acronym> bloom indexes for sizing of the
Bloom filter. It behaves similarly to <code class="literal">n_distinct</code> option
for <a class="xref" href="sql-altertable.html" title="ALTER TABLE"><span class="refentrytitle">ALTER TABLE</span></a>. When set to a positive value,
each block range is assumed to contain this number of distinct non-null
values. When set to a negative value, which must be greater than or
equal to -1, the number of distinct non-null values is assumed to grow linearly with
the maximum possible number of tuples in the block range (about 290
rows per block). The default value is <code class="literal">-0.1</code>, and
the minimum number of distinct non-null values is <code class="literal">16</code>.
</p></dd><dt><span class="term"><code class="literal">false_positive_rate</code></span></dt><dd><p>
Defines the desired false positive rate used by <acronym class="acronym">BRIN</acronym>
bloom indexes for sizing of the Bloom filter. The values must be
between 0.0001 and 0.25. The default value is 0.01, which is 1% false
positive rate.
</p></dd></dl></div><p>
minmax-multi operator classes accept these parameters:
</p><div class="variablelist"><dl class="variablelist"><dt><span class="term"><code class="literal">values_per_range</code></span></dt><dd><p>
Defines the maximum number of values stored by <acronym class="acronym">BRIN</acronym>
minmax indexes to summarize a block range. Each value may represent
either a point, or a boundary of an interval. Values must be between
8 and 256, and the default value is 32.
</p></dd></dl></div></div></div><div xmlns="http://www.w3.org/TR/xhtml1/transitional" class="navfooter"><hr></hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="brin-intro.html" title="68.1. Introduction">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="brin.html" title="Chapter 68. BRIN Indexes">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="brin-extensibility.html" title="68.3. Extensibility">Next</a></td></tr><tr><td width="40%" align="left" valign="top">68.1. Introduction </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 14.5 Documentation">Home</a></td><td width="40%" align="right" valign="top"> 68.3. Extensibility</td></tr></table></div></body></html>
|
