]> git.ipfire.org Git - thirdparty/postgresql.git/commit
projects / thirdparty / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 7d8346b) | patch
Doc: discourage use of partial indexes for poor-man's-partitioning.
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 19 Feb 2020 23:52:18 +0000 (18:52 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 19 Feb 2020 23:52:18 +0000 (18:52 -0500)
commit1de4a823f9dea3bdc2dba2fe0b9b90c06cfd6fbb
tree15bb4f85172ee368e28eb87ed55566fc2f7a57b1tree
parent7d8346b2f42fc7311ccac08870c21a9763c43824commit | diff
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
doc/src/sgml/indices.sgml diff | blob | blame | history
Mirror of https://git.postgresql.org/git/postgresql.git