Are you able to cluster the table ? The idea is that rows ordered in the same way as the index might reduce it's size ?
On Wed, 30 Oct 2024, 16:29 Don Seiler, <don@xxxxxxxxx> wrote:
On Wed, Oct 30, 2024 at 11:23 AM Peter Geoghegan <pg@xxxxxxx> wrote:
If a substantial amount of the index was written by CREATE INDEX (and
not by retail inserts) then my theory is unlikely to be correct. It
could just be that you managed to absorb most inserts in one
partition, but not in the other. That's probably possible when there
are only relatively small differences in the number of inserts that
need to use of the space left behind by fillfactor in each case. In
general page splits tend to come in distinct "waves" after CREATE
INDEX is run.
What do you mean by "absorb" the inserts?It sounds like the answer will be "No", but: Would rebuilding the index after the month-end (when inserts have stopped on this partition) change anything?Don.--Don Seiler
www.seiler.us
