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…
Фильтры
No UPDATE updates
Working with databases one can’t help but wonder what happens with data stored on the disk. For example you need to know this to be able to…
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…
pg_wal is too big… what’s going on?
What’s common between DBA and detective? They both solve murder and mystery while trying to make sense of the nonsense. Recently, one of our clients had Postgres…