PostgreSQL Optimizer Methodology (Robert Haas)

preview_player
Показать описание
CMU Database Group - Vaccination Database Tech Talks (2021)
Speakers: Robert Haas (EnterpriseDB)
PostgreSQL Optimizer Methodology

June 7, 2021

Sponsors:
  1. CMU Database Group
  2. databases
  3. carnegie mellon university
Рекомендации по теме
PostgreSQL Optimizer Methodology 1:05:10

PostgreSQL Optimizer Methodology (Robert Haas)

Explaining the Postgres 0:35:22

Explaining the Postgres Query Optimizer

Robert Haas: Query 0:55:49

Robert Haas: Query Planning Gone Wrong

2012 SouthEast LinuxFest 1:05:35

2012 SouthEast LinuxFest - ODBC - Bruce Momjian - Explaining The Postgres Query Optimizer

The Elephants In 0:51:18

The Elephants In The Room: Limitations of the PostgreSQL Core Technology

Webinar Recording: How 1:07:48

Webinar Recording: How to use the Postgres query planner to debug bad plans and speed up queries

Row estimates | 0:35:09

Row estimates | Postgres.FM 025 | #PostgreSQL #Postgres podcast

Debugging the Postgres 0:51:00

Debugging the Postgres Planner

Breaking PostgreSQL at 0:31:47

Breaking PostgreSQL at Scale — Christophe Pettus

102 Query optimization 0:36:36

102 Query optimization | Postgres.FM 014 | #PostgreSQL #Postgres podcast

Scaling Postgres Episode 0:15:09

Scaling Postgres Episode 170 Redis vs Postgres | Hard Quadrant | Optimizing Join | Materialized View

Tracing PostgreSQL performance 0:43:46

Tracing PostgreSQL performance

Queues in PostgreSQL 0:29:30

Queues in PostgreSQL | Citus Con: An Event for Postgres 2022

Hacking the Query 0:33:06

Hacking the Query Planner, Again - Richard Guo: PGCon 2020

Optimizing autovacuum: PostgreSQL’s 0:31:37

Optimizing autovacuum: PostgreSQL’s vacuum cleaner | Citus Con: An Event for Postgres 2022

PostgreSQL In-Depth Training: 1:02:04

PostgreSQL In-Depth Training: Performance Part 2

PostgreSQL and RAM 0:43:41

PostgreSQL and RAM usage

Adventures in Postgres 0:31:37

Adventures in Postgres management: Ramanan Balakrishnan

Deep Dive into 0:42:01

Deep Dive into PostgresSQL Statistics

What's New in 1:04:34

What's New in Postgres 12

PostgreSQL Query Optimization 0:51:12

PostgreSQL Query Optimization Techniques | Databases A2Z

Wait! What's going 0:57:08

Wait! What's going on inside my database?

Viva the NoSQL 0:48:35

Viva the NoSQL Postgres - Alexande Korotkov

Postgres Pulse: X-Ray 0:31:42

Postgres Pulse: X-Ray Vision for Your PostgreSQL Queries | PgBadger

Комментарии
Автор

excellent prepared dive into difficult topics. take away: consider the costs of normalization.
thx also to andy pavlo and cmu for making this series public available.

seldasorf
Автор

IN 29:11 "where a = 1" what percentage is considered common?

jianhe
Автор

Does Andy say that the number of joins grows as 4 to the n? Isn't it slower than factorial?

Paul-fnwb
Автор

I don't know if it's just me, but Postgres looks like one of the most impenetrable codebases in the open source world. This lecture helped! Wish we could have gone deeper into the query optimizer. Thank you CMU for uploading this!

shikharraje