Query Optimization Insights
Typical OLTP queries usually involve three to four tables, focusing on a few rows of data. However, as data analytics come into play, queries can expand to 15-20 tables, leading to significant optimization challenges. The optimizer in Postgres employs a generic query optimizer that efficiently samples plans, helping manage the complexity without excessive time spent on optimization.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 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 query optimization in the context of the episode SE-Radio Episode 328: Bruce Momjian on the Postgres Query Planner and the clip SQL Optimization Insights from the episode Designing Data-Intensive Applications – Data Models: Query Languages and the clip Declarative SQL Power?