Neues vom PostgreSQL Planet

In October 2025, PostgreSQL Conference Europe brought the community together in Riga, Latvia from the 21st to the 24th.

Organizers

• Andreas Scherbaum
• Chris Ellis
• Dave Page
• Ilya Kosmodemiansky
• Jimmy Angelakos
• Karen Jex
• Magnus Hagander
• Marc Linster
• Samed Yildirim
• Valeria Kaplan

Talk selection committee

• Karen Jex (non voting chair)

Application Developer and Community Subcommittee

My first thought seeing a temporal join in 2008 was, “Why is this query so complex?” The company I was at relied heavily on database queries, as it was a CRM and student success tracking system for colleges and universities. The query returned a filtered list of users and their last associated record from a second table. The hard part about the query isn’t returning the last timestamp or even performing joins, it’s returning only their last associated record from a second table.