Congratulations

Improving Query Performance in PostgreSQL

Amy McCarty

Instructor

Chapter 1: ways to combine data

Wordcloud of JOIN, WITH, TEMP, SQL, CTE, FULL, INNER, OUTER, LEFT, RIGHT, subquery, queries, postgres, optimize

Chapter 2: limiting the results

Order of operations
Filtering in the WHERE
Filtering with an INNER JOIN
Joining different data granularities

Chapter 3: learning the database

pg_tables and information_schema
Tables and views

Diagram of a mock table of 5 columns. Five vertical bars represent column-oriented storage. Five horizontal bars represent row-oriented storage.

Indexes and partitions

Chapter 4: using the query planner

Query Lifecycle. Box 1 is Parse where there is a bullet point for syntax check, translate SQL, follow rules. Box 2 is Plan & Optimize where there is a bullet point for use database statistics, calculate costs, choose best plan. Box 3 is Execute where there is a bullet point for follow the plan, return results.

EXPLAIN

Thank you!

Improving Query Performance in PostgreSQL