Go offline with the Player FM app!
102: Postgres Performance Tuning and Query Planner with Bruce Momjian
Manage episode 214305912 series 2410493
In this weeks episode we are very lucky to be joined by Bruce Momjian to discuss Postgres Performance Tuning and Query Planner. We start off discussion around how Bruce got interested in Database Systems, a brief history of Postgres and his involvement with the project over the years. Following this we highlight the three main areas which affect database performance - hardware, server configuration and SQL/indexing. With this knowledge in hand, we then delve into the Query Planner, demystifying some of the terminology and concepts used (i.e. cost, scan methods and join methods). Finally, we summarise how these concepts are used by Postgres to decide which query plan to pick for a supplied query.
Show Links
- Bruce Momjian
- tnm/shql: shell sql
- SHQL
- PostgreSQL Performance Tuning - Bruce Momjian
- Database Hardware Selection Guidelines - Bruce Momjian
- dalibo/pgbadger: a fast PostgreSQL Log Analyzer
- pg_stat_statements
- PostgreSQL - Reliability
- Building Microservices
- Replication, Clustering, and Connection Pooling - PostgreSQL wiki
- PostgreSQL - How the Planner Uses Statistics
- pg_stats
- Explaining the Postgres Query Optimizer - Bruce Momjian
- Explaining the Postgres Query Optimizer Slides - Bruce Momjian
- PostgreSQL - Routine Vacuuming
- Non-Relational Postgres - Bruce Momjian
164 episodes
Manage episode 214305912 series 2410493
In this weeks episode we are very lucky to be joined by Bruce Momjian to discuss Postgres Performance Tuning and Query Planner. We start off discussion around how Bruce got interested in Database Systems, a brief history of Postgres and his involvement with the project over the years. Following this we highlight the three main areas which affect database performance - hardware, server configuration and SQL/indexing. With this knowledge in hand, we then delve into the Query Planner, demystifying some of the terminology and concepts used (i.e. cost, scan methods and join methods). Finally, we summarise how these concepts are used by Postgres to decide which query plan to pick for a supplied query.
Show Links
- Bruce Momjian
- tnm/shql: shell sql
- SHQL
- PostgreSQL Performance Tuning - Bruce Momjian
- Database Hardware Selection Guidelines - Bruce Momjian
- dalibo/pgbadger: a fast PostgreSQL Log Analyzer
- pg_stat_statements
- PostgreSQL - Reliability
- Building Microservices
- Replication, Clustering, and Connection Pooling - PostgreSQL wiki
- PostgreSQL - How the Planner Uses Statistics
- pg_stats
- Explaining the Postgres Query Optimizer - Bruce Momjian
- Explaining the Postgres Query Optimizer Slides - Bruce Momjian
- PostgreSQL - Routine Vacuuming
- Non-Relational Postgres - Bruce Momjian
164 episodes
All episodes
×Welcome to Player FM!
Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.