diff options
| author | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2011-09-08 17:51:23 +0300 |
|---|---|---|
| committer | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2011-09-08 17:51:23 +0300 |
| commit | 5edb24a8983e4a103e26153853d91141f818227c (patch) | |
| tree | 9e3102de6e2149b0d3678b403c91955e97f3bdc8 /doc/src/sgml/ref/create_index.sgml | |
| parent | 09b68c70af855a0a69cede14da70968ddd97ba05 (diff) | |
| download | postgresql-5edb24a8983e4a103e26153853d91141f818227c.tar.gz | |
Buffering GiST index build algorithm.
When building a GiST index that doesn't fit in cache, buffers are attached
to some internal nodes in the index. This speeds up the build by avoiding
random I/O that would otherwise be needed to traverse all the way down the
tree to the find right leaf page for tuple.
Alexander Korotkov
Diffstat (limited to 'doc/src/sgml/ref/create_index.sgml')
| -rw-r--r-- | doc/src/sgml/ref/create_index.sgml | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index 1a1e8d60d7..2cfc9f30f1 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -341,6 +341,26 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ <replaceable class="parameter">name</ </varlistentry> </variablelist> + <para> + GiST indexes additionaly accepts parameters: + </para> + + <variablelist> + + <varlistentry> + <term><literal>BUFFERING</></term> + <listitem> + <para> + Determines whether the buffering build technique described in + <xref linkend="gist-buffering-build"> is used to build the index. With + <literal>OFF</> it is disabled, with <literal>ON</> it is enabled, and + with <literal>AUTO</> it is initially disabled, but turned on + on-the-fly once the index size reaches <xref linkend="guc-effective-cache-size">. The default is <literal>AUTO</>. + </para> + </listitem> + </varlistentry> + + </variablelist> </refsect2> <refsect2 id="SQL-CREATEINDEX-CONCURRENTLY"> |