Neues vom PostgreSQL Planet

When you are running mission-critical applications, like online banking, healthcare systems, or global e-commerce platforms, every second of downtime can cost millions and damage your business reputation. That’s why many customers aim for four-nines (99.99%) or five-nines (99.999%) availability for their applications

In this post, we will walk through what those nines really mean and, more importantly, which PostgreSQL cluster setup will get you there.

A comparison of logical replication and ETL for syncing data with Postgres

What do tech journalism, PR, and PostgreSQL have in common? For Elly Phneah, the answer is community. Based in Malmö, Elly is the driving force behind the Malmö Postgres User Group (M‑PUG, for short), where she combines her background in communications with a deep passion for databases and developer communities.

GSoC 2025 Project Report, PostgreSQL Upgrade pgwatch Grafana dashboards to v12

Contributor: Gaurav Patidar

Organisation: PostgreSQL

Mentors: Pavlo Golub, Rajiv Harlalka

Project Repository: pgwatch_grafana

Photo by Elnaz Asadi

Each year I go through the changes and additions to EXPLAIN in the upcoming PostgreSQL major version, to see what we need to add support for in pgMustard.

In the previous post, I explored some nuances of Postgres related to indexes and parallel workers. This text sparked a lively discussion on LinkedIn, during which one commentator (thanks to Ants Aasma) proposed an index that was significantly more efficient than those discussed in the article.

PostgreSQL is built to perform. However, as workloads increase and systems evolve, even the most robust setups can begin to show signs of strain. Whether you are scaling a product or supporting enterprise SLAs, performance slowdowns tend to surface when you least want them to.

If you are a technology leader overseeing a team of developers who manage PostgreSQL as part of a broader application stack, or you are responsible for uptime and customer satisfaction at scale, knowing where to look first can make all the difference.

Introduction

The importance of backups is universally acknowledged in our digital world. One of my former esteemed colleagues told me that he can't think of a database system without backups. This perspective has resonated with me over the years. Today, in our CNPG series, we will be taking a look at the backup solution and how we restore a database from the backup.