Скачать или смотреть Using Azure Query Store to Understand PostgreSQL Performance | POSETTE 2024

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.

Chapters:
00:00 - Intro
00:49 - Query Tuning Process
06:57 - Query Metrics
08:13 - Query Store
14:12 - Demo
23:35 - More to Learn

📕 Everything you need to know about POSETTE: An Event for Postgres 2024 can be found at: https://aka.ms/posette

✅ Learn more:
Watch more POSETTE talks: https://aka.ms/posette-playlist-2024

📌 Let’s connect:
X – @PosetteConf https://x.com/PosetteConf
Mastodon - @posetteconf https://mastodon.social/@posetteconf
Threads – @posetteconf https://www.threads.net/@posetteconf

🔔 Subscribe to the POSETTE News: https://aka.ms/posette-subscribe

#PosetteConf #PostgreSQL #Performance

Presenters:
Grant Fritchey, Redgate Software

Connect:
Grant Fritchey:   / gfritchey  ,   / grant-fritchey