credativ® Blog

Here you will find interesting news about industry-specific topics and us.

Categories
Category
Tags

Categories

Tags

Posts by: Michael Banck

About the author

Michael Banck

about the person

Michael Banck has been an employee of credativ GmbH since 2009, a member of the Debian project since 2001, and is also active in other open-source projects. As a member of the database team at credativ, he has supported and advised various customers in recent years on solving problems with and the daily operation of PostgreSQL®, as well as on the introduction of high-availability solutions in the database sector.

View posts

06 July 2026

Replication Deadlock Bug in Current Postgres Releases 14-16

Replication Deadlock Bug in Current Postgres Releases 14-16 The current minor releases of Postgres versions 14-16 (14.23, 15.18 and 16.14, released on May 14th) introduced a regression that can lead to a MultiXactOffsetSLRU deadlock during transaction log (WAL) replay in certain circumstances. The bug was (to our knowledge) first reported in Bug#19490 on May 20th […]

Read more

23 September 2025

PGDay UK 2025

The third annual PGDay UK was (again) held at the Cavindish Conference Center in London this year, and I participated for the first time with an updated English version of my PGConf.DE talk, “PostgreSQL Performance Tuning”. Dave Page kicking off PGDay UK 2025 The conference is a one-day, one-track event with an auditorium and a […]

Read more

17 December 2024

Quick Benchmark: Improvements to Large Object Dumping in Postgres 17

Version 17 of PostgreSQL has been released for a while. One of the many features is a change by Tom Lane called “Rearrange pg_dump’s handling of large objects for better efficiency”. In the past, we have seen our customers have several problems with a large number of large objects being a performance issue for dump/restore. […]

Read more

03 September 2024

Quick Benchmark: ANALYZE vs. maintenance_io_concurrency

Introduction Running ANALYZE (either explicitly or via auto-analyze) is very important in order to have uptodate data statistics for the Postgres query planner. In particular after in-place upgrades via pg_upgrade, ANALYZE needs to be run in order to have any query statistics at all. As ANALYZE samples only parts of the blocks in a table […]

Read more

02 July 2024

Instaclustr Managed Postgres with Terraform Part 1

Hashicorp Terraform is a well-known infrastructure automation tool mostly targeting cloud deployments. Instaclustr (a part of NetApp’s CloudOps division and credativ’s parent company) provides a managed service for various data stores, including PostgreSQL. Provisioning managed clusters is possible via the Instaclustr console, a REST API or through the Instaclustr Terraform Provider. In this first part […]

Read more