Ants Aasma
Ants has been using PostgreSQL for 2 decades, and has been a consultant and developer of PostgreSQL at Cybertec since 2012. He has contributed to a few features of PostgreSQL core, to Patroni and various other tools here and there. His main areas of focus are performance, reliability and observability.
Cybertec
Přednáška
Some transaction processing workloads end up with horrible lock contention because they end up blocked on updating the same rows. There are now databases that advertise running this workload a 1000 times faster than PostgreSQL. In this talk will discuss strategies how to manage this contention in PostgreSQL while retaining application correctness. How network latencies, different isolation levels, optimistic and pessimistic concurrency control, deadlocks and livelocks affect the capability to get work done. Working with the database allows us to take a large step closer to single-purpose database performance while staying in our familiar PostgreSQL land.