[postgis-tickets] [PostGIS] #3452: Update "Tuning your configuration" section

[PostGIS]

#3452: Update "Tuning your configuration" section
---------------------------+----------------------------
 Reporter:  mwtoews        |      Owner:  robe
     Type:  task           |     Status:  new
 Priority:  medium         |  Milestone:  PostGIS Future
Component:  documentation  |    Version:  trunk
 Keywords:                 |
---------------------------+----------------------------
 Reading through the "Tuning your configuration" manual section, it seems
 it has aged behind multiple PostgreSQL releases, so this task is to update
 it. Here is what I've noticed (compared to PostgreSQL 9.5):
  `checkpoint_segments`:: was removed in PostgreSQL 9.5 (I'm not sure why),
 so note this change and consider removing it in December 2019 when
 PostgreSQL 9.4 is no longer supported.
  `constraint_exclusion`:: the default is `partition`. Remove mention of
 PostgreSQL 8.4, which was supported up to July 2014. Perhaps keep
 description for this setting in case someone is considering changing it.
  `shared_buffers`:: has had several defaults. For PostgreSQL versions 8.2
 to 9.2 it was 32MB, and 9.3+ it is 128MB.
  `work_mem`:: the default was 1MB and was changed in 9.4 to 4MB.
 Furthermore, the example should show the units, e.g. `SET work_mem TO
 '1200MB';`
  `maintenance_work_mem`:: the default was 16MB and was changed in 9.4 to
 64MB. Also, the example has a typo (i.e. ERROR:  unrecognized
 configuration parameter "maintainence_work_mem"). A better example is `SET
 maintenance_work_mem TO '1200MB';`.

 There have been many new configuration parameters added to PostgreSQL, are
 there any new tuning parameters that should be described?

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3452>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.