Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 1 Stunde 59 Minuten

Esther Minano: Behind the scenes: Speeding up pgstream snapshots for PostgreSQL

1. Juli 2025 - 12:30
How targeted improvements helped us speed up bulk data loads and complex schemas.

Umair Shahid: From 99.9% to 99.99%: Building PostgreSQL Resilience into Your Product Architecture

1. Juli 2025 - 11:55

Most teams building production applications understand that “uptime” matters. I am writing this blog to demonstrate how much difference an extra 0.09% makes.

At 99.9% availability, your system can be down for over 43 minutes every month. At 99.99%, that window drops to just over 4 minutes. If your product is critical to business operations, customer workflows, or revenue generation, those 39 extra minutes of downtime each month can be the difference between trust and churn.

Abhishek Chanda: Running Postgres on Cloudflare Containers

1. Juli 2025 - 6:06

Disclaimer: I work for Cloudflare. The views and opinions expressed in this post are my own and do not necessarily reflect the official policy or position of Cloudflare.

Mankirat Singh: June, BuildFarm and ABIs

1. Juli 2025 - 2:00
This blog discusses the current progress and implementation of an automated ABI compliance reporting system for PostgreSQL, which is also my GSoC 2025 project.

Dmitry Dolgov: An example for metrics assisted modeling of database performance

1. Juli 2025 - 2:00
PostgreSQL community conferences, as many other industry driven events, usually do not have proceedings or anything similar. All you get is a slide deck and, if you're lucky, a video recording. But it often feels not enough, as it was with one of my talks last year at PGConfDE, where the topic I was talking about included examples of mathematical modeling to predict how the database will behave. Plenty of things were not said or were not communicated with enough details, because they were simply not fitting the format.

Jan Wieremjewicz: The PG_TDE Extension Is Now Ready for Production

30. Juni 2025 - 18:00
Lately, it feels like every time I go to a technical conference, someone is talking about how great PostgreSQL is. I’d think it’s just me noticing, but the rankings and surveys say otherwise. PostgreSQL is simply very popular. From old-school bare metal setups to VMs, containers, and fully managed cloud databases, PostgreSQL keeps gaining ground. And […]

Andreas 'ads' Scherbaum: Samed YILDIRIM

30. Juni 2025 - 16:00
PostgreSQL Person of the Week Interview with Samed YILDIRIM: I’m originally from Turkey. The last city I lived in Turkey was Istanbul. I am now living in Riga, Latvia for more than 5 years already.

Ian Barwick: PgPedia Week, 2025-06-29

30. Juni 2025 - 12:50

Housekeeping announcements:

this website's PostgreSQL installation is now on version 17 ( insert champagne emoji here ) the search function now works properly with non-ASCII characters ( there was an embarrassing oversight which went unnoticed until someone kindly pointed it out ) PostgreSQL 18 changes this week

This week there have been a couple of renamings:

Tomas Vondra: How often is the query plan optimal?

30. Juni 2025 - 12:00

The basic promise of a query optimizer is that it picks the “optimal” query plan. But there’s a catch - the plan selection relies on cost estimates, calculated from selectivity estimates and cost of basic resources (I/O, CPU, …). So the question is, how often do we actually pick the “fastest” plan? And the truth is we actually make mistakes quite often.

Andreas Scherbaum: Performance Test for Percona Transparent Data Encryption (TDE)

30. Juni 2025 - 0:00
This blog posting compares the performance of the pg_tde by Percona extension for PostgreSQL with the performance of an unmodified PostgreSQL. The pg_tde by Percona extension provides encryption for both data pages on disk as well as WAL files on disk - Encryption at Rest. The extension is currently in the rc stage (release candidate). This test does not compare pg_tde by Percona to other products. It tests the extension performance and compares with unmodified PostgreSQL, and shows how much overhead it is to encrypt data at rest, and encrypt WAL.

Ian Barwick: PgPedia Week, 2025-06-22

28. Juni 2025 - 6:22

PgPedia Week has been delayed this week due to malaise and other personal circumstances.

semab tariq: Choosing the Right Barman Backup Type and Mode for Your PostgreSQL Highly Available Cluster

27. Juni 2025 - 12:55

When running a PostgreSQL database in a High Availability (HA) cluster, it’s easy to assume that having multiple nodes means your data is safe. But HA is not a replacement for backups. If someone accidentally deletes important data or runs a wrong update query, that change will quickly spread to all nodes in the cluster. Without proper safeguards, that data is gone everywhere. In these cases, only a backup can help you restore what was lost.

Dave Stokes: Entity Relationship Maps

25. Juni 2025 - 15:26

    Even the most experienced database professionals are known to feel a little anxious when peering into an unfamiliar database. Hopefully, they inspect to see how the data is normalized and how the various tables are combined to answer complex queries.  Entity Relationship Maps (ERM) provide a visual overview of how tables are related and can document the structure of the data.

Gabriele Bartolini: CNPG Recipe 20 – Finer Control of Postgres Clusters with Readiness Probes

25. Juni 2025 - 8:04

Explore the new readiness probe introduced in CloudNativePG 1.26, which advances Kubernetes-native lifecycle management for PostgreSQL. Building on the improved probing infrastructure discussed in my previous article, this piece focuses on how readiness probes ensure that only fully synchronised and healthy instances—particularly replicas—are eligible to serve traffic or be promoted to primary.

Seiten