Temporary Data Sets
Bruce discusses how temporary data sets are created during data processing, particularly when using common table expressions in Postgres. These intermediate results allow for more efficient operations, such as joins and aggregates, by reducing the number of rows the optimizer has to handle. He compares this concept to using variables in mathematics, highlighting the difference between scalar values and relational data sets.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