Planet PostgreSQL – Maxim Boguk: Please welcome Pg_index_watch – a utility for dealing with index bloat on frequently updated tables.

One of the big topics in Postgres is bloat. It is something that every DBA comes across and in fact we have a few good posts on how to work with bloat in our blog. 
Update-heavy tables is a special case of data that due to business requirements needs to be updated frequently to stay relevant. Autovacuum may be a good solution for table bloat (you can check this post describing how to do that), however it does not help with index bloat. 
Pg_index_watch resolves this issue by automatically rebuilding indexes when needed. 
How it works?
With the introduction of REINDEX CONCURRENTLY in PostgreSQL 12 there was finally a safe way to rebuild indexes without heavy locks. At the same…

External feed Read More at the Source: https://postgr.es/p/5Lz