Seattle Postgres: Managing Transaction Metadata in PostgreSQL

Seattle Postgres: Managing Transaction Metadata in PostgreSQL

When

February 6, 2025    
6:00 pm - 8:00 pm

Where

Steam Plant - Fred Hutch Cancer Center 1241 Eastlake Ave E · Seattle, WA

Event Organizer

Seattle Postgres User Group
https://www.meetup.com/seattle-postgres/events/304931686/

Founded in 2010, the Seattle PostgreSQL Users Group (SEAPUG) gets together in person and we talk about technology and databases – especially our favorite database, Postgres! Nothing is too simple or too complicated. Come meet the people… from the newbie to expert – whether your job directly involves databases or not – all have a good time talking shop about technology over some food and drinks.

=====
Feb 6:

PostgreSQL relies on a series of specialized components to manage the state and metadata of its transactions, ensuring consistency, isolation, and durability across concurrent operations. This talk explores the internals of these components, including commit logs (CLOG), commit timestamps, subtransactions, and multi-transactions, which together form the backbone of PostgreSQL’s transaction management system. We will cover the fundamentals of how they work and recent work being done to improve upon these components in the community. Additionally, we’ll examine how these mechanisms interact with features like asynchronous notifications, highlighting the design choices that make PostgreSQL robust and scalable.

Pizza is provided, and we also have a user group lending library of books & papers related to PostgreSQL and Databases.

NEW LOCATION: same place as the summer BBQ – the Fred Hutch Steam Plant building. (Entrance on Eastlake Ave) Typically it’s not hard to find street parking nearby.

Speaker Rishu Bagga is a software engineer who has worked on open source Postgres and Amazon Aurora related Postgres projects. Rishu specifically worked on the open source efforts in Postgres to move SLRU pages into the main buffer cache and add page headers to the SLRU pages.

X