Wiki / 配置参数

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.

英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。

此版本暂无所选语言的定义，以下显示原始英文内容。

boot val

on

category

Query Tuning / Planner Method Configuration

context

user

documented

true

enumvals

未知

extra desc

Allows the query planner to build plans that provide presorted input for aggregate functions with an ORDER BY / DISTINCT clause. When disabled, implicit sorts are always performed during execution.

lang

en

max val

未知

metadata version

18

min val

未知

name

enable_presorted_aggregate

short desc

Enables the planner's ability to produce plans that provide presorted input for ORDER BY / DISTINCT aggregate functions.

source

pg-settings-source-snapshot

unit

未知

vartype

bool