pgsql: Doc: discourage use of partial indexes for poor-man's-partitioni - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Doc: discourage use of partial indexes for poor-man's-partitioni
Date
Msg-id E1j4Z8v-0005ln-6f@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Doc: discourage use of partial indexes for poor-man's-partitioning.

Creating a bunch of non-overlapping partial indexes is generally
a bad idea, so add an example saying not to do that.

Back-patch to v10.  Before that, the alternative of using (real)
partitioning wasn't available, so that the tradeoff isn't quite
so clear cut.

Discussion: https://postgr.es/m/CAKVFrvFY-f7kgwMRMiPLbPYMmgjc8Y2jjUGK_Y0HVcYAmU6ymg@mail.gmail.com

Branch
------
master

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

Modified Files
--------------
doc/src/sgml/indices.sgml | 48 +++++++++++++++++++++++++++++++++++++++++++++--
1 file changed, 46 insertions(+), 2 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Remove support for upgrading extensions from "unpackaged" state.
Next
From: Michael Paquier
Date:
Subject: pgsql: Cleanup more code related to ws2_32.dll loading in src/port/geta