Index rebuilding strategy

2025-10-18 Thread Siraj G
Hello Experts! What are the top pointers we should consider for index rebuild? Check its size, bloat estimate, heavy Updates/Deletes? Please highlight the best practices. Thanks Siraj

Re: Index rebuilding strategy

2025-09-24 Thread Ron Johnson
On Wed, Sep 24, 2025 at 4:51 PM Alban Hertroys wrote: > > > On 24 Sep 2025, at 22:42, Siraj G wrote: > > > > Hello Experts! > > > > What are the top pointers we should consider for index rebuild? Check > its size, bloat estimate, heavy Updates/Deletes? > > > > Please highlight the best practice

Re: Index rebuilding strategy

2025-09-24 Thread Laurenz Albe
On Thu, 2025-09-25 at 02:12 +0530, Siraj G wrote: > What are the top pointers we should consider for index rebuild? Check its > size,  bloat estimate, heavy Updates/Deletes? https://www.cybertec-postgresql.com/en/should-i-rebuild-my-postgresql-index/ Yours, Laurenz Albe

Re: Index rebuilding strategy

2025-09-24 Thread Alban Hertroys
> On 24 Sep 2025, at 22:42, Siraj G wrote: > > Hello Experts! > > What are the top pointers we should consider for index rebuild? Check its > size, bloat estimate, heavy Updates/Deletes? > > Please highlight the best practices. I think just any pointers of corruption, really. OS updates wi