aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2016-07-31 18:32:34 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2016-07-31 18:33:00 -0400
commit9c6e5942ac1a23de201706c1cb12c5f35e94edea (patch)
treec0630238e48776838245603f0a6ec35db91d2d09
parent67defa882b9c97bee3e097d90057403821df2a84 (diff)
downloadpostgresql-9c6e5942ac1a23de201706c1cb12c5f35e94edea.tar.gz
postgresql-9c6e5942ac1a23de201706c1cb12c5f35e94edea.zip
Doc: remove claim that hash index creation depends on effective_cache_size.
This text was added by commit ff213239c, and not long thereafter obsoleted by commit 4adc2f72a (which made the test depend on NBuffers instead); but nobody noticed the need for an update. Commit 9563d5b5e adds some further dependency on maintenance_work_mem, but the existing verbiage seems to cover that with about as much precision as we really want here. Let's just take it all out rather than leaving ourselves open to more errors of omission in future. (That solution makes this change back-patchable, too.) Noted by Peter Geoghegan. Discussion: <CAM3SWZRVANbj9GA9j40fAwheQCZQtSwqTN1GBTVwRrRbmSf7cg@mail.gmail.com>
-rw-r--r--doc/src/sgml/ref/create_index.sgml11
1 files changed, 1 insertions, 10 deletions
diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml
index 27816df8a5d..5dea711b505 100644
--- a/doc/src/sgml/ref/create_index.sgml
+++ b/doc/src/sgml/ref/create_index.sgml
@@ -526,16 +526,7 @@ Indexes:
dependent on the setting of <xref linkend="guc-maintenance-work-mem">.
Larger values will reduce the time needed for index creation, so long
as you don't make it larger than the amount of memory really available,
- which would drive the machine into swapping. For hash indexes, the
- value of <xref linkend="guc-effective-cache-size"> is also relevant to
- index creation time: <productname>PostgreSQL</productname> will use one
- of two different hash index creation methods depending on whether the
- estimated index size is more or less than <varname>effective_cache_size</>.
- For best results, make sure that this parameter is also set to something
- reflective of available memory, and be careful that the sum of
- <varname>maintenance_work_mem</> and <varname>effective_cache_size</> is
- less than the machine's RAM less whatever space is needed by other
- programs.
+ which would drive the machine into swapping.
</para>
<para>