PostgreSQL performance tips you have never seen before V2.0 | POSETTE 2024

Video of a conference talk about PostgreSQL performance tips presented by Hans-Jürgen Schönig at POSETTE: An Event for Postgres 2024. Most people are aware of the standard ways to improve performance. More RAM, more CPUs, better storage and alike. However, there are many hidden tricks which can be applied to make your database faster, more efficient and more user friendly.
Welcome to secret performance tips you have never seen before. This talk adds many tricks to what has been presented last years and hopefully enjoys even more attraction
Hans-Jürgen has been in professional PostgreSQL for 20 years and helps customers around the globe to work with PostgreSQL. He has written a dozen books on PostgreSQL.
Chapters:
00:00 Intro
01:41 Goal of this talk
02:34 Creating connections
05:33 PostGIS
06:35 Storing data
15:31 Enforcing join order
20:07 Executing more efficiently
24:50 Summary
📕 Everything you need to know about POSETTE: An Event for Postgres 2024 can be found at: aka.ms/posette
✅ Learn more:
Watch more POSETTE talks: aka.ms/posette-playlist-2024
📌 Let’s connect:
X - @PosetteConf x.com/PosetteConf
Mastodon - @posetteconf mastodon.social/@posetteconf
Threads - @posetteconf www.threads.net/@posetteconf
🔔 Subscribe to the POSETTE News: aka.ms/posette-subscribe
#PosetteConf #PostgreSQL #Performance
Presenters:
Hans-Jürgen Schönig, CEO of CYBERTEC
Connect:
Hans-Jürgen Schönig: / postgresql_007 , / hans-juergen-schoenig-...