Sammlung von Newsfeeds

Three events published their schedule. Here are the Program Committees behind that work. Registrations are open for these three events.

PgDay Austria

© Laurenz Albe 2025

You may have encountered the abbreviation PGDG or the long version “PostgreSQL Global Development Group” in the PostgreSQL license text, the name of installation packages and elsewhere. But have you ever stopped to think who this mysterious organization is? Have you ever wondered how one becomes a member? Then read on.

PostgreSQL Person of the Week Interview with Peter Zaitsev: I was born and raised in Moscow, Russia, graduated from Moscow State University and had my first startup there. In 2004 I moved to the US while working at MySQL AB.

 A couple weeks back, I received my speaker's gift from POSETTE: An Event for Postgres. 

I regularly update my slides to reflect improvements, corrections, and changes to Postgres. Recently I have made changes to two of my slide decks that I would like to highlight. First, my talk Postgres Scaling Opportunities is a rarely-presented deck about the ways Postgres can be scaled. One thing I always felt diminished the usefulness of that presentation was a clear explanation of why scaling databases is so complex.

The PostGIS Team is pleased to release PostGIS 3.6.0beta1! Best Served with PostgreSQL 18 Beta2 and soon to be released GEOS 3.14.

This version requires PostgreSQL 12 - 18beta2, GEOS 3.8 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.14+ is needed. To take advantage of all SFCGAL features, SFCGAL 2.2.0+ is needed.

 A couple weeks back, I received my speaker's gift from POSETTE: An Event for Postgres. 

Pgroll is an open-source, zero-downtime, reversible schema migration tool built exclusively for Postgres. We’ve reached 5k stars on GitHub!

I am very thankful to everyone who attended yesterday’s meetup! I must be completely honest: I am always pleasantly surprised when people attend our summer meetups. There are so many better things you can do in Chicago in summer!

I am especially thankful to our speaker, Robert Ismo, who delivered a very interactive presentation about AI and Postgres and kept the audience engaged. In fact, the lively discussion lasted until I had to go to catch my train and asked people to relocate to continue their discussion, so I can’t even tell how long it lasted :).

When you optimize the CPU time of a transactional database management system, it comes down to one question: how fast can you read a page without breaking consistency? In this post, we explore how OrioleDB avoids locks, trims memory copies, and — starting with beta12 — even bypasses both copying and tuple deforming altogether for fixed-length types during intra-page search. This means that not only are memory copies skipped, but the overhead of reconstructing tuples is also eliminated. The result: an even faster read path, with no manual tuning required.

I started running PostgreSQL Hacking Workshops just about one year ago, and I've run one each month, except for May, when we had pgconf.dev.

In today’s digital landscape, downtime isn’t just inconvenient, it’s costly. No matter what business you are running, an e-commerce site, a SaaS platform, or critical internal systems, your PostgreSQL database must be resilient, recoverable, and continuously available. So in short

High Availability (HA) is not a feature you enable; it’s a system you design.

Our reaction to the PostgreSQL benchmarks published by PlanetScale and the results of running them against a Xata instance.

One of our customers recently asked if they could use their Python application built with SQLAlchemy with pgEdge, and were pleased to learn that they could. But what is SQLAlchemy, and what considerations might there be when working with a distributed multi-master PostgreSQL cluster like pgEdge Distributed Postgres?SQLAlchemy is “the Python SQL Toolkit and Object Relational Mapper” according to its website.

Switching the PostgreSQL Conference Calendar Location Currently Calendar Location

So far the conference calendars in https://proopensource.it/conference-calendar/ have been stored in Google Calendar.

As that is a foreign ressource, I decided to move them away from Google.

Storing and archiving data efficiently

When it comes to designing and optimizing databases, one of the most critical aspects is the choice of storage options. PostgreSQL, like many other relational databases, provides various storage options that can significantly impact performance, data integrity, and overall database efficiency.

At this year’s PGConf.dev, the premier gathering for PostgreSQL contributors, developers, and community leaders, Zhijie Hou and I had the opportunity talk about the challenges and solutions around conflict handling in logical replication — a topic increasingly rele

Since our last public update, OrioleDB has continued to evolve with a series of new releases. These updates refine the core engine, extend functionality, and improve performance across a range of workloads. Together, they move us closer to a beta release and lay the groundwork for broader adoption.

Some weeks ago Postgres (well, not directly the official Postgres project) again managed to surprise me during my daily muscle-memory operations, prompting even one relatively lazy human to actually write about it. So while minding some other common Postgres business, I double-tapped “Tab” to complete on “pg_v”, looking for pg_verifybackup...

PostgreSQL Person of the Week Interview with Dian Fay: I live in Michigan with my partner Trent, a cat named Bread, and a tarantula named Carmilla. I’m originally from the Florida panhandle, but I moved up here for school lo these many years ago and wound up sticking around – it’s nice having seasons. My mother taught me how to type on her old Selectric when I was six or seven (my handwriting never recovered), and my father taught me BASIC when I was eight by copying code listings out of his Sky & Telescope magazines. In other words, I never stood a chance.