pgsql: doc: Add best practises section to partitioning docs - Mailing list pgsql-committers

From David Rowley
Subject pgsql: doc: Add best practises section to partitioning docs
Date
Msg-id E1han6S-0005vN-8y@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
doc: Add best practises section to partitioning docs

A few questionable partitioning designs have been cropping up lately
around the mailing lists.  Generally, these cases have been partitioning
using too many partitions which have caused performance or OOM problems for
the users.

Since we have very little else to guide users into good design, here we
add a new section to the partitioning documentation with some best
practise guidelines for good design.

Reviewed-by: Justin Pryzby, Amit Langote, Alvaro Herrera
Discussion: https://postgr.es/m/CAKJS1f-2rx+E9mG3xrCVHupefMjAp1+tpczQa9SEOZWyU7fjEA@mail.gmail.com
Backpatch-through: 10

Branch
------
REL_10_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/6e1dc84533e45242f2a0bae87f324fcb9bd5cd11

Modified Files
--------------
doc/src/sgml/ddl.sgml | 83 +++++++++++++++++++++++++++++++++++++++++++++++++--
1 file changed, 81 insertions(+), 2 deletions(-)


pgsql-committers by date:

Previous
From: David Rowley
Date:
Subject: pgsql: doc: Add best practises section to partitioning docs
Next
From: Michael Paquier
Date:
Subject: pgsql: Fix handling of COMMENT for domain constraints