PGConf NYC 2021 - Understanding and Reducing Application Contention by Simon Riggs

Understanding and Reducing Application Contention by Simon Riggs Database Lock Waits, Deadlocks and Serializable ERRORs lurk in wait for the unwary application developer. This talk explains what they are, how to spot they are causing problems and how to reduce them. With both simple and realistic examples. Rather worryingly, some of these effects only show themselves when doing high transaction rates, so we discuss coping and testing mechanisms. These issues apply to all users of PostgreSQL and related databases, no matter whether they are using JSON or not, nor whether they use single node or distributed databases.