4 ms·

One nice thing about the CTE inlining its that materialised CTEs were stopping parallelism from being used. WITH is useful in big OLAP queries, where paralleli

One nice thing about the CTE inlining its that materialised CTEs were stopping parallelism from being used. WITH is useful in big OLAP queries, where parallelisms should really help.

megous 7y ago
OTOH, it slowed down one of my queries from a few ms to 3s just by upgrading. So it's not some magic absolute benefit. I had to go and add "materialized" to a few places.
- jeltz 7y ago
  Yeah, if the planner estimates are bad the inlining can produce a worse query plan.