aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2007-12-02 04:36:40 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2007-12-02 04:36:40 +0000
commit8ee076325f3069787f311fd5c0fcdba7747abef1 (patch)
treead44afa5f1b4c1307b0885f1cc418a83df024b76
parent7cac32534f2c7f1c40d0e8240cc24dfc2ea7dda3 (diff)
downloadpostgresql-8ee076325f3069787f311fd5c0fcdba7747abef1.tar.gz
postgresql-8ee076325f3069787f311fd5c0fcdba7747abef1.zip
Mention hash opclasses in 'System Dependencies on Operator Classes',
which previously only talked about btree opclasses.
-rw-r--r--doc/src/sgml/xindex.sgml11
1 files changed, 9 insertions, 2 deletions
diff --git a/doc/src/sgml/xindex.sgml b/doc/src/sgml/xindex.sgml
index 0e92b3c6552..68d3123ef85 100644
--- a/doc/src/sgml/xindex.sgml
+++ b/doc/src/sgml/xindex.sgml
@@ -1,4 +1,4 @@
-<!-- $PostgreSQL: pgsql/doc/src/sgml/xindex.sgml,v 1.60 2007/04/25 19:48:27 neilc Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/xindex.sgml,v 1.61 2007/12/02 04:36:40 tgl Exp $ -->
<sect1 id="xindex">
<title>Interfacing Extensions To Indexes</title>
@@ -893,6 +893,13 @@ ALTER OPERATOR FAMILY integer_ops USING btree ADD
any assumption about the behavior of operators with particular names.
</para>
</note>
+
+ <para>
+ Another important point is that an operator that
+ appears in a hash operator family is a candidate for hash joins,
+ hash aggregation, and related optimizations. The hash operator family
+ is essential here since it identifies the hash function(s) to use.
+ </para>
</sect2>
<sect2 id="xindex-opclass-features">
@@ -950,7 +957,7 @@ CREATE OPERATOR CLASS polygon_ops
is used. In GIN, the <literal>STORAGE</> type identifies the type of
the <quote>key</> values, which normally is different from the type
of the indexed column &mdash; for example, an operator class for
- integer array columns might have keys that are just integers. The
+ integer-array columns might have keys that are just integers. The
GIN <function>extractValue</> and <function>extractQuery</> support
routines are responsible for extracting keys from indexed values.
</para>