Category: boguk

Automated index bloat management: How pg_index_watch keeps PostgreSQL indexes lean.

To follow up on my introductory blog post, here is a more extensive deep dive into ins and outs of pg_index_watch. In this post, I will take…

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…

pg_utils: Low_used_indexes.sql, how it works and why it should be lower than 0.01?

If you work with PostgreSQL the chances that you are aware or used our pg_utils are quite high. One of them is low_used_indexes.sql that lately we received…