It was never so easy to get YouTube subscribers
Get Free YouTube Subscribers, Views and Likes

SQL IN clauses are miles faster in Postgres 17

Follow
Hussein Nasser

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'>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
  / 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
   / @hnasr  

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

Arabic Software Engineering Channel
   / @husseinnasser  

Members Only Content
   • Membersonly videos  



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

Database Engineering Videos
   • Database Engineering  

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/6...


Stay Awesome,
Hussein

posted by armuguetz0v