Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
URL: https://planet.postgresql.org
Aktualisiert: vor 2 Stunden 15 Sekunden

Ian Barwick: PgPedia Week, 2025-12-07

5. Januar 2026 - 0:44
PostgreSQL 19 changes this week pg_stat_replication_slots newly added column  slotsync_skip_at renamed to slotsync_last_skip pg_dsm_registry_allocations improvments to display of the size of DSAs and dshashes PostgreSQL 18 articles A deeper look at old UUIDv4 vs new UUIDv7 in PostgreSQL 18 (2025-12-05) - Josef Machytka / Credativ

more...

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 19 – Implement ALTER TABLE … MERGE/SPLIT PARTITIONS … command

4. Januar 2026 - 18:30
On 14th of December 2025, Alexander Korotkov committed patch: Implement ALTER TABLE ... MERGE PARTITIONS ... command   This new DDL command merges several partitions into a single partition of the target table. The target partition is created using the new createPartitionTable() function with the parent partition as the template.

Floor Drees: Sticking with Open Source: pgEdge and CloudNativePG

2. Januar 2026 - 1:00
We talked to Matthew Mols, Sr. Director of Engineering at pgEdge, about how CloudNativePG enables them to meet the requirements of their customers using just open source.

Gabriele Bartolini: CloudNativePG in 2025: CNCF Sandbox, PostgreSQL 18, and a new era for extensions

31. Dezember 2025 - 12:50

2025 marked a historic turning point for CloudNativePG, headlined by its acceptance into the CNCF sandbox and a subsequent application for incubation. Throughout the year, the project transitioned from a high-performance operator to a strategic architectural partner within the cloud-native ecosystem, collaborating with projects like Cilium and Keycloak. Key milestones included the co-development of the extension_control_path feature for PostgreSQL 18, revolutionising extension management via OCI images, and the General Availability of the Barman Cloud Plugin.

Imran Zaheer: PostgreSQL Recovery Internals

30. Dezember 2025 - 6:30

Modern databases must know how to handle failures gracefully, whether they are system failures, power failures, or software bugs, while also ensuring that committed data is not lost. PostgreSQL achieves this with its recovery mechanism; it allows the recreation of a valid functioning system state from a failed one. The core component that makes this possible is Write-Ahead Logging (WAL); this means PostgreSQL records all the changes before they are applied to the data files. This way, WAL makes the recovery smooth and robust.

Floor Drees: PostgreSQL Contributor Story: Manni Wood

29. Dezember 2025 - 9:59
Earlier this year we started a program (“Developer U”) to help colleagues who show promise for PostgreSQL Development to become contributors. Manni's manager is responsible for his participation in the program. He always assumed that he didn’t have the skills, but taught himself some x86 assembler and C in his spare time, and when it came to apply, she encouraged him to give it a shot.

REGINA OBE: FOSS4GNA 2025: Summary

29. Dezember 2025 - 0:37

Free and Open Source for Geospatial North America (FOSS4GNA) 2025 was running November 3-5th 2025 and I think it was one of the better FOSS4GNAs we've had. I was on the programming and workshop committees and we were worried with the government shutdown that things could go badly since we started getting people withdrawing their talks and workshops very close to curtain time.

Cornelia Biacsics: Contributions for week 53, 2025

28. Dezember 2025 - 22:22

Emma Sayoran organized a PUG Armenia speed networking meetup on December 25 2025.

FOSDEM PGDay 2026 Schedule announced on Dec 23 2025. Call for Paper Committee:

  • Teresa Lopes
  • Stefan Fercot
  • Flavio Gurgel

Community Blog Posts:

Ryan Lambert: Improved Quality in OpenStreetMap Road Network for pgRouting

28. Dezember 2025 - 6:01

Recent changes in the software bundled in PgOSM Flex resulted in unexpected improvements when using OpenStreetMap roads data for routing. The short story: routing with PgOSM Flex 1.2.0 is faster, easier, and produces higher quality data for routing! I came to this conclusion after completing a variety of testing with the old and new versions of PgOSM Flex. This post outlines my testing and findings.

Seiten