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, <d...@seiler.us> wrote: > 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 >
