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
