On Tue, Jul 9, 2019 at 10:31 AM John Lumby <johnlumby(at)hotmail(dot)com> wrote:
> Yes, I see that. But surely "making splits occur less often" is a desirable
> objective in itself, is it not? And I believe that a parameter to preserve the "steady-state"
> density in high-traffic indexes would help achieve that goal, wouldn't you agree?
Anything that reliably reduces page splits without hurting space
utilization is well worthwhile. I can't see how what you describe
could have that effect, though. If you expect the leaf density to be
the same after a REINDEX, then why bother at all? There is no reason
to think that that will be more effective than simple vacuuming.
--
Peter Geoghegan