On Fri, 2025-04-25 at 10:46 +0530, Wasim Devale wrote:
> I want to automate the reindexing and planning to do it concurrently twice a week.
That's probably unnecessary.
> Can someone highlight at what percentage of index bloat can decide the frequency of reindexing?
It is perfectly normal for a B-tree index to have an "avg_leaf_density" of 30 or so,
as determined with pgstatindex(). Consider reindexing only for indexes that are
doing worse *and that keep deteriorating*.
Yours,
Laurenz Albe