Neues vom PostgreSQL Planet
Federico Campoli: PGDay Napoli 2025
Finally I found time to get a grip on the issues I had with gohugo and get my blog operational again.
I’m taking the occasion to write about a project I care a lot as it’s strictly related with my hometown, the upcoming PGDay Napoli.
Henrietta Dombrovskaya: February Meetup: Postgres Full Text Search
Every time I host a Postgres Meetup, I am thankful to everyone who comes. But today, I am especially thankful because so many people showed up despite the snowstorm! Staying after work to attend a meetup in these weather conditions demonstrates true dedication!
Many thanks to Steve Zelaznik for his wonderful presentations (recording will be available!), and thanks to all participants for listening, asking insightful questions, and a lively discussion afterward!
Peter Eisentraut: How about trailing commas in SQL?
Anecdotally, this might be the most requested feature in SQL: Allow some trailing commas.
The classic example is
SELECT a, b, c, -- here FROM ...Another one is
CREATE TABLE tab1 ( a int, b int, c int, -- here )There might be a few other popular ones. (Please send feedback.)
Laurenz Albe: Dealing with the PostgreSQL error "found xmin ... from before relfrozenxid ..."
I have seen the error from the title reported often enough. If you are not familiar with the internals of PostgreSQL, the message will confuse you: what are xmin and relfrozenxid? Why is it a problem if one is before the other? So I think that it is worth the effort to write an article about the problem and what the error means. I'll also show you how to cope with the situation and fix the error.
Regina Obe: Learning PostgreSQL from AI and JSON exploration
After reading Paul's teasing article on Accessing Large Language Models with AI and testing out his code, I decided I should probably stop fighting this AI smothering. I still have a distrust of AI services but downloading an AI model and using on my own local desktop or server is nice and I can break bread with that. One use I tried is using AI to generate fake data and it did a pretty decent job.
Paul Ramsey: The Early History of Spatial Databases and PostGIS
For PostGIS Day this year I researched a little into one of my favourite topics, the history of relational databases. I feel like in general we do not pay a lot of attention to history in software development. To quote Yoda, “All his life has he looked away… to the future, to the horizon. Never his mind on where he was. Hmm? What he was doing.”
Brian Pace: Postgres Parallel Query Troubleshooting
Postgres' ability to execute queries in parallel is a powerful feature that can significantly improve query performance, especially on large datasets. However, like all resources, parallel workers are finite. When there aren't enough available workers, Postgres may downgrade a parallel query to a serial (non-parallel) execution. This sounds reasonable unless the performance of the downgraded query is well beyond the required response times needed by the application.
Andrew Farries: pgroll 0.9.0 update
Floor Drees: Contributions for the week of 2025-02-03 (Week 5 overview)
Organizing Committee FOSDEM PGDay and the PostgreSQL dev room at FOSDEM:
Andreas Scherbaum: PostgreSQL Berlin February 2025 Meetup
Ian Barwick: PgPedia Week, 2025-02-09
Shayon Mukherjee: Scaling with PostgreSQL without boiling the ocean
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 18 – Support RN (roman-numeral format) in to_number().
Radim Marek: VIEW inlining in PostgreSQL
Database VIEWs are powerful tools that often don't get the attention they deserve when building database-driven applications. They make our database work easier in several ways:
Ryan Booz: On Writing a Book About PostgreSQL
Paul Ramsey: Using Cloud Rasters with PostGIS
With the postgis_raster extension, it is possible to access gigabytes of raster data from the cloud, without ever downloading the data.
How? The venerable postgis_raster extension (released 13 years ago) already has the critical core support built-in!
Pavlo Golub: FOSDEM 2025. A PostgreSQL Community Tradition
FOSDEM has long been a key event for the PostgreSQL community, and 2025 was no exception. Every year, PostgreSQL developers, contributors, and users worldwide gather in Brussels for a week packed with talks, meetings, and discussions. Our community has a strong tradition at FOSDEM, with a dedicated developer room, a booth, and numerous side events
Naisila Puka: Distribute PostgreSQL 17 with Citus 13
The Citus 13.0 release is out and includes PostgreSQL 17.2 support! We know you’ve been waiting, and we’ve been hard at work adding features we believe will take your experience to the next level, focusing on bringing the Postgres 17 exciting improvements to you at distributed scale.
Sergey Solovev: PostgreSQL planner development and debugging
This is translation of my report "Debugging PostgreSQL planner" from PGBootCamp 2024 conference.
You can find repository with source code and another staff here.
In this post we will look at how the PostgreSQL planner works, but on code level (functions and data structures) and how to hack on it's planner.
Stefanie Janine: Recap of FOSDEM and FOSDEM PGDay 2025
For several years there is a PGDay in Brussels on the Friday before FOSDEM organized by PostgreSQL Europe.
The talks that I attended have been good. Only that it the speakers have not been very diverse.