Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 3 Stunden 2 Minuten

semab tariq: Replication Types and Modes in PostgreSQL

10. Juli 2025 - 15:09

Data is a key part of any mission-critical application. Losing it can lead to serious issues, such as financial loss or harm to a business’s reputation. A common way to protect against data loss is by taking regular backups, either manually or automatically. However, as data grows, backups can become large and take longer to complete. If these backups are not managed properly or tested often, a sudden system crash could result in permanent data loss.

Jan Wieremjewicz: Active-active replication - the hidden costs and complexities

10. Juli 2025 - 2:00

In Part 1 of this series, we discussed what active-active databases are and identified some “good” reasons for considering them, primarily centered around extreme high availability and critical write availability during regional outages. Now, let’s turn our attention to the less compelling justifications and the substantial challenges that come with implementing such a setup.

Tomas Vondra: So why don't we pick the optimal query plan?

8. Juli 2025 - 12:00

Last week I posted about how we often don’t pick the optimal plan. I got asked about difficulties when trying to reproduce my results, so I’ll address that first (I forgot to mention a couple details). I also got questions about how to best spot this issue, and ways to mitigate this. I’ll discuss that too, although I don’t have any great solutions, but I’ll briefly discuss a couple possible planner/executor improvements that might allow handling this better.

Andreas 'ads' Scherbaum: Josef Machytka

7. Juli 2025 - 16:00
PostgreSQL Person of the Week Interview with Josef Machytka: I was born in Czechia and lived most of my life there. However, for the last 12 years, my family and I have been calling Berlin, Germany, our home. It is an open-minded place that gives people a lot of freedom, we like it here very much.

Ian Barwick: PgPedia Week, 2025-07-06

7. Juli 2025 - 13:38

PostgreSQL 19 development is now officially under way, so from now on any new features will be committed to that version. Any significant PostgreSQL 18 changes (e.g. reversions or substantial changes to already committed features) will be noted here separately (there were none this week).

PostgreSQL 19 changes this week

The first round of new PostgreSQL 19 features is here:

Chris Ellis: PGDay UK 2025 - Schedule Published

4. Juli 2025 - 15:27

We are excited to announce the schedule for PGDay UK 2025 has been published. We've got an exciting line up for talks over a range of topics. There will be something for everyone attending.

Take a look at what we have going on: https://pgday.uk/events/pgdayuk2025/schedule/

We'd like to extend our gratitude to the whole CFP team, who did an amazing job selecting the talks to make up the schedule.

Wim Bertels: PGConf.be 2025

4. Juli 2025 - 14:07
A round up of the fifth PGConf.be

The shared presentations are online, as are a couple of recordings and turtle-loading have-a-cup-of-tea locally stored photos.

Andrew Farries: pgroll 0.14 - New commands and more control over version schemas

4. Juli 2025 - 13:45
pgroll 0.14 is released with several new subcommands and better control over how version schema are created.

warda bibi: Disaster Recovery Guide with pgbackrest

3. Juli 2025 - 16:18

Recently, we worked with a client who was manually backing up their 800GB PostgreSQL database using pg_dump, which was growing rapidly and had backups stored on the same server as the database itself. This setup had several critical issues:

Andrei Lepikhov: On Postgres Plan Cache Mode Management

3. Juli 2025 - 10:29

Having attended PGConf.DE'2025 and discussed the practice of using Postgres on large databases there, I was surprised to regularly hear the opinion that query planning time is a significant issue. As a developer, it was surprising to learn that this factor can, for example, slow down the decision to move to a partitioned schema, which seems like a logical step once the number of records in a table exceeds 100 million. Well, let's figure it out.

Andrew Atkinson: Avoid UUID Version 4 Primary Keys

2. Juli 2025 - 2:00
Introduction

Over the last decade, when working on databases where UUID Version 41 was picked as the primary key data type, these databases usually have bad performance and excessive IO.

UUID is a native data type that can be stored as binary data, with various versions outlined in the RFC. Version 4 is mostly random bits, obfuscating information like when the value was created, or where it was generated.

Ilya Kosmodemiansky: Operating PostgreSQL as a Data Source for Analytics Pipelines – Recap from the Stuttgart Meetup

1. Juli 2025 - 13:29

PostgreSQL user groups are a fantastic way to build new connections and engage with the local community. Last week, I had the pleasure of speaking at the Stuttgart meetup, where I gave a talk on “Operating PostgreSQL as a Data Source for Analytics Pipelines.”

Below are my slides and a brief overview of the talk. If you missed the meetup but would be interested in an online repeat, let me know in the comments below!

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.

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.

Seiten