PGCon2014 - Final Release
PGCon 2014
The PostgreSQL Conference
Speakers | |
---|---|
Bruce Momjian |
Schedule | |
---|---|
Day | Talks - Day 2 - Fri May 23 - 2014-05-23 |
Room | Monpetit 202 |
Start time | 16:15 |
Duration | 00:45 |
Info | |
ID | 668 |
Event type | Lecture |
Track | Performance |
Language used for presentation | English |
Explaining the Postgres Query Optimizer
The optimizer is the "brain" of the database, interpreting SQL queries and determining the fastest method of execution.
This talk uses the EXPLAIN command to show how the optimizer interprets queries and determines optimal execution. Examples include scan methods, index selection, join types, and how ANALYZE statistics influence their selection. The talk will assist developers and administrators in understanding how Postgres optimally executes their queries and what steps they can take to understand and perhaps improve its behavior.