PostgreSQL performance tips you have never seen before | Citus Con: An Event for Postgres 2023

Video of a conference talk about some PostgreSQL trickery which is possible but most people are not aware of, delivered at Citus Con: An Event for Postgres 2023 by Hans-Jürgen Schönig. In PostgreSQL, a lot can be done to speed up your SQL queries. However, many of the tricks are not very well known and need some more attention. Learn how to unleash a lot of hidden performance potential in PostgreSQL.

Hans-Jürgen Schönig has been a PostgreSQL professional for 20 years and helps customers around the globe to work with PostgreSQL. He has written a dozen books on PostgreSQL.

► Video bookmarks:
⏩ 00:00 Introduction
⏩ 02:25 Connecting to Postgres
⏩ 06:25 Storing data efficiently
⏩ 10:48 Considering indexes
⏩ 14:10 Composite type trickery
⏩ 17:07 Using Foreign Data Wrappers
⏩ 19:49 Full Text Indexes

✅ Learn more:
Watch more Citus Con 2023 talks: https://aka.ms/cituscon-playlist

📕 Everything you need to know about Citus Con: An Event for Postgres 2023 can be found at: https://aka.ms/cituscon

📌 Let’s connect:  
Twitter – @CitusCon, https://twitter.com/CitusCon

#CitusCon #PostgreSQL #Performance