On Mon, Mar 11, 2019 at 11:30 PM Heikki Linnakangas <hlinn...@iki.fi> wrote: > Yeah, that's fine. I'm curious, though, could you bloat the indexes back > to the old size by setting the fillfactor?
I think that that might work, though it's hard to say for sure offhand. The "split after new item" optimization is supposed to be a variation of rightmost splits, of course. We apply fillfactor in the same way much of the time. You would still literally split immediately after the new item some of the time, though, which makes it unclear how much bloat there would be without testing it. Some indexes mostly apply fillfactor in non-rightmost pages, while other indexes mostly split at the exact point past the new item, depending on details like the size of the groupings. I am currently doing a multi-day 6,000 warehouse benchmark, since I want to be sure that the bloat resistance will hold up over days. I think that it will, because there aren't that many updates, and they're almost all HOT-safe. I'll put the idea of a 50/50 fillfactor benchmark with the high-contention/regressed workload on my TODO list, though. -- Peter Geoghegan
