Understanding and Reducing Application Contention - PGConf NYC 2021

Understanding and Reducing Application Contention - PGConf NYC 2021

Confreaks via YouTube Direct link

Intro

1 of 22

1 of 22

Intro

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Understanding and Reducing Application Contention - PGConf NYC 2021

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Intro
  2. 2 How do I know waits are happening now?
  3. 3 How do I know lock waits happened?
  4. 4 Batching Transactions
  5. 5 High Availability
  6. 6 Frequency of Contention
  7. 7 Conversational Transactions (with Front End)
  8. 8 Conversational Transactions (with App Tier)
  9. 9 Server-side Procedures
  10. 10 Testing for concurrency
  11. 11 Deadlock detector
  12. 12 How do I know deadlocks happened?
  13. 13 Avoiding deadlocks
  14. 14 Application Design Anti-Patterns
  15. 15 Application Design Pattern Tuning (1a)
  16. 16 Default Transaction Isolation
  17. 17 Impacts of SERIALIZABLE Transaction Isolation
  18. 18 Impacts of SERIALIZABLE failures
  19. 19 Correctness of SERIALIZABLE retry
  20. 20 e.g. CockroachDB Problems
  21. 21 Postgres-BDR approaches to xact contention
  22. 22 CockroachDB vs PostgreSQL Performance

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.