Hands-on Query/Index Tuning In PostgreSQL
Dive into real-world index challenges, decode PostgreSQL indexes, and elevate your skills with over 20 hands-on exercises. Become a SQL wizard!
Course curriculum
-
02
-
Query Plans
-
Loading Sample Data - pg_dump + psql
-
-
03
-
Golden Rules: Important
-
-
04
-
Introduction
FREE PREVIEW -
Lesson 1: Fundamentals of Index-Only Scans
-
Lesson 2: The Role of Visibility Maps in Index-Only Scans
-
-
05
-
Overview
-
Example: Loading Most Recent Posts - Setup
-
Example: Loading Most Recent Posts - Naive Approach
-
Example: Loading Most Recent Posts - Choosing an index
-
Which Index Would You Use?
-
Example: Loading Most Recent Posts - Using the index
-