↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Feature: 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: