Optimizer Insights
The quality of an optimizer is crucial, as it can never be perfect, leading to occasional inefficiencies in query handling. Transitioning from proprietary databases to postgres can eliminate the need for constant monitoring of query plans, as many users discover that postgres's optimizer performs adequately without the same level of oversight. Resistance to learning new systems can hinder teams, but embracing the capabilities of postgres often reveals that previous practices, like locking plans, may not be necessary.In this clip
From this podcast
Software Engineering Radio - the podcast for professional software developers
SE-Radio Episode 328: Bruce Momjian on the Postgres Query Planner
Related Questions
What is the main topic of the clip "Optimizer Insights" from the episode SE-Radio Episode 328: Bruce Momjian on the Postgres Query Planner?
What is query optimization in the context of the episode SE-Radio Episode 328: Bruce Momjian on the Postgres Query Planner and the clips SQL Optimization Insights from the episode Designing Data-Intensive Applications – Data Models: Query Languages and the clip Declarative SQL Power?
What is the main topic of the clip "Optimizing Query Performance" from the episode SE-Radio Episode 328: Bruce Momjian on the Postgres Query Planner?