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

From the creator

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

Published 2023-04-18 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.