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@seiler.us> wrote:
On Wed, Oct 30, 2024 at 11:23 AM Peter Geoghegan <pg@bowt.ie> 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?
