DuckDB has recently switched to a push-based execution model from the initial pull-based execution model. In this talk we will discuss how the new push-based model operates, the reasons that inspired this switch, as well as the various trade-offs between the two models.
Mark Raasveldt is a co-founder of DuckDB Labs and a postdoc at the CWI Database Architectures group.