4 ms·
CTE are no longer definitive optimization barriers, as recent Postgres versions will always inline side effect free CTE.
by minxomat 6y ago
CTE are no longer definitive optimization barriers, as recent Postgres versions will always inline side effect free CTE.
- alexchamberlain 6y agoI'd totally missed that; how recent us recent?
- minxomat 6y agoI think PG12. You can force no inlining using MATERIALIZED CTE.