Waiting for PostgreSQL 11: Amcheck enhancement.
Check table’s indexed columns with amcheck. This weekend, an interesting patch related to amcheck was committed. Note, amcheck is a contrib module which allow to verify the…
Фильтры
Waiting for PostgreSQL 11: Pain free ADD COLUMN with non-NULL defaults
Fast ALTER TABLE ADD COLUMN with a non-NULL default. On 28th of March, Andrew Dunstan commited the following patch: commit 16828d5c0273b4fe5f10f42588005f16b415b2d8 Author: Andrew Dunstan <[email protected]> Date: Wed…
PostgreSQL Bloatbusters
Or when the vacuum is not enough. Anyone who works with PostgreSQL, whether a DBA or a developer, at some point encountered vacuum. All DBAs have configured…
Upgrading inheritance partitioning made easy.
An alternative way to upgrade to PostgreSQL 10 native partitioning using ALTER TABLEs and PLPGSQL. Today’s post is a bit spontaneous, because a few days ago I…
Deep dive into Postgres stats: pg_stat_progress_vacuum
Yet another post about vacuum… In today’s post I would like to talk about another stats enhancement that has been added in 9.6 and I hope will…
Deep dive into postgres stats: pg_stat_activity and pg_locks
DBA’s best friends: pg_stat_activity and pg_locks Today, I would like to discuss another handy stats views — pg_stat_activity. This is really useful and powerful view the value…