Sammlung von Newsfeeds

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 18 – Add UUID version 7 generation function.

Neues vom PostgreSQL Planet - 31. Dezember 2024 - 10:37
On 11st of December 2024, Masahiko Sawada committed patch: Add UUID version 7 generation function.   This commit introduces the uuidv7() SQL function, which generates UUID version 7 as specified in RFC 9652. UUIDv7 combines a Unix timestamp in milliseconds and random bits, offering both uniqueness and sortability.   In our implementation, the 12-bit sub-millisecond … Continue reading "Waiting for PostgreSQL 18 – Add UUID version 7 generation function."

Henrietta Dombrovskaya: Can we use this index, please? – Why not?

Neues vom PostgreSQL Planet - 30. Dezember 2024 - 3:30

It’s Christmas time and relatively quiet in my day job, so let’s make it story time again! One more tale from the trenches: how wrong you can go with one table and one index?

Ian Barwick: PgPedia Week, 2024-12-29

Neues vom PostgreSQL Planet - 29. Dezember 2024 - 21:21

Another calendar year draws to an end, so this will be the last PgPedia Week of 2024.

PostgreSQL 18 changes

As always, the end-of-year holidays mean commit log activity is lower than usual, but we did see one new potential performance improvement, with commit 58a359e5 (" Speedup tuple deformation with additional function inlining ") promising query performance increases of around 5-20% in deform-heavy OLAP-type workloads.

more...

Gabriele Bartolini: CloudNativePG in 2024: Milestones, Innovations, and Reflections

Neues vom PostgreSQL Planet - 29. Dezember 2024 - 12:27

2024 was a transformative year for CloudNativePG, marked by significant contributions to the Kubernetes ecosystem, increased adoption, and a growing community. This article reflects on key milestones, including the integration of advanced Kubernetes features, conference highlights, and personal insights, while looking ahead to the opportunities awaiting PostgreSQL in the cloud-native era.

Seiten