| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Wasim Devale <wasimd60(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Reindexing |
| Date: | 2025-04-25 05:57:23 |
| Message-ID: | 6a9ed5b7ca2f7c1ba61f27a969cebcbd50cff4b6.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bo Guo | 2025-04-25 16:43:38 | When indexing is needed for a temp table |
| Previous Message | Wasim Devale | 2025-04-25 05:16:29 | Reindexing |