| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Doc: discourage use of partial indexes for poor-man's-partitioni |
| Date: | 2020-02-19 23:52:37 |
| Message-ID: | E1j4Z8v-0005lr-7b@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
------
REL_11_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/bbce2912fa899de30783a6a76a6443b5a2aede8d
Modified Files
--------------
doc/src/sgml/indices.sgml | 48 +++++++++++++++++++++++++++++++++++++++++++++--
1 file changed, 46 insertions(+), 2 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2020-02-20 03:02:13 | pgsql: Cleanup more code related to ws2_32.dll loading in src/port/geta |
| Previous Message | Tom Lane | 2020-02-19 21:59:29 | pgsql: Remove support for upgrading extensions from "unpackaged" state. |