Add commentary explaining why MaxIndexTuplesPerPage calculation is safe.

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 2a67d6440db4360efff2078a05bc172ca8f34b2b
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2018-04-14T16:33:15Z
Releases: 11.0
Add commentary explaining why MaxIndexTuplesPerPage calculation is safe.

MaxIndexTuplesPerPage ignores the fact that btree indexes sometimes
store tuples with no data payload.  But it also ignores the possibility
of "special space" on index pages, which offsets that, so that the
result isn't an underestimate.  This all seems worth documenting, though.

In passing, remove #define MinIndexTupleSize, which was added by
commit 2c03216d8 but not used in that commit nor later ones.

Comment text by me; issue noticed by Peter Geoghegan.

Discussion: https://postgr.es/m/CAH2-WzkQmb54Kbx-YHXstRKXcNc+_87jwV3DRb54xcybLR7Oig@mail.gmail.com

Files

PathChange+/−
src/include/access/itup.h modified +9 −1

Discussion