diff options
Diffstat (limited to 'doc/src/sgml/html/brin-builtin-opclasses.html')
| -rw-r--r-- | doc/src/sgml/html/brin-builtin-opclasses.html | 46 |
1 files changed, 46 insertions, 0 deletions
diff --git a/doc/src/sgml/html/brin-builtin-opclasses.html b/doc/src/sgml/html/brin-builtin-opclasses.html new file mode 100644 index 0000000..50dfb55 --- /dev/null +++ b/doc/src/sgml/html/brin-builtin-opclasses.html @@ -0,0 +1,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>71.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="71.1. Introduction" /><link rel="next" href="brin-extensibility.html" title="71.3. Extensibility" /></head><body id="docContent" class="container-fluid col-10"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">71.2. Built-in Operator Classes</th></tr><tr><td width="10%" align="left"><a accesskey="p" href="brin-intro.html" title="71.1. Introduction">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="brin.html" title="Chapter 71. BRIN Indexes">Up</a></td><th width="60%" align="center">Chapter 71. BRIN Indexes</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 15.5 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="brin-extensibility.html" title="71.3. Extensibility">Next</a></td></tr></table><hr /></div><div class="sect1" id="BRIN-BUILTIN-OPCLASSES"><div class="titlepage"><div><div><h2 class="title" style="clear: both">71.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">71.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 71.1. Built-in BRIN Operator Classes">Table 71.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 71.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">71.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 class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="brin-intro.html" title="71.1. Introduction">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="brin.html" title="Chapter 71. BRIN Indexes">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="brin-extensibility.html" title="71.3. Extensibility">Next</a></td></tr><tr><td width="40%" align="left" valign="top">71.1. Introduction </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 15.5 Documentation">Home</a></td><td width="40%" align="right" valign="top"> 71.3. Extensibility</td></tr></table></div></body></html>
\ No newline at end of file |