How to measure query performance
Álvaro is a passionate database and software developer. Founder of OnGres, he has been dedicated to PostgreSQL and R&D in databases for more than two decades.
Álvaro is at heart an open source advocate and developer. He has created software like StackGres, a Platform for running Postgres on Kubernetes. As a well-known member of the PostgreSQL Community, Álvaro founded the non-profit Fundación PostgreSQL and the Spanish PostgreSQL User Group. He has contributed, among others, the SCRAM authentication library to the Postgres JDBC driver.
You can find him frequently speaking at PostgreSQL, database, cloud (becoming an AWS Data Hero in 2019), and Java conferences. In the last 10 years, Álvaro has completed more than 100 tech talks (https://aht.es).
No video of the event yet, sorry!
If you don’t know how to measure query performance in Postgres, this talk is for you.
If you know how to do it and consider it a simple and solved problem, this talk is definitely for you.
It doesn’t sound too complicated. There are several tools and techniques to report query performance. But a deeper look reveals some troubling conclusions:
- Some techniques may outright lie to you.
- There are disagreements between different tools/techniques.
- You can only collect some limited information.
- You may not be able to measure what really matters to database users/clients.
If you want to learn more; or maybe even unlearn something, join this talk. We will explore all the caveats and provide some key understandings into how to really measure Postgres query performance.
- 2022 April 8 15:50 PDT
- 20 min
- Santa Clara
- Silicon Valley 2022