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…
Filters
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…
Vacuuming update-heavy tables
In my previous post I gave an overview of some general parameters that will work well in a standard setting. They might be aggressive, but will allow…
Accelerating VACUUM in Postgres
Couple of days ago we received a question in our blog about whether it is possible to speed up the VACUUM for large tables once the process…
Upgrade: pgCenter 0.9.0 is out!
Since the last pgCenter release I’ve been working on some new improvements and now it’s time to introduce you to pgCenter 0.9.0. Here are a few key…
pgstats.dev теперь еще лучше!
Прошло 5 месяцев с момента выхода разработанной нашим DBA, Алексеем Лесовским, динамической реализации диаграммы Postgres Observability – pgstats.dev. За это время мы получили огромное количество комментариев, предложений,…