September 25, 2025: PostgreSQL 18 Released!

Feature Description

Hash aggregation can use disk

The query planner can now consider using hash aggregation if it expects the aggregate to exceed working memory.

This can be controlled by two configuration parameters: