-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathbrin-builtin-opclasses.html
More file actions
88 lines (88 loc) · 34.1 KB
/
brin-builtin-opclasses.html
File metadata and controls
88 lines (88 loc) · 34.1 KB
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
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
<?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. 組み込み演算子クラス</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. はじめに" /><link rel="next" href="brin-extensibility.html" title="71.3. 拡張性" /><meta name="viewport" content="width=device-width,initial-scale=1.0" /></head><body id="docContent" class="container-fluid col-10"><div class="other_version"><a href="https://www.postgresql.jp/document/">バージョンごとのドキュメント一覧</a></div><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="4" align="center"><a accesskey="h" href="index.html">PostgreSQL 16.4文書</a></th></tr><tr><td width="10%" align="left"></td><td width="10%" align="left"></td><td width="60%" align="center"><a href="brin.html" title="第71章 BRINインデックス">第71章 BRINインデックス</a></td><td width="20%" align="right"><div class="actions"><a class="issue" title="github" href="https://github.com/pgsql-jp/jpug-doc/issues/new?template=bug_report.yml&what-happened=version 16.4 : brin-builtin-opclasses.html">誤訳等の報告
</a></div></td></tr><tr><td width="10%" align="left"><a accesskey="p" href="brin-intro.html" title="71.1. はじめに">前へ</a> </td><td width="10%" align="left"><a accesskey="u" href="brin.html" title="第71章 BRINインデックス">上へ</a></td><td width="60%" align="center">71.2. 組み込み演算子クラス</td><td width="20%" align="right"> <a accesskey="n" href="brin-extensibility.html" title="71.3. 拡張性">次へ</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. 組み込み演算子クラス <a href="#BRIN-BUILTIN-OPCLASSES" class="id_link">#</a></h2></div></div></div><span class="original">
<title>Built-in Operator Classes</title>
</span><p>
<span class="original">
The core <productname>PostgreSQL</productname> distribution
includes the <acronym>BRIN</acronym> operator classes shown in
<xref linkend="brin-builtin-opclasses-table"/>.
</span>
<span class="productname">PostgreSQL</span>のコア配布物には、<a class="xref" href="brin-builtin-opclasses.html#BRIN-BUILTIN-OPCLASSES-TABLE" title="表71.1 組み込みBRIN演算子クラス">表 71.1</a>で示される<acronym class="acronym">BRIN</acronym>演算子クラスが含まれます。
</p><p>
<span class="original">
The <firstterm>minmax</firstterm>
operator classes store the minimum and the maximum values appearing
in the indexed column within the range. The <firstterm>inclusion</firstterm>
operator classes store a value which includes the values in the indexed
column within the range. The <firstterm>bloom</firstterm> operator
classes build a Bloom filter for all values in the range. The
<firstterm>minmax-multi</firstterm> operator classes store multiple
minimum and maximum values, representing values appearing in the indexed
column within the range.
</span>
<em class="firstterm">minmax</em>演算子クラスは、インデックスが貼られた列の範囲内に現れる最小値と最大値を格納します。
<em class="firstterm">inclusion</em>演算子クラスは、インデックスが貼られた列の範囲内に含まれる値を格納します。
<em class="firstterm">bloom</em>演算子クラスは、その範囲内のすべての値に対してブルームフィルタを構築します。
<em class="firstterm">minmax-multi</em>演算子クラスは、インデックスが貼られた列の範囲内に現れる複数の最小値と最大値、代表値を格納します。
</p><div class="table" id="BRIN-BUILTIN-OPCLASSES-TABLE"><p class="title"><strong>表71.1 組み込み<acronym class="acronym">BRIN</acronym>演算子クラス</strong></p><div class="table-contents"><span class="original">
<title>Built-in <acronym>BRIN</acronym> Operator Classes</title>
</span><table class="table" summary="組み込みBRIN演算子クラス" border="1"><colgroup><col /><col /></colgroup><thead><tr><th>名前</th><th>インデックス可能な演算子</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. 演算子クラスパラメータ <a href="#BRIN-BUILTIN-OPCLASSES--PARAMETERS" class="id_link">#</a></h3></div></div></div><span class="original">
<title>Operator Class Parameters</title>
</span><p>
<span class="original">
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:
</span>
いくつかの組み込み演算子クラスは演算子クラスの振舞いに影響するパラメータを指定できます。
それぞれの演算子クラスで、指定できる独自のパラメータ群があります。
<code class="literal">bloom</code>演算子クラスと<code class="literal">minmax-multi</code>演算子クラスのみ特定のパラメータが指定できます。
</p><p>
<span class="original">
bloom operator classes accept these parameters:
</span>
bloom演算子クラスでは次のパラメータを受け取ります。
</p><div class="variablelist"><dl class="variablelist"><dt><span class="term"><code class="literal">n_distinct_per_range</code></span></dt><dd><p>
<span class="original">
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 filter. It behaves similarly to <literal>n_distinct</literal> option
for <xref linkend="sql-altertable"/>. 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 <literal>-0.1</literal>, and
the minimum number of distinct non-null values is <literal>16</literal>.
</span>
<acronym class="acronym">BRIN</acronym>ブルームインデックスでブルームフィルタのサイズ設定に使用される、ブロックレンジ内の重複しない非NULL値の推定数を定義します。
これは、<a class="xref" href="sql-altertable.html" title="ALTER TABLE"><span class="refentrytitle">ALTER TABLE</span></a>の<code class="literal">n_distinct</code>オプションと同様に動作します。
正の値に設定された場合、各ブロックレンジにはこの数の重複しない非NULL値が含まれているとみなされます。
負の値に設定された場合、重複しない非NULL値の数はブロックレンジ内でのタプルの最大数(ブロックあたり約290行)に比例して増加するとみなされ、-1以上である必要があります。
デフォルト値は<code class="literal">-0.1</code>で、重複しない非NULL値の最小数は<code class="literal">16</code>です。
</p></dd><dt><span class="term"><code class="literal">false_positive_rate</code></span></dt><dd><p>
<span class="original">
Defines the desired false positive rate used by <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.
</span>
ブルームフィルタのサイズ設定のために<acronym class="acronym">BRIN</acronym>ブルームインデックスによって使用される、必要な偽陽性率を定義します。
値は0.0001から0.25の間でなければなりません。デフォルト値は0.01で、これは1%の偽陽性率です。
</p></dd></dl></div><p>
<span class="original">
minmax-multi operator classes accept these parameters:
</span>
minmax-multi演算子クラスでは次のパラメータを受け取ります。
</p><div class="variablelist"><dl class="variablelist"><dt><span class="term"><code class="literal">values_per_range</code></span></dt><dd><p>
<span class="original">
Defines the maximum number of values stored by <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.
</span>
ブロック範囲を集計するために<acronym class="acronym">BRIN</acronym> minmaxインデックスによって格納される値の最大数を定義します。
各値は、点または区間の境界として表すこともできます。値は8から256の間である必要があり、デフォルト値は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. はじめに">前へ</a> </td><td width="20%" align="center"><a accesskey="u" href="brin.html" title="第71章 BRINインデックス">上へ</a></td><td width="40%" align="right"> <a accesskey="n" href="brin-extensibility.html" title="71.3. 拡張性">次へ</a></td></tr><tr><td width="40%" align="left" valign="top">71.1. はじめに </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 16.4文書">ホーム</a></td><td width="40%" align="right" valign="top"> 71.3. 拡張性</td></tr></table></div></body></html>