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

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

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
1.6K views 10 months ago #PostgreSQL #Performance #PosetteConf
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 Pos …...more
...more
PostgreSQL performance tips you have never seen before V2.0 | POSETTE 2024
64Likes
1,661Views
Jun 132024
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: 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: Hans-Jürgen Schönig, CEO of CYBERTEC Connect: Hans-Jürgen Schönig:   / postgresql_007  ,   / hans-juergen-schoenig-bbbb075  

Follow along using the transcript.

Microsoft Developer

588K subscribers