Sign in to confirm you’re not a bot
This helps protect our community. Learn more

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

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
41K views 2 years ago #PostgreSQL #Performance #CitusCon
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,   / cituscon   #CitusCon #PostgreSQL #Performance ...more
...more
PostgreSQL performance tips you have never seen before | Citus Con: An Event for Postgres 2023
1.3KLikes
41,840Views
2023Apr 18
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,   / cituscon   #CitusCon #PostgreSQL #Performance

Follow along using the transcript.

Microsoft Developer

588K subscribers