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

2020-02-19 Thread Tom Lane
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 tra

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

2020-02-19 Thread Tom Lane
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 tra

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

2020-02-19 Thread Tom Lane
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 tra

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

2020-02-19 Thread Tom Lane
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 tra