Post Content
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
? 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: https://twitter.com/HettieDombr, https://www.linkedin.com/in/henrietta-dombrovskaya-367b26/ Read More Microsoft Developer
+ There are no comments
Add yours