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…
Filter
VACUUM на часто обновляемых таблицах
В прошлой статье я описал общие настройки AUTOVACUUM, подходящие для обычной работы. Параметры агрессивные, но позволяют работать другим процессам в нормальном режиме. Часто обновляемые таблицы – это…
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…
pgstats.dev just got better!
It’s been 5 months since interactive Postgres Observability version – pgstats.dev was released. Since then I got plenty of comments and suggestions that helped me to implement…