Neues vom PostgreSQL Planet
Ian Barwick: PgPedia Week, 2025-08-17
The middle of August tends to be a quieter time in the PostgreSQL development cycle, so there's not much in the way of new developmentst to report.
This week's main item of interest is the quarterly release of PostgreSQL minor version updates.
PostgreSQL 19 changes this weekPostgreSQL 19 beta3 was released this week.
semab tariq: Cold, Warm, and Hot Standby in PostgreSQL: Key Differences
When working with customers, a common question we get is: “Which standby type is best for our HA needs?” Before answering, we ensure they fully understand the concepts behind each standby type and provide the necessary guidance
A standby server is essentially a copy of your primary database that can take over if the primary fails.
There are different types of standby setups, each with its own use cases, pros, and cons. In this blog, we will discuss the three types: Cold Standby, Warm Standby, and Hot Standby.
Ian Barwick: PgPedia Week, 2025-08-10
Regina Obe: Learning PostgreSQL from AI and JSON exploration: Part 2
This is the second part of the series I started on Learning PostgreSQL from AI and JSON exploration: Part 1. For this 2nd part, I decided to try gpt-oss the 14GB model which was just released in the past week. My first impression, "When will this ai shut up about its thinking process?".
Umut TEKIN: Exploration: Migration to CNPG
In our CNPG series, we have explained how to create a PostgreSQL cluster and how to customize it. However, most of the time, we don't have the luxury to start to use a database from scratch. We might have already started a project without high availability and we might be looking for an easy-to-manage environment on cloud native environment. In this case, CNPG is the answer, but how do we migrate our existing cluster to CNPG? In today's article, we will explain that.
Umair Shahid: PostgreSQL Database SLAs: Why Hidden Issues Often Break Customer Commitments
SLAs feel reassuring when signed—but their substance lies in what happens behind the scenes. Often, the most damaging breaches don’t stem from cloud outages or server failures, but from invisible issues hidden in how PostgreSQL was initially set up and configured. Increasingly sluggish queries, split-brain scenarios, silent backup failures, any of these can suddenly explode into customer-facing crises.
Tomas Vondra: Fun and weirdness with SSDs
When I started working with Postgres (or databases in general) 25 years ago, storage systems looked very different. All storage was “spinning rust” - rotational disks with various interfaces (SATA/SAS/…) and speeds (7.2K/10k/15k/…). The spindle speed was the main performance determining feature, and everyone knew what IOPS and bandwidth to expect from a disk. The general behavior was pretty much the same.
Stefanie Janine: Postgresql Performance
Elizabeth Garrett Christensen: Postgres Logging for Performance Optimization
A modern-day Postgres instance creates robust and comprehensive logs for nearly every facet of database and query behavior. While Postgres logs are the go-to place for finding and debugging critical errors, they are also a key tool in application performance monitoring.
Alexander Korotkov: Ordered Insertion Optimization in OrioleDB
When many sessions try to insert into the same B-tree leaf page, classic exclusive page locking serializes progress and wastes time on sleep/wake cycles. We’re introducing a batch page insertion path that lets the session holding the page lock insert for itself and its neighbors. The result: dramatically reduced lock waits, and big gains at high client counts (2X throughput boost starting from 64 clients in our benchmark).
Stefanie Janine: pgsql_tweaks 0.11.5 Released
One could install the whole package, or just copy what is needed from the source code.
The extension is also available on PGXN.
The extension is also availabe through the PostgreSQL rpm packages.
General changesNo code has been changed.
Ian Barwick: PgPedia Week, 2025-08-03
Regina Obe: PostGIS 3.6.0rc1
The PostGIS Team is pleased to release PostGIS 3.6.0rc1! Best Served with PostgreSQL 18 Beta3 and soon to be released GEOS 3.14.
This version requires PostgreSQL 12 - 18beta3, GEOS 3.8 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.14+ is needed. To take advantage of all SFCGAL features, SFCGAL 2.2.0+ is needed.
Stefanie Janine: pgsql_tweaks 0.11.4 Released
One could install the whole package, or just copy what is needed from the source code.
The extension is also available on PGXN.
The extension is also availabe through the PostgreSQL rpm packages.
Robert Haas: Hacking Workshop for September 2025
Next month, I'll be hosting 2 or 3 discussions of David Rowley's talk, Writing fast C code for a modern CPU (and applying it to PostgreSQL), given at 2025.pgconf.dev (talk description here).
Robins Tharakan: Testing PostgreSQL on Debian/Hurd: A Windows + QEMU Adventure
Gabriele Bartolini: CNPG Recipe 21 – Finer Control of Postgres Clusters with Liveness Probes
In this article, I explore how CloudNativePG 1.27 enhances PostgreSQL liveness probes, including primary isolation checks that mitigate split-brain scenarios and integrate seamlessly with Kubernetes. We also discuss how these improvements lay the groundwork for advanced features like quorum-based failover while maintaining stability, safety, and community-driven decision-making.
Sergey Solovev: The PostgreSQL Hacker Helper extension is one year old
PostgreSQL Hacker Helper is a VS Code extension for developing PostgreSQL source code. A couple of days ago (August 9th), one year has passed since the release of version 1.0.0.
Initially, it was a utility for dynamically calculating expressions and casting variables, but after a while I realized that not everything is so simple. The main catch is that there are types (if you can say so) that require special treatment.
Francesco Tisiot: Free PostgreSQL® in the Cloud
A short summary of Free PostgreSQL® services in the cloud as of August 14th 2025
Jan Wieremjewicz: pg_stat_monitor Needs You! Join the Feedback Phase
At Percona, we believe that great open source software is built with the Community, not just for it. As we plan the next iteration of pg_stat_monitor, our advanced PostgreSQL monitoring extension, we’re taking a closer look at the current feature set and how it aligns with real-world usage. In open source, the community isn’t just a user base, it’s the most important stakeholder. While we set the vision, your feedback is the compass that guides us.
Seiten
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- …
- nächste Seite ›
- letzte Seite »