Sammlung von Newsfeeds
Ian Barwick: PgPedia Week, 2025-06-08
Of note:
new GUC log_lock_failure renamed to log_lock_failures commit e5a3c9d9 (" postgres_fdw: Inherit the local transaction's access/deferrable modes. ") was reverted PostgreSQL 18 articles What's New in PostgreSQL 18 - a DBA's Perspective (2025-05-23) - TianzhouHans-Juergen Schoenig: Using regular expressions and arrays in PostgreSQL
Regular expressions and PostgreSQL have been a great team for many many years. The same is true for PostgreSQL arrays, which have been around for a long time as well. However, what people rarely do is combine those two technologies into something more powerful that can be used for various purposes.
Stefanie Janine: pgsql_tweaks 0.11.3 Released
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.
Andreas 'ads' Scherbaum: Teresa Lopes
Magnus Hagander: PGConf.EU 2025 - Call for Presentations
The Call for Presentations for PostgreSQL Conference Europe that will take place in Riga, Latvia from October 21 to 24 is now open.
Key dates- Submission deadline: 30 June (at midnight, local time Riga, Latvia; GMT+3)
- Speakers notified: before 1 August
- Conference: 21-24 October
To submit your proposals and for more information see our website. Speakers can submit up to three (3) proposed talks each.
Andrew Atkinson: CORE Database Schema Design: Constraint-driven, Optimized, Responsive, and Efficient
In this post, we’ll cover some database design principles and package them up into a catchy mnemonic acronym.
Software engineering is loaded with acronyms like this. For example, SOLID principles describe 5 principles, Single responsibility, Open-closed, Liskov substitution, Interface segregation and Dependency inversion, that promote good object-oriented design.
Shane Borden: Understanding High Water Mark Locking Issues in PostgreSQL Vacuums
I recently had a customer that wanted to leverage read replicas to ensure that their read queries were not going to impeded with work being done on the primary instance and also required an SLA of at worst a few seconds. Ultimately they weren’t meeting the SLA and my colleagues and I were asked to look at what was going on.
Henrietta Dombrovskaya: Just announced: PG DATA 2026
Chicago is better in summer! Our inaugural event, PG DATA 2026, will kick off 363 days from today, and we want you to be a part of it!
PG DATA’s mission is to encourage the growth of the PostgreSQL community in the Midwest through learning and networking opportunities, to foster collaboration with the developers’ community and academia, and to bring the best global Postgres speakers to our local community.
Ashutosh Bapat: Avoiding disk spills due to PostgreSQL's logical replication
Logical replication is a versatile feature offered in PostgreSQL. I have discussed the the theoretical background of this feature in detail in my POSETTE talk. At the end of the talk, I emphasize the need for monitoring logical replication setup. If you are using logical replication and have setup monitoring you will be familiar with pg_stat_replication_slots.
Gabriele Bartolini: CNPG Recipe 18 - Getting Started with pgvector on Kubernetes Using CloudNativePG
Learn how to set up a PostgreSQL cluster with the pgvector extension on Kubernetes using CloudNativePG—all in a fully declarative way. This article walks you through the process in just a few minutes, from cluster creation to extension installation.
Tomas Vondra: Benchmarking is hard, sometimes ...
I do a fair number of benchmarks, not only to validate patches, but also to find interesting (suspicious) stuff to improve. It’s an important part of my development workflow. And it’s fun ;-) But we’re dealing with complex systems (hardware, OS, DB, application), and that brings challenges. Every now and then I run into something that I don’t quite understand.
Michael Christofides: Approximate the p99 of a query with pg_stat_statements
Cover photo by Luca Upper
I recently saw a feature request for pg_stat_statements to be able to track percentile performance of queries, for example the p95 (95th percentile) or p99 (99th percentile).
Claire Giordano: Ultimate Guide to POSETTE: An Event for Postgres, 2025 edition
POSETTE: An Event for Postgres 2025 is back for its 4th year—free, virtual, and packed with deep expertise. No travel needed, just your laptop, internet, and curiosity.
This year’s 45 speakers are smart, capable Postgres practitioners—core contributors, performance experts, application developers, Azure engineers, extension maintainers—and their talks are as interesting as they are useful.
Boriss Mejias: Contributions for the week of 2025-05-19 (Week 21)
[PGDay Blumenau 2025] (https://pgdayblumenau.com.br/) took place May 24 in Blumenau, Brazil, organized by João Foltran and Gustavo Lemos, with Sara Kruger and Leonardo Corsini as volunteers.
Speakers:
Josef Machytka: Boldly Migrate to PostgreSQL – Introducing credativ-pg-migrator
Many companies these days are thinking about migrating their databases from legacy or proprietary system to PostgreSQL. The primary aim is to reduce costs, enhance capabilities, and ensure long-term sustainability. However, even just the idea of migrating to PostgreSQL can be overwhelming. Very often, knowledge about the legacy applications is limited or even lost. In some cases, vendor support is diminishing, and expert pools and community support are shrinking.
Ian Barwick: PgPedia Week, 2025-06-01
If you, like me, set up read access to the PostgreSQL Git repository many years ago, and have been wondering why it's been returning fatal: Could not read from remote repository errors for the past few days, it's because git:// protocol support has been deactivated and maybe withdrawn entirely (see pgsql-www thread git repo "https://" working but "git://" is not ).
Resolution is to convert it to https:// , e.g.:
git remote set-url origin https://git.postgresql.org/git/postgresql.git
Kaarel Moppel: Yes, Postgres can do session vars - but should you use them?
Laurenz Albe: The Fun of Open Source: Roman Numerals in PostgreSQL
© Laurenz Albe 2025
Recently, I wrote about the power of open source. Now, power is good and important, but open source software has other good sides as well. One of these aspects is fun. I will showcase that with the recently introduced support for converting Roman numerals to numbers.
Andreas 'ads' Scherbaum: Dilan Tek
Karen Jex: Postgres Partitioning Best Practices
Slides and transcript from my talk, "Postgres Partitioning Best Practices", at PyCon Italia in Bologna on 29 May 2025.
Thank you to everyone who came to listen, apologies to the people who were turned away because the room was full (who knew so many people would want to learn about Partitioning!), and thank you for all the questions, which have given me lots of ideas for improvements.
I'll share the recording as soon as it's available.