Neues vom PostgreSQL Planet
Ernst-Georg Schmid: TRAKTOR 2 is out!
Check TRAKTOR 2 - less complicated, more stable, cloud ready! Compatible with PostgreSQL 16 and 17.
Cornelia Biacsics: Contributions for the weeks 16 & 17 (2025)
Stacey Haysler created a document which lists all the available volunteer options for the PostgreSQL project.
Luigi Nardi organized the Malmö PostgreSQL Meetup. Tomas Vondra presented.
Kaarel Moppel: Striping Postgres data volumes - a free lunch?
Ernst-Georg Schmid: TRAKTOR revisited
Working on TRAKTOR again. The good news is, it still works with PostgreSQL 17.x and I have completely replaced psycopg2 with pg8000 to remove all native dependencies. The bad news is, if you don't want to run the arbiter as superuser it's a complicated dance of permissions, some of which can only be GRANTed by a superuser, and I have to find a way to automate this as far as possible.
Andrei Lepikhov: On expressions' reordering in Postgres
Today, I would like to discuss additional techniques to speed up query execution. Specifically, I will focus on rearranging conditions in filter expressions, JOINs, HAVING clauses, and similar constructs. The main idea is that if you encounter a negative result in one condition within a series of expressions connected by the AND operator, or a positive result in one of the conditions linked by the OR operator, you can avoid evaluating the remaining conditions. This can save computing resources.
Ibrar Ahmed: 8 Steps to Proactively Handle PostgreSQL Database Disaster Recovery
When disaster strikes, whether a natural disaster or a technical event, its impact on your network, database, and end-users can cause both costly downtime and data corruption. Data corruption, whether sparked by hardware failures like dying disks or faulty RAM, software glitches such as operating system bugs, or human missteps like accidental overwrites, is a terrifying prospect for any administrator. Yet, it’s not a death sentence.Your PostgreSQL database is typically a dependable cornerstone of your operations.
Laurenz Albe: Type alignment and padding bytes: how to not waste space in PostgreSQL tables
© Laurenz Albe 2025
Saving storage space should not be your first objective in a PostgreSQL database. Very often, the desire to conserve space aggressively comes at the expense of performance. But there is also no reason to needlessly waste space. Therefore, it is a good idea to be familiar with the concepts of data type alignment and padding bytes in PostgreSQL.
Ian Barwick: PgPedia Week, 2025-04-20
With all five CommitFests over, we're now into the testing and bugfix phase, and no new features are likely to be added. Having said that, there have been a few tweaks to SQL function performance and handling this week.
Floor Drees: Contributions for the week of 2025-04-14 (Week 15)
April 9 Christoph Berg spoke at the Postgres Extensions Ecosystem Mini-Summit #3 (slides, recording, transcript), a series of virtual events leading up to the gathering at PGConf.Dev.
Floor Drees: Contributions for the week of 2025-04-07 (Week 14)
April 2nd the Talking Postgres podcast airs live, with Claire Giordano as the host, Bruce Momjian as the guest, and Aaron Wislang as its producer.
Henrietta Dombrovskaya kicked off Prairie Postgres, with help from Pat Wright, Dian Fay and Anna Bailliekova.
Floor Drees: Contributions for the week of 2025-03-31 (Week 13)
Gülçin Yıldırım Jelínek organized the [Prague PostgreSQL Meetup, March Edition on March 31st]((https://www.meetup.com/prague-postgresql-meetup/events/306440481). Mayuresh B and Tomáš Vondra presented sessions.
Floor Drees: Contributions for the week of 2025-03-24 (Week 12)
Nordic PGDay (March 18) was organized by Daniel Gustafsson, Magnus Hagander, Georgios Kokolatos.
The following speakers contributed with a talk:
Floor Drees: Contributions for the week of 2025-03-17 (Week 11)
PostgreSQL Person of the week: Emma Saroyan
... Thanks Andreas Scherbaum, for publishing these interviews since - checks notes - February 2020!
Pavel Stehule: Article about PostgreSQL 18
I wrote an article about PostgreSQL 18. It is in Czech language, but translators from Czech to English, German, ... works relatively well today.
https://www.root.cz/clanky/postgresql-18-tricet-let-otevreneho-vyvoje-databaze/
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 18 – Add modern SHA-2 based password hashes to pgcrypto.
David Wheeler: Fix Postgres <code>strchrnul</code> Compile Error on macOS 15.4
Just a quick note to users of pgenv and anyone else who compiles Postgres on macOS. In macOS 15.4, Apple introduced a new API, strchrnul, which is common from other platforms. As a result attempting to compile Postgres on 15.4 and later will lead to this error:
Louise Grandjonc: Hacking the Postgres Statistics Tables for Faster Queries
Postgres does a great job of making queries really efficient. By gathering data in internal statistics tables, Postgres estimates before a query is run lots of things - like will an index scan be better than a sequential scan. How to pull data for the WHERE statement.
Bruce Momjian: New User Management Presentation Online
I wrote User, User, Who Is the User? in January of 2024, but didn't publish the slides at that time. I was planning to publish them once I delivered the presentation, but it has been a year and I have still not deivered the talk, so I am now publishing the slides.