Using Azure Query Store to Understand PostgreSQL Performance | POSETTE 2024

From the creator

Video of a conference talk about using Azure Query Store to understand PostgreSQL performance presented by Grant Fritchey at POSETTE: An Event for Postgres 2024. Capturing query metrics in Postgres can be a challenge. This is especially true because when capturing metrics, it's not enough to simply measure a query's performance. You must have multiple data points, a before and after if you will, to ensure that you know if a query is running faster, slower, or the same. Within Azure Database for PostgreSQL, there exists an extension, that measures query behaviors, and does it in a way to provides multiple data points, Query Store. This session will demonstrate why the Query Store will make it easier for you to identify the queries that need attention. Further, the Query Store gives you tools to help you with tuning those PostgreSQL queries on Azure. You no longer need to guess at which queries are the highest priority for your query tuning. Come to this session to find out how. Grant is a Data Platform MVP and AWS Community Builder with over 30 years’ experience in IT, including time spent in support and development. Grant works with multiple data platforms including PostgreSQL and SQL Server, as well as multiple cloud platforms. He has also developed in Python, C#, and Java. Grant writes books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product advocate in January 2011. Chapt

Published 2024-06-13 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.