PostgreSQL Contributions | postgres-contrib.org

Contributions for the week of 2025-06-23 (Week 26)

PUG Stuttgart

PUG Stuttgart happened on June, 26th - hosted by Aleshkova Daria

Speakers

• Marco Klöckler about Semantics in the Cloud
• Ilya Kosmodemiansky about Operating PostgreSQL as a Data Source for Analytics Pipelines
• Sikandra Chaudhary about PostgreSQL 18: Exploring the Latest Innovations

Prague PostgreSQL Meetup

Prague PostgreSQL Meetup on June 23 organized by Gulcin Yildirim

Speakers

• Henrietta Dombrovskaya about Securing Your PostgreSQL Data: A Comprehensive Guide to Protecting Your Database Assets
• Boris Novikov about Querying Temporal Data in Postgres

Swiss PGDay 2025

Swiss PGDay 2025 took place on June 26th and 27th in Rapperswil (Switzerland)

Program committee

• Marion Baumgartner
• Johannes Graën
• Stefan Keller
• Andreas Geppert
• Michelle von Känel
• Stephan Wagner

Organization committee

• Marion Baumgartner
• Andreas Geppert
• Stephan Wagner
• Tobias Bussmann
• Stefan Keller
• Michelle von Känel
• Daniel Westermann

Speakers

• Bruce Momjian How Open Source and Democracy Drive Postgres
• Gulcin Yildirim Jelinek Anatomy of Table-Level Locks in PostgreSQL
• Laurenz Albe Mach das nicht!
• Patrick Stählin Using logical replication for fun and profit
• Aarno Aukia Operating PostgreSQL at Scale: Lessons from Hundreds of Instances in Regulated Private Clouds
• Bertrand Hartwig-Peillon pgAssistant
• Gianni Ciolli The Why and What of WAL
• Daniel Krefl Hacking pgvector for performance
• Kaarel Moppel Das 1x1 der Testdatengenerierung mit Postgres
• Franck Pachot Normalize or De-normalize? Relational SQL Columns or JSON Document Attributes?
• Andreas Geppert Tabellen vs Objekte: warum nicht einfach beides (in Postgres)?
• Devrim Gunduz Know the less known about PostgreSQL
• Dirk Krautschick Benchmarking – Eine unerwartete Reise
• Josef Machytka Building a Data Lakehouse with PostgreSQL: Dive into Formats, Tools, Techniques, and Strategies
• Matthias Grömmer Graphdatenbanken für alle – Warum PostgreSQL mit Apache AGE eine echte Alternative zu Neo4j ist
• Luigi Nardi A benchmark study on the impact of PostgreSQL server parameter tuning
• Patrick Lauer Postgres with many data: To MAXINT and beyond
• Renzo Dani From Oracle to PostgreSQL: A HARD Journey and an Open-Source Awakening
• Dominik Frey Ein Ansatz zur Optimierung von raumbezogenen Datenbankabfragen mit PostGIS
• Pavlo Golub Customizing the Wordle Game Experience with PostgreSQL
• Andrew Farries Postgres schema migrations using the expand/contract pattern
• Alessandro Cerioni Making sense of Waze traffic data with Python, TimescaleDB-PostGIS and JavaScript
• Grant Fritchey Query Performance Monitoring For The Absolute Beginner

Lightning Talks

• Josef Machytka, Boldly Migrate to PostgreSQL with credativ-pg-migrator
• Pavlo Golub, Kudos for the rest of us
• Audrius Meškauskas, Efficient Web Development with SeaORM and PostgreSQL.
• Franck Pachot, NULL is unknown (yet)
• Raphael Debinski, pgstat_snap – a (very) poor man’s ASH for PostgreSQL
• Luigi Nardi, ML for Systems and Systems for ML
• Johannes Graën, Travel Romania efficiently - Graph search with CTEs
• Michael Hegyi, PG patching with GitLab pipelines
• Marlene Retterer, Postgres and Web3
• Kaarel Moppel, Postgres on spot VMs?
• Laurenz Albe, The tower of Babel

New Book

Jimmy Angelakos released a book: PostgreSQL Mistakes and How to Avoid Them!

DATEV Database-Day

Hans-Jürgen Schönig held a talk at DATEV Database-Day about Speicher- und Connection Management in PostgreSQL