Episode
PostgreSQL performance tips you have never seen before V2.0
with Hans-Jürgen Schönig
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 talks adds many tricks to what has been presented in past years.
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
Recommended resources
Related episodes
Connect
- Twitter/X – @PosetteConf
- Mastodon - @posetteconf
- Threads – @posetteconf
- Subscribe to the POSETTE News
- Hans-Jürgen Schönig | Twitter/X: @postgresql_007 | LinkedIn: /in/hans-juergen-schoenig-bbbb075/
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 talks adds many tricks to what has been presented in past years.
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
Recommended resources
Related episodes
Connect
- Twitter/X – @PosetteConf
- Mastodon - @posetteconf
- Threads – @posetteconf
- Subscribe to the POSETTE News
- Hans-Jürgen Schönig | Twitter/X: @postgresql_007 | LinkedIn: /in/hans-juergen-schoenig-bbbb075/
Have feedback? Submit an issue here.