Let’s speed things up.
Parallelism settings and how to accelerate your database performance. Few days ago, when performing a routine audit for our client, we noticed that parallel queries in the…
Filters
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…
Waiting for PostgreSQL 11: Covering + unique indexes.
Indexes with INCLUDE columns and their support in B-tree Last weekend, a very useful patch was committed, that enhances an already extensive Postgres indexing functionality. commit 8224de4f42ccf98e08db07b43d52fed72f962ebb…
Waiting for PostgreSQL 11: Online enabling of data checksums.
Enable data page checksums on the fly without the database interruption. New interesting patch was committed on Thursday, 5 Apr. Upd. Unfortunately this patch was reverted, and we…
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…