We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Beyond EXPLAIN: Query Optimization From Theory To Code

Formal Metadata

Title
Beyond EXPLAIN: Query Optimization From Theory To Code
Title of Series
Number of Parts
34
Author
License
CC Attribution 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language

Content Metadata

Subject Area
Genre
Abstract
This talk will take you to an optimizer backstage tour: from theoretical background of state-of-the-art query optimization to close look at current implementation of PostgreSQL. We also share our experiences to hack the optimizer in our laboratory. Query optimization is a cornerstone of modern database software including PostgreSQL. However its internal mechanism is not widely known to the community. The goal of this talk is to offer clear and deep knowledge of query optimization technology.