Neues vom PostgreSQL Planet
Andreas 'ads' Scherbaum: Dirk Krautschick
Jimmy Angelakos: Contributions for the week of 2025-05-19 (Weeks 20/21 overview)
-
Postgres Extensions Day took place May 12 in Montreal, Canada, organized by Chris Travers, and Yurii Rashkovskii, with Andrei Lepikhov, Michel Pelletier, and Gwen Shapira additionally on the Talk Selection Committee.
Ian Barwick: PgPedia Week, 2025-05-25
Sadly two features were reverted this week:
planner optimization "Partitions pruned by initial pruning are no longer locked" (commit 525392d5 , reverted in commit 1722d5eb ) function pg_get_process_memory_contexts() (commit 042a6629 , reverted in commit fb844b9f ) PostgreSQL 18 articles UUIDv7 Comes to PostgreSQL 18 (2025-05-09) - Gwen ShapiraJan Wieremjewicz: PostgreSQL 18 - Top Enterprise Features (fast read)
So the Beta1 is available for PostgreSQL 18 and while not all the features have to make it to GA, we can surely hope they do!
Taking a close look at what’s coming, here below is the selection of what excites me in particular:
Álvaro Hernández: How to Build Postgres with Zig: A Drop-In GCC/Clang Alternative
In case you are not familiar with it, Zig is a programming language. Among other characteristics, Zig prides itself on being a low-level / systems programming language with great interoperability with C and C++.
Andrew Atkinson: Big Problems From Big IN lists with Ruby on Rails and PostgreSQL
If you’ve created web apps with relational databases and ORMs like Active Record (part of Ruby on Rails), you’ve probably experienced database performance problems after a certain size of data and query volume.
In this post, we’re going to look at a specific type of problematic query pattern that’s somewhat common.
Jeremy Schneider: Collation Torture Test versus Debian
Collation torture test results are finally finished and uploaded for Debian.
https://github.com/ardentperf/glibc-unicode-sorting
The test did not pick up any changes in en_US sort order for either Bullseye or Bookworm
Buster has glibc 2.28 so it shows lots of changes – as expected.
Henrietta Dombrovskaya: Community Summit at PGConf.dev
Last week, I presented at the PGConf.dev for the first time and participated in a community summit for the first time. The idea was pitched by Teresa Giacomini, and that’s how this event was described in the program:
cary huang: Postgres Extensions Day 2025 Kicks Off with a Successful Debut in Montréal
PostgreSQL Extension Day 2025 made its successful debut on May 12, 2025, just one day before the start of pgconf.dev 2025. This focused one-day event brought together the community around a single theme: the PostgreSQL extension ecosystem. From innovative ideas and development insights to discussions on safer extension building and delivery, the day was all about “everything extensions.”
David Wheeler: Adventures in Extension Packaging
I gave a presentation at PGConf.dev last week, Adventures in Extension Packaging.
semab tariq: Best Practices for TimescaleDB Massive Delete Operations
Welcome to the second part of our TimescaleDB best practices series! In the first part, we explored how to perform massive backfill operations efficiently, sharing techniques to optimize performance and avoid common pitfalls. If you haven’t had a chance to read the first part yet, you can check it out using this link
In today’s blog, we will discuss another crucial aspect of time-series data management: massive delete operations.
Hubert 'depesz' Lubaczewski: pg_dump speed across versions
cary huang: pgconf.dev 2025 Wraps Up with Great Success in Montreal
pgconf.dev 2025 just wrapped up in Montreal, Canada, following its successful debut in Vancouver last year—and once again, it delivered a fantastic mix of deep technical content and strong community social activities.
Gülçin Yıldırım Jelínek: Xata Agent v0.3.1: Custom tools via MCP, Ollama integration, support for reasoning models & more
Dian Fay: pdot 1.0.0: Exploring Databases Visually, Part III
In what I can't say isn't a tradition at this point, we're in an odd-numbered year so there's news on the pdot front! Get it here!
DARIA NIKOLAENKO: Data archiving and retention in PostgreSQL. Best practices for large datasets
Just over a week ago, I attended PGConf.DE 2025 in Berlin with the rest of the Data Egret team and gave a talk titled “Data Archiving and Retention in PostgreSQL: Best Practices for Large Datasets.” This post is a written version of my talk for those who couldn’t attend.
Below, you’ll find each slide from the talk — along with what was said.
Andrew Atkinson: Short alphanumeric pseudo random identifiers in Postgres
In this post, we’ll cover a way to generate short, alphanumeric, pseudo random identifiers using native Postgres tactics.
These identifiers can be used for things like transactions or reservations, where users need to read and share them easily. This approach is an alternative to using long, random generated values like UUID values, which have downsides for usability and performance.
David Wheeler: Auto-Release PostgreSQL Extensions on PGXN
I last wrote about auto-releasing PostgreSQL extensions on PGXN back in 2020, but I thought it worthwhile, following my Postgres Extensions Day talk last week, to return again to the basics.
Esther Minano: pgstream v0.5.0 update
Pavlo Golub: Welcome new GSoC 2025 contributors!
I’m pleased to welcome seven new Google Summer of Code 2025 contributors to the Postgres community!
I encourage you to welcome contributors during these first weeks to get them excited and invested in our community. You will meet them on mailing lists, Slack, Discord, and other media.
The table below details information about this year’s project, contributors, and mentors!