Sammlung von Newsfeeds

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

Neues vom PostgreSQL Planet - 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

Neues vom PostgreSQL Planet - 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

Neues vom PostgreSQL Planet - 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

Neues vom PostgreSQL Planet - 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

Neues vom PostgreSQL Planet - 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.

Magnus Hagander: PGConf.EU 2025 - Registration opened

Neues vom PostgreSQL Planet - 24. Juni 2025 - 16:37

The registration for PGConf.EU 2025, which will take place on 21-24 October in Riga, is now open.

We have a limited number of tickets available for purchase with the discount code EARLYBIRD.

This year, the first day of training sessions has been replaced with a Community Events Day. This day has a more limited space, and can be booked as part of the conference registration process or added later, as long as seats last.

Radim Marek: Beyond the Basics of Logical Replication

Neues vom PostgreSQL Planet - 24. Juni 2025 - 9:10

With First Steps with Logical Replication we set up a basic working replication between a publisher and a subscriber and were introduced to the fundamental concepts. In this article, we're going to expand on the practical aspects of logical replication operational management, monitoring, and dive deep into the foundations of logical decoding.

Cornelia Biacsics: Contributions for the week of 2025-06-09 (Week 24)

Neues vom PostgreSQL Planet - 24. Juni 2025 - 8:36

On June, 9th, Andrzej Nowicki held a talk about “From Queries to Pints: Building a Beer Recommendation System with pgvector” at the Malmö PostgreSQL User Group.

On June, 3rd the 5. PostgreSQL User Group NRW MeetUp took place in Germany.

Peter Eisentraut: Waiting for SQL:202y: Vectors

Neues vom PostgreSQL Planet - 24. Juni 2025 - 6:00

It’s been a while since SQL:2023 was published, and work on the SQL standard continues. Nowadays, everyone in the database field wants vectors, and SQL now has them, too.

(I’m using the term “SQL:202y” for “the next SQL standard after SQL:2023”. I took this naming convention from the C standard, but it’s not an official term for the SQL standard. The current schedule suggests a new release in 2028, but we’ll see.)

Andreas 'ads' Scherbaum: Suraj Kharage

Neues vom PostgreSQL Planet - 23. Juni 2025 - 16:00
PostgreSQL Person of the Week Interview with Suraj Kharage: My name is Suraj Kharage and I am from Pune, India. I have over 10 years of experience with the Postgres database and got introduced to Postgres during my first professional experience at NTT DATA back in 2014. I am an internal database developer working with EDB and mostly contribute to EDB’s proprietary product EDB Advanced server (EPAS).

Dave Page: PGDay UK 2025 - Registration open

Neues vom PostgreSQL Planet - 23. Juni 2025 - 15:45

PGDay UK 2025 will be held in London, England, on Tuesday, September 9, 2025 at the Cavendish Conference Centre.

It features a full day with a track of PostgreSQL presentations from global PostgreSQL experts. It will cover a wide range of topics of interest.

Registration has now opened. Seats are limited so we recommend that you register early if you are interested! There are 20 Early bird discounted tickets available until the 31th of July 2025; grab yours before they run out or the campaign ends.

Ahmet Gedemenli: pgstream v0.7.1: JSON transformers, progress tracking and wildcard support for snapshots

Neues vom PostgreSQL Planet - 20. Juni 2025 - 13:45
Learn how pgstream v0.7.1 transforms JSON data, improves snapshot experience with progress tracking and wildcard support.

semab tariq: Which PostgreSQL HA Solution Fits Your Needs: Pgpool or Patroni?

Neues vom PostgreSQL Planet - 20. Juni 2025 - 13:13

When designing a highly available PostgreSQL cluster, two popular tools often come into the conversation: Pgpool-II and Patroni. Both are widely used in production environments, offer solid performance, and aim to improve resilience and reduce downtime; however, they take different approaches to achieving this goal.

Alexander Korotkov: The differences between OrioleDB and Neon

Neues vom PostgreSQL Planet - 20. Juni 2025 - 2:00

In a recent Hacker News discussion, there was some confusion about the differences between OrioleDB and Neon. Both look alike at first glance. Both promise a "next‑gen Postgres". Both have support for cloud‑native storage.

This post explains how the two projects differ in practice. And importantly, OrioleDB is more than an undo log for PostgreSQL.

Robert Haas: PostgreSQL Hacking + Patch Review Workshops for July 2025

Neues vom PostgreSQL Planet - 19. Juni 2025 - 20:01
Next month, I'll be hosting 2 or 3 discussions of Tomas Vondra's talk, Fast-path locking improvements in PG18, given at 2025.pgconf.dev (talk description here). If you're interested in joining us, please sign up using this form and I will send you an invite to one of the sessions.

Jan Wieremjewicz: PostgreSQL active-active replication, do you really need it?

Neues vom PostgreSQL Planet - 18. Juni 2025 - 2:00
PostgreSQL active-active replication, do you really need it? Before we start, what is active-active?

Active-active, also referred to as multi-primary, is a setup where multiple database nodes can accept writes at the same time and propagate those changes to the others. In comparison, regular streaming replication in PostgreSQL allows only one node (the primary) to accept writes. All other nodes (replicas) are read-only and follow changes.

In an active-active setup:

Gabriele Bartolini: CNPG Recipe 19 – Finer Control Over Postgres Startup with Probes

Neues vom PostgreSQL Planet - 17. Juni 2025 - 12:17

CloudNativePG 1.26 introduces enhanced support for Kubernetes startup probes, giving users finer control over how and when PostgreSQL instances are marked as “started.” This article explores the new capabilities, including both basic and advanced configuration modes, and explains the different probe strategies—such as pg_isready, SQL query, and streaming for replicas. It provides practical guidance for improving the reliability of high-availability Postgres clusters by aligning startup conditions with actual database readiness.

Laurenz Albe: Preserve optimizer statistics during major upgrades with PostgreSQL v18

Neues vom PostgreSQL Planet - 17. Juni 2025 - 11:07


© Laurenz Albe 2025

Everybody wants good performance. When it comes to the execution of SQL statements, accurate optimizer statistics are key. With the upcoming v18 release, PostgreSQL will preserve the optimizer statistics during an upgrade with dump/restore or pg_upgrade (see commit 1fd1bd8710 and following). With the beta testing season for PostgreSQL v18 opened, it is time to get acquainted with the new feature.

Laurenz Albe: SELECT FOR UPDATE considered harmful in PostgreSQL

Neues vom PostgreSQL Planet - 17. Juni 2025 - 8:00


© Laurenz Albe 2025

Recently, while investigating a deadlock for a customer, I was again reminded how harmful SELECT FOR UPDATE can be for database concurrency. This is nothing new, but I find that many people don't know about the PostgreSQL row lock modes. So here I'll write up a detailed explanation to let you know when to avoid SELECT FOR UPDATE.

ahmed gouda: My PostgreSQL GSoC’25 Journey

Neues vom PostgreSQL Planet - 17. Juni 2025 - 2:00
  • The Post will be Continuously Updated.
Postgres community bonding

The first phase of GSoC is Community Bonding where mentee gets to know the community of his Organization.

Seiten