On Wed, Oct 30, 2024 at 11:23 AM Peter Geoghegan <p...@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? Don. -- Don Seiler www.seiler.us
