Doc: discourage use of partial indexes for poor-man's-partitioning.
Tom Lane <tgl@sss.pgh.pa.us>
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
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/indices.sgml | modified | +46 −2 |
Documentation touched
Discussion
- Partial index creation always scans the entire table 10 messages · 2020-02-15 → 2020-02-17