"The team at DuckDB Labs has been hard at work improving the performance of the out-of-core hash aggregates and joins."

Aside from that, since April DuckDB has vastly improved performance of a number of queries, including aggregates, joins, window functions. [0]

[0] https://duckdb.org/2023/09/26/announcing-duckdb-090.html#cor...