pgsql: Improve multivariate statistics documentation

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve multivariate statistics documentation
Date: 2017-04-20 18:44:08
Message-ID: E1d1H3o-00083E-FC@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Improve multivariate statistics documentation

Extended statistics commit 7b504eb282c did not include appropriate
documentation next to where we document regular planner statistics (I
ripped what was submitted before commit and then forgot to put it back),
and while later commit 2686ee1b7ccf added some material, it structurally
depended on what I had ripped out, so the end result wasn't proper.

Fix those problems by shuffling what was added by 2686ee1b7ccf and
including some additional material, so that now chapter 14 "Performance
Tips" now describes the types of multivariate statistics we currently
have, and chapter 68 "How the Planner Uses Statistics" shows some
examples. The new text should be more in line with previous material,
in (hopefully) the appropriate depth.

While at it, fix a small bug in pg_statistic_ext docs: one column was
listed in the wrong spot.

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/919f6d746e45c8fe84d02799053ef47c3bb11050

Modified Files
--------------
doc/src/sgml/catalogs.sgml | 22 ++---
doc/src/sgml/perform.sgml | 195 +++++++++++++++++++++++++++++++++++++
doc/src/sgml/planstats.sgml | 228 ++++++++++++++++++++------------------------
3 files changed, 311 insertions(+), 134 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2017-04-20 20:31:36 pgsql: Add missing erand48.c to libpq/.gitignore.
Previous Message Tom Lane 2017-04-20 18:42:05 pgsql: Sync pg_ctl documentation and usage message with reality.