Understanding and Reducing Application Contention - PGConf NYC 2021
Offered By: Confreaks via YouTube
Course Description
Overview
Explore a comprehensive conference talk on understanding and mitigating application contention in PostgreSQL databases. Delve into the intricacies of database lock waits, deadlocks, and serializable errors, learning how to identify and resolve these issues. Discover practical strategies for reducing contention, including batching transactions, implementing high availability, and optimizing application design patterns. Gain insights into testing mechanisms for high transaction rates and understand the impacts of different transaction isolation levels. Compare approaches to transaction contention in various database systems, including PostgreSQL, CockroachDB, and Postgres-BDR. Equip yourself with valuable knowledge to enhance database performance and reliability in your applications.
Syllabus
Intro
How do I know waits are happening now?
How do I know lock waits happened?
Batching Transactions
High Availability
Frequency of Contention
Conversational Transactions (with Front End)
Conversational Transactions (with App Tier)
Server-side Procedures
Testing for concurrency
Deadlock detector
How do I know deadlocks happened?
Avoiding deadlocks
Application Design Anti-Patterns
Application Design Pattern Tuning (1a)
Default Transaction Isolation
Impacts of SERIALIZABLE Transaction Isolation
Impacts of SERIALIZABLE failures
Correctness of SERIALIZABLE retry
e.g. CockroachDB Problems
Postgres-BDR approaches to xact contention
CockroachDB vs PostgreSQL Performance
Taught by
Confreaks
Related Courses
Optimizing Microsoft Windows Server StorageMicrosoft via edX High Availability and Disaster Recovery with the SAP HANA Platform
SAP Learning Microsoft Exchange Server 2016 - 3: Mailbox Databases
Microsoft via edX Microsoft SharePoint 2016: Workload Optimization
Microsoft via edX Microsoft Azure Virtual Machines
Microsoft via edX