pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Doc: discourage use of partial indexes for poor-man's-partitioni 4+ messages / 1 participants [nested] [flat]
* pgsql: Doc: discourage use of partial indexes for poor-man's-partitioni @ 2020-02-19 23:52 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 4+ messages in thread From: Tom Lane @ 2020-02-19 23:52 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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(-) ^ permalink raw reply [nested|flat] 4+ messages in thread
* pgsql: Doc: discourage use of partial indexes for poor-man's-partitioni @ 2020-02-19 23:52 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 4+ messages in thread From: Tom Lane @ 2020-02-19 23:52 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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_12_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/fb4815c066c8f8ded20112c749f09192c0a03709 Modified Files -------------- doc/src/sgml/indices.sgml | 48 +++++++++++++++++++++++++++++++++++++++++++++-- 1 file changed, 46 insertions(+), 2 deletions(-) ^ permalink raw reply [nested|flat] 4+ messages in thread
* pgsql: Doc: discourage use of partial indexes for poor-man's-partitioni @ 2020-02-19 23:52 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 4+ messages in thread From: Tom Lane @ 2020-02-19 23:52 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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(-) ^ permalink raw reply [nested|flat] 4+ messages in thread
* pgsql: Doc: discourage use of partial indexes for poor-man's-partitioni @ 2020-02-19 23:52 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 4+ messages in thread From: Tom Lane @ 2020-02-19 23:52 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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_10_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/1de4a823f9dea3bdc2dba2fe0b9b90c06cfd6fbb Modified Files -------------- doc/src/sgml/indices.sgml | 48 +++++++++++++++++++++++++++++++++++++++++++++-- 1 file changed, 46 insertions(+), 2 deletions(-) ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2020-02-19 23:52 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2020-02-19 23:52 pgsql: Doc: discourage use of partial indexes for poor-man's-partitioni Tom Lane <tgl@sss.pgh.pa.us> 2020-02-19 23:52 pgsql: Doc: discourage use of partial indexes for poor-man's-partitioni Tom Lane <tgl@sss.pgh.pa.us> 2020-02-19 23:52 pgsql: Doc: discourage use of partial indexes for poor-man's-partitioni Tom Lane <tgl@sss.pgh.pa.us> 2020-02-19 23:52 pgsql: Doc: discourage use of partial indexes for poor-man's-partitioni Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox