SQL IN clauses are miles faster in Postgres 17 @hnasr
SQL IN clauses are miles faster in Postgres 17  @hnasr
Uploaded September 2024 | Updated November 2026, 7 hours ago
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
os.husseinnasser.com

Backend Troubleshooting Course
performance.husseinnasser.com


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

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

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

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


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

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

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

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

Arabic Software Engineering Channel
youtube.com/channel/UChWZsjdoRvZ0T9QWZOD6UpA

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



🏭 Backend Engineering Videos in Order
backend.husseinnasser.com

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

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

Gears and tools used on the Channel (affiliates)

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


Stay Awesome,
Hussein
SQL IN clauses are miles faster in Postgres 17IO uring gets Zero Copy network operationsWhy do we need virtual memoryPinterest moves to HTTP/3Why Postgres is PopularPostgres 18 Async IO methodsSequential Scans in Postgres just got faster (Postgres 17 feature)Switching Threads is FasterEncrypted TLS Client Hello | The Backend Engineering ShowThe core of backend system designFrontend and Backends TimeoutsHow Alt-Svc switches HTTP/2 clients to use HTTP/3
Hussein Nasser |

SQL IN clauses are miles faster in Postgres 17

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER