diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 24 |
1 files changed, 22 insertions, 2 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index d1e2e8c4c32..9d87b5097af 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -1770,8 +1770,9 @@ include_dir 'conf.d' fact in mind when choosing the value. Sort operations are used for <literal>ORDER BY</literal>, <literal>DISTINCT</literal>, and merge joins. - Hash tables are used in hash joins, hash-based aggregation, and - hash-based processing of <literal>IN</literal> subqueries. + Hash tables are used in hash joins, hash-based aggregation, result + cache nodes and hash-based processing of <literal>IN</literal> + subqueries. </para> <para> Hash-based operations are generally more sensitive to memory @@ -4925,6 +4926,25 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class=" </listitem> </varlistentry> + <varlistentry id="guc-enable-resultcache" xreflabel="enable_resultcache"> + <term><varname>enable_resultcache</varname> (<type>boolean</type>) + <indexterm> + <primary><varname>enable_resultcache</varname> configuration parameter</primary> + </indexterm> + </term> + <listitem> + <para> + Enables or disables the query planner's use of result cache plans for + caching results from parameterized scans inside nested-loop joins. + This plan type allows scans to the underlying plans to be skipped when + the results for the current parameters are already in the cache. Less + commonly looked up results may be evicted from the cache when more + space is required for new entries. The default is + <literal>on</literal>. + </para> + </listitem> + </varlistentry> + <varlistentry id="guc-enable-mergejoin" xreflabel="enable_mergejoin"> <term><varname>enable_mergejoin</varname> (<type>boolean</type>) <indexterm> |