Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 3 Minuten 6 Sekunden

Regina Obe: PostGIS 3.5.3

17. Mai 2025 - 2:00

The PostGIS Team is pleased to release PostGIS 3.5.3.

This version requires PostgreSQL 12 - 18beta1, GEOS 3.8 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.12+ is needed. SFCGAL 1.4+ is needed to enable postgis_sfcgal support. To take advantage of all SFCGAL features, SFCGAL 1.5+ is needed.

semab tariq: How to Safely Perform Backfill Operations in TimescaleDB

16. Mai 2025 - 12:27

Backfilling data into a TimescaleDB hypertable in production can be very tricky, especially when automated processes like compression policies are involved. From past experience, we have seen that if backfill operations aren’t handled properly, they can interfere with these automated tasks, sometimes causing them to stop working altogether. 

This blog covers a safer and more reliable approach to backfilling hypertables, along with best practices to prevent disruptions to compression and other background processes.

What is a Backfill Operation?

Cornelia Biacsics: Contributions for the week of 2025-05-05 (Week 19)

15. Mai 2025 - 16:27

An Vercammen, Gregory Gioffredi and Wim Bertels organized PGConf.BE 2025, with help from Vera Demaiter and Aimée Lynn Backiel.

Christoph Berg: From VACUUM to Deutsche Bahn: The Most Unexpected Moments at PGConf.DE 2025

14. Mai 2025 - 15:31
Pre-Conference Travels: Debian & Berlin

The week before this year's PGConf.DE, I attended the Debian MiniDebConf in Hamburg. Adding Berlin to the itinerary made for a busy two weeks on the road. Still, it gave me time to prep for my PGConf talk while catching up on Debian-related discussions.

Tudor Golubenco: Xata: Postgres with data branching and PII anonymization

14. Mai 2025 - 13:00
Relaunching Xata as "Postgres at scale". A Postgres platform with Copy-on-Write branching, data masking, and separation of storage from compute.

David Wheeler: 2025 GSOC: Mankirat Singh — ABI Compliance Reporting

13. Mai 2025 - 20:25

I’m pleased to welcome Mankirat Singh to the Postgres community as a 2025 Google Summer of Code contributor. Mankirat will be developing an ABI compliance checker and reporting system to help identify and prevent unintentional ABI changes in future minor Postgres releases.

Umair Shahid: Step by Step Guide on Setting Up Physical Streaming Replication in PostgreSQL

13. Mai 2025 - 15:37

Physical streaming replication in PostgreSQL allows you to maintain a live copy of your database on a standby server, which continuously receives updates from the primary server’s WAL (Write-Ahead Log). This standby (or hot standby) can handle read-only queries and be quickly promoted to primary in case of failover, providing high availability and disaster recovery.

Josef Machytka: PostgreSQL Conference Germany 2025

13. Mai 2025 - 8:00

PGConf.DE 2025, the 9th Annual PostgreSQL Conference Germany, was held on May 8–9, 2025, at the Marriott Hotel near Potsdamer Platz in Berlin. The event interconnected PostgreSQL enthusiasts, developers, DBAs, and industry sponsors for two days of fascinating talks across four parallel tracks. It was the biggest event so far, with 347 attendees. The whole conference was very well organized, and therefore special thanks are due to all the organizers—in particular Andreas Scherbaum, the main organizer—for their efforts and hard work.

Ian Barwick: PgPedia Week, 2025-05-11

12. Mai 2025 - 12:59

This week saw the routine quarterly round of PostgreSQL minor version updates , so now is your chance to upgrade. Note that PostgreSQL 13 is now officially EOL , so now is your chance to start planning upgrades.

PostgreSQL 18 changes this week

As expected, the PostgreSQL beta1 release is now available, and the PostgreSQL 18 documentation is now available, together with the release notes . Note that as the REL_18_STABLE branch has not yet been created, the PostgreSQL 18 and devel documentation are currently identical.

Tomas Vondra: Good time to test io_method (for Postgres 18)

12. Mai 2025 - 12:00

We’re now in the “feature freeze” phase of Postgres 18 development. That means no new features will get in - only bugfixes and cleanups of already committed changes. The goal is to test and stabilize the code before a release. PG 18 beta1 was released a couple days ago, so it’s a perfect time to do some testing and benchmarking.

Deepak Mahto: PostgreSQL 18 Beta Preview – Export or Amend Statistics with Ease

10. Mai 2025 - 19:56

PostgreSQL 18 beta has been released, and it’s the perfect time to start exploring the new features we can expect in the General Availability (GA) release. One feature that particularly caught my attention relates to improvements in statistics collection and usage.

Here’s an excerpt from the official PostgreSQL release notes:

Robins Tharakan: FOR KEY SHARE optimization and the SLRU Trap

10. Mai 2025 - 16:30
 FOR KEY SHARE optimization and the SLRU TrapOptimizing database concurrency is a constant balancing act. We often tweak locking strategies in PostgreSQL, aiming to allow more simultaneous operations without compromising data integrity. A common scenario involves shifting from stricter row-level locks to more lenient ones. But sometimes, what seems like a straightforward optimization can

Umair Shahid: Step by Step Guide on Setting Up Physical Streaming Replication in PostgreSQL

10. Mai 2025 - 1:30

Physical streaming replication in PostgreSQL allows you to maintain a live copy of your database on a standby server, which continuously receives updates from the primary server’s WAL (Write-Ahead Log). This standby (or hot standby) can handle read-only queries and be quickly promoted to primary in case of failover, providing high availability and disaster recovery. 

Noémi Ványi: pgroll v0.12.0 update

9. Mai 2025 - 15:57
pgroll v0.12 includes usability improvements like the new create command, verbose mode and idempotent migrate command

Umair Shahid: Improving PostgreSQL Performance with Partitioning

9. Mai 2025 - 13:30

My recommended methodology for performance improvement of PostgreSQL starts with query optimization. The second step is architectural improvements, part of which is the partitioning of large tables.

Partitioning in PostgreSQL is one of those advanced features that can be a powerful performance booster. If your PostgreSQL tables are becoming very large and sluggish, partitioning might be the cure.

The Big Table Problem

gabrielle roth: LinuxFest Northwest 2025 PostgreSQL Booth Report

9. Mai 2025 - 5:35
Jenn and I headed to Bellingham April 26 & 27th for LinuxFest Northwest, a 100% volunteer-run, free event. This is always a fun conference and there were lots of familiar faces this year! Some stats:Over 100 booth visitorsJust wanted to say how much they love Postgres: 18Asked about migrating from MySQL to Postgres: 1“We love […]

vignesh C: Understanding PostgreSQL Write-Ahead Logging (WAL)

9. Mai 2025 - 3:05

Earlier this year, I had the incredible opportunity to present at PGConf India, where I delved into the intricacies of Write-Ahead Logging (WAL) in PostgreSQL. My presentation aimed to demystify this crucial database feature that ensures data integrity and enhances performance. 

Noémi Ványi: pgroll 0.12.0 update

9. Mai 2025 - 2:00
pgroll v0.12 includes usability improvements like verbose mode and idempotent migrate command.

cary huang: Extending PostgreSQL with Java: Overcoming Integration Challenges

8. Mai 2025 - 22:56
Why Bridge Java with C in the First Place?

Bridging Java and C combines the strengths of both languages. A C application may rely on Java for modern libraries, cloud APIs, or UI and web capabilities, while a Java app might need C for low-level system access or performance-critical tasks. Sometimes, there’s simply no alternative—certain features only exist in one language. While modern languages like C++ and Go offer both high- and low-level control, many systems aren’t written in them.

Seiten