Manage
CO.NF for your Blog
Configuration Snippet Parameter Snippet

enable_presorted_aggregate

  1. Documentation
  2. Query Tuning
  3. Planner Method Configuration
  4. enable_presorted_aggregate
COPY SHARING LINK
Type: bool
Default: on
Context: user
Restart: false
Since: 16
Enables the planner's ability to produce plans that provide presorted input for ORDER BY / DISTINCT aggregate functions

Controls if the query planner will produce a plan which will provide rows which are presorted in the order required for the query's ORDER BY / DISTINCT aggregate functions. When disabled, the query planner will produce a plan which will always require the executor to perform a sort before performing aggregation of each aggregate function containing an ORDER BY or DISTINCT clause. When enabled, the planner will try to produce a more efficient plan which provides input to the aggregate functions which is presorted in the order they require for aggregation. The default value is on.

Official docs

Search in source code

Comments