Idées et mouvements qui comptent pour celles et ceux qui conçoivent, construisent et exploitent des logiciels—un regard bref sur l’actualité du métier.
Catégorie
On June 23 2026, the London PostgreSQL Meetup Group met. Organized by: Valeria Kaplan Chris Ellis Alastair Turner Michael Christofides Speakers: Andreas Karlsson Alastair Turner Valeria Kaplan On June 23, 2026, the Meetup PostgreSQL Lille…
PostgreSQL 13 made hash aggregation memory-safe by allowing it to spill to disk — but that safety introduced a surprise regression for some queries on upgrade.
There is a misconception I keep running into, and it causes real harm in production. People are afraid to increase checkpoint_timeout. They think a longer timeout means a longer recovery after a crash. So they set it to 5 minutes. Some set…
Learn relational algebra by building expressions that compile to real SQL.
We often hear that open source is about people. People who contribute their time and, in a way, parts of their lives to work on software that is available for everyone without limitations and without licensing costs. The more popular a…
Postgres has had native support for declarative partitions since version 10, and every release since has filed off another rough edge. We got partition-wise joins, default partitions, hash partitioning, and the ability to attach and detach…
Nearly a decade ago, I joined MongoDB as a Senior Product Manager to help build the company’s new cloud product, MongoDB Atlas. Our customers had been telling us they wanted to bring MongoDB’s familiar developer experience to the cloud,…
The Night When Things Almost Went Down Have you ever left for home on a Friday evening feeling confident about your work for the day, at peace knowing your system would survive the coming weekend? We’ve all felt that way at some point.…
In the previous post, we discussed the basic syntax of graph queries in PostgreSQL 19 and discussed some simple SQL/PGQ examples. However, more often than not applications are more complex and need more than just two basic tables.…
Reorder GROUP BY and DISTINCT keys to cut comparison costs and skip sorts—new optimizations in PostgreSQL 17 and 18 that usually stay invisible but…
