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 can be found at: https://aka.ms/cituscon

📌 Let’s connect:  

Twitter – @CitusCon, https://twitter.com/CitusCon

#CitusCon #PostgreSQL #Performance