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

✅ Learn more:

📌 Let’s connect:

#PosetteConf #PostgreSQL #Performance

Presenters:
Hans-Jürgen Schönig, CEO of CYBERTEC

Connect: