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

YouTube

Introduction to Postgres Query Planning

media.ccc.de via YouTube

Overview

Explore the inner workings of database query execution and optimization in this 57-minute talk focused on PostgreSQL. Delve into the representation of queries as trees, examine fundamental query optimization techniques, and gain insights into the Postgres query planner. Through practical examples, learn how the planner utilizes statistics, estimates costs, and determines execution plans. Analyze query plans, identify potential issues, and discover strategies to assist the planner in improving performance. Access accompanying slides for a comprehensive understanding of PostgreSQL query planning processes.

Syllabus

floy: Introduction to Postgres Query Planning

Taught by

media.ccc.de

Reviews

Start your review of Introduction to Postgres Query Planning

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.