MENU

Fun & Interesting

SQL IN clauses are miles faster in Postgres 17

Hussein Nasser 15,376 lượt xem 7 months ago
Video Not Working? Fix It Now

Fundamentals of Database Engineering udemy course
https://databases.win

Postgres 17 is released! and it brings amazing performance features. In this video I discuss one of those performance features specifically the BTree scan optimization with IN. So if you are using IN clauses, postgres 17 is just faster now with it.

0:00 Intro
1:00 Overview of PG 17 features
5:00 IN Clause in Postgres 16 vs Postgres 17
11:30 How SQL Server Does it
12:35 Postgres 16 IN clause performance
17:08 Postgres 17 IN clause performance


Fundamentals of Operating Systems Course
https://os.husseinnasser.com

Backend Troubleshooting Course
https://performance.husseinnasser.com


Fundamentals of Backend Engineering (link redirects to udemy with coupon)
https://backend.husseinnasser.com

Fundamentals of Networking for Effective Backends udemy course (link redirects to udemy with coupon)
https://network.husseinnasser.com

Fundamentals of Database Engineering udemy course (link redirects to udemy with coupon)
https://database.husseinnasser.com

Follow me on Medium
https://medium.com/@hnasr/membership


Introduction to NGINX (link redirects to udemy with coupon)
https://nginx.husseinnasser.com

Python on the Backend (link redirects to udemy with coupon)
https://python.husseinnasser.com

Become a Member on YouTube
https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join

Buy me a coffee if you liked this
https://www.buymeacoffee.com/hnasr

Arabic Software Engineering Channel
https://www.youtube.com/channel/UChWZsjdoRvZ0T9QWZOD6UpA

🔥 Members Only Content
https://www.youtube.com/playlist?list=UUMO_ML5xP23TOWKUcc-oAE_Eg



🏭 Backend Engineering Videos in Order
https://backend.husseinnasser.com

💾 Database Engineering Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQXjD0HOzN7P2tgzu7scWpl2

🎙️Listen to the Backend Engineering Podcast
https://husseinnasser.com/podcast

Gears and tools used on the Channel (affiliates)

🖼️ Slides and Thumbnail Design
Canva
https://partner.canva.com/c/2766475/647168/10068


Stay Awesome,
Hussein

Comment