↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Configuration Parameters

enable_distinct_reordering

Enables or disables the query planner's ability to reorder DISTINCT keys to match the input path's pathkeys. The default is on.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

boot val
on
category
Query Tuning / Planner Method Configuration
context
user
documented
true
enumvals
Unknown
extra desc
Unknown
lang
en
max val
Unknown
metadata version
18
min val
Unknown
name
enable_distinct_reordering
short desc
Enables reordering of DISTINCT keys.
source
pg-settings-source-snapshot
unit
Unknown
vartype
bool

Definition PG 18

Enables or disables the query planner's ability to reorder DISTINCT keys to match the input path's pathkeys. The default is on.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:c11f31a27ca31df48e3eb9092846fdc3c99d42ed83a3624383bb9d7ae1609fd3

Text language: en · wiki-repair-20261023:c11f31a27ca31df48e3eb9092846fdc3c99d42ed83a3624383bb9d7ae1609fd3