Wiki / Configuration Parameters
enable_material
Enables or disables the query planner's use of materialization. It is impossible to suppress materialization entirely, but turning this variable off prevents the planner from inserting materialize nodes except in cases where it is required for correctness. 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_material
- short desc
- Enables the planner's use of materialization.
- source
- pg-settings-source-snapshot
- unit
- Unknown
- vartype
- bool
Definition PG 18
Enables or disables the query planner's use of materialization. It is impossible to suppress materialization entirely, but turning this variable off prevents the planner from inserting materialize nodes except in cases where it is required for correctness. The default is on.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:f9b5383fd46ddf4e54d7387c30c56c9295bb491ecbff6163ee314a91e6f6e965
Text language: en · wiki-repair-20261023:f9b5383fd46ddf4e54d7387c30c56c9295bb491ecbff6163ee314a91e6f6e965