| Type: | bool |
| Default: | on |
| Context: | user |
| Restart: | false |
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.
Recommendations
For interactive session use only when troubleshooting queries.