Các mẹo tối ưu hiệu suất PostgreSQL bạn chưa từng thấy trước đây 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: 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: https://twitter.com/postgresql_007, https://www.linkedin.com/in/hans-juergen-schoenig-bbbb075/