Coursera Plus Annual is 40% Off — Ends June 29.

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

SQL IN Clauses Performance Improvement in Postgres 17

Hussein Nasser via YouTube

Start learning Write review
Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More → Simplilearn Ad

Lead AI-Native Products with Microsoft's Agentic AI Program

Learn More →

Overview

AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
Explore the performance improvements in Postgres 17, focusing on the enhanced speed of SQL IN clauses. Learn about the BTree scan optimization for IN clauses and compare its performance between Postgres 16 and 17. Discover how SQL Server handles similar operations and analyze the performance differences. Gain insights into database optimization techniques and understand the impact of these improvements on query execution times. Follow along with practical demonstrations and explanations to grasp the significance of this feature in database engineering.

Syllabus

Intro
Overview of PG 17 features
IN Clause in Postgres 16 vs Postgres 17
How SQL Server Does it
Postgres 16 IN clause performance
Postgres 17 IN clause performance

Taught by

Hussein Nasser

Reviews

Start your review of SQL IN Clauses Performance Improvement in Postgres 17

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.