Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Tuning Parameters in Postgres vs. Tuning Your Queries | POSETTE 2024

Microsoft Developer
589K subscribers
<__slot-el>
<__slot-el>
1.5K views 10 months ago #PostgreSQL #Database #PosetteConf
Video of a conference talk about all the tuning your parameters & queries presented by Henrietta Dombrovskaya at POSETTE: An Event for Postgres 2024. When it comes to database performance tuning, most PostgreSQL practitioners focus on optimizing configuration parameters. It is often assumed that as soon as we choose the correct values for parameters and restart the database instance, all the world's problems will be solved. Indeed, due to tuning the configuration parameters, we can observe that database performance increases by 10-20% and sometimes by up to 50%. That might sound like impressive numbers, but individual query optimization routinely makes queries run several times faster, sometimes ten or more times faster. All of us might recall some examples of such drastic performance improvement, but it is not easy to quantify the impact. In this talk, we will demonstrate the difference each approach can make. We will compare the impact of tuni …...more
...more
Tuning Parameters in Postgres vs. Tuning Your Queries | POSETTE 2024
40Likes
1,577Views
Jun 132024
Video of a conference talk about all the tuning your parameters & queries presented by Henrietta Dombrovskaya at POSETTE: An Event for Postgres 2024. When it comes to database performance tuning, most PostgreSQL practitioners focus on optimizing configuration parameters. It is often assumed that as soon as we choose the correct values for parameters and restart the database instance, all the world's problems will be solved. Indeed, due to tuning the configuration parameters, we can observe that database performance increases by 10-20% and sometimes by up to 50%. That might sound like impressive numbers, but individual query optimization routinely makes queries run several times faster, sometimes ten or more times faster. All of us might recall some examples of such drastic performance improvement, but it is not easy to quantify the impact. In this talk, we will demonstrate the difference each approach can make. We will compare the impact of tuning different memory allocation parameters with the impact of creating missing indexes and, finally - with the impact of query rewrite. Hopefully, the numbers will speak for themselves. Henrietta is a database researcher and practitioner with over 40 years of academic and industrial experience. She holds a Ph.D. in Computer Science from the University of Saint Petersburg, Russia. At present she is:
  • Database Architect at DRW Holdings in Chicago, IL
  • Local Organizer of the Chicago PostgreSQL User Group
  • Active community member, a frequent speaker at the PostgreSQL Conferences
  • A researcher focused on developing efficient interactions between applications and databases and implementation of temporal data
  • An author of PostgreSQL Query Optimization book
Chapters: 00:00 Intro 01:19 Tuning your database - what does it mean? 05:28 Query example 10:03 Let's try something different! 11:55 Understanding the role of parameters 15:31 Application changes 📕 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 #Database Presenters: Henrietta Dombrovskaya, Database Architect at DRW Local organizer of Chicago PostgreSQL User Group Connect: Henrietta Dombrovskaya:   / hettiedombr  ,   / henrietta-dombrovskaya-367b26  

Follow along using the transcript.

Microsoft Developer

589K subscribers