Y
Hacker News
new
|
ask
|
show
|
jobs
by
zomgwat
1068 days ago
As of PostgreSQL 12, whether the optimization fence is used or not is controlled with MATERIALIZED and NOT MATERIALIZED.
1 comments
srcreigh
1068 days ago
By default it’s an optimization fence if a CTE is referenced 2+ times, and not an optimization fence if referenced 0-1 times. The MATERIALIZED and NOT MATERIALIZED overrides the default.
link