Neues vom PostgreSQL Planet

Always good to be back in Brussels, and this year was a bit special. 25 years of FOSDEM, and they even ordered 2 days of sunshine for the entire weekend. I’m impressed! The green field outside the K building, in glaring sunshine In good tradition, PostgreSQL Europe organized a PGDay on Friday before FOSDEM. And we had a stand at the main FOSDEM event, and a Devroom on Sunday.

CommitFest 52 (2025-03), the final CommitFest in the PostgreSQL 18 development cycle, kicked off this week.

On Thursday, Feb 13th, the PostgreSQL Global Development Group (PGDG) released their regularly scheduled minor releases of PostgreSQL: 17.3, 16.7, 15.11, 14.16, and 13.19. These releases, among other bugfixes, resolved a CVE within PostgreSQL, so a sense of urgency in releasing them to our customers was bred.

On 21st of February 2025, Robert Haas committed patch: Allow EXPLAIN to indicate fractional rows.   When nloops > 1, we now display two digits after the decimal point, rather than none. This is important because what we print is actually planstate->instrument->ntuples / nloops, and sometimes what you want to know is planstate->instrument->ntuples.

• Gulcin Yildirim Jelinek organized the Prague PostgreSQL Meetup, February Edition. Belma Canik and Pavlo Golub spoke. Slides are available here.

On 7th of February 2025, Peter Eisentraut committed patch: Virtual generated columns   This adds a new variant of generated columns that are computed on read (like a view, unlike the existing stored generated columns, which are computed on write, like a materialized view).   The syntax for the column definition is   ... GENERATED … Continue reading "Waiting for PostgreSQL 18 – Virtual generated columns"

The schedule for this year's edition of the conference is now published, You can find it here and it is also linked in the menu above. As many of you suggested to extend the conference to two days we have a second day full of amazing talks this year.

A big thank you goes to the Program Committee, they've spend quite some of their free time for putting together this great schedule.

The schedule for this year's edition of the conference is now published, You can find it here and it is also linked in the menu above. As many of you suggested to extend the conference to two days we have a second day full of amazing talks this year.

A big thank you goes to the Program Committee, they've spend quite some of their free time for putting together this great schedule.

We are thrilled to announce that PostgreSQL has been selected as one of the 185 open-source projects participating in the 21st year of Google Summer of Code (GSoC)! This is an exciting opportunity for us to collaborate with new contributors and continue enhancing the PostgreSQL ecosystem.

Join Us as a GSoC Contributor

If you’re passionate about open-source development and eager to work on PostgreSQL projects, here’s how you can get involved:

 

I compiled and uploaded zip files plpgsql_check for PostgreSQL 16 and PostgreSQL 17 - I used Microsoft Visual C 2022.

Setup:

Postgres Extensions Day 2025 Montreal: Registration and Call for Speakers

On May 12th, 2025, Postgres Extension Developers Coalition (PGEDC) will host [Po...

pgsql_tweaks is a bundle of functions and views for PostgreSQL

The source code is available on GitLab, a mirror is hosted on GitHub.
One could install the whole package, or just copy what is needed from the source code.

The extension is also available on PGXN.

pgDay Paris 2025 is less than a month away, and we have an amazing line-up of speakers on a variety of topics, both technical and community-minded.

But the best news is that there’s still a chance for you to be on stage - without committing to a full talk! Lightning talks are a great way to get speaking experience and tease audiences with a little bit of information on a great PostgreSQL subject of your choice. There's a slot dedicated to Lightning Talks at pgDay Paris 2025, and we hope you'll take part.

It's been quite a week in the PostgreSQL world, with a bunch of PostgreSQL 18 changes being committed, and an out-of-cycle minor version release following hot on the heels of last  week's scheduled updates to address a security issue.

I first blogged about Transparent Data Encryption (TDE) in 2019, which was more thoroughly analyzed in a blog post in 2023. An email exchange in December 2024 summarized the most up-to-date status of this feature:

PGConf.de 2025 is the next iteration of the PostgreSQL Conference Germany. It takes place in the "Berlin Marriott Hotel" in Berlin.

https://2025.pgconf.de/

The conference will take place on May 08th & 09th, 2025.

Registration for the conference is open. The talks will be in German or English. Tickets must be purchased online.

This month, I'm excited to tell you about the returning of the PostgreSQL Hacking Workshop along with a new Patch Review Workshop organized by Paul Ramsey.Read more »

On 14th of February 2025, Nathan Bossart committed patch: Add delay time to VACUUM/ANALYZE (VERBOSE) and autovacuum logs.   Commit bb8dff9995 added this information to the pg_stat_progress_vacuum and pg_stat_progress_analyze system views. This commit adds the same information to the output of VACUUM and ANALYZE with the VERBOSE option and to the autovacuum logs.

pgsql_tweaks is a bundle of functions and views for PostgreSQL

The soucre code is available on GitLab, a mirror is hosted on GitHub.
One could install the whole package, or just copy what is needed from the source code.

The extension is also available on PGXN.