Andrew has more than 10 years of experience building database tools with a particular focus on databases in cloud native and SaaS environments. He currently works at Xata helping to build the next generation Postgres data platform. At Xata Andrew has a particular focus on building tools to help users achieve zero-downtime database migrations.

Presentations

22x

Anatomy of Table-Level Locks in PostgreSQL

Understanding table-level locks in Postgres is a quite useful skill as almost all DDL operations require acquiring one of the different types of table-level locks on the object being manipulated. If not managed well, schema changes can result in downtime. In this talk we will explain fundamentals of table-level locking, covering how different types of locks are applied and queued during schema changes. Attendees will learn how to identify and manage lock conflicts to minimize downtime, avoid deadlocks, and maintain smooth database operations, even during high-concurrency schema changes.

See Presentation