3 ms·
I've found CTEs to be one of the few ways to reliably force Postgres evaluation order, which is sometimes quite poor (I have specific queries that run 100x fast
by barrkel 7y ago
I've found CTEs to be one of the few ways to reliably force Postgres evaluation order, which is sometimes quite poor (I have specific queries that run 100x faster with CTE), so retaining old behaviour with materialized is something I didn't know about in 12.
- jeltz 7y agoHow this should be done was the big roadblock, the actual inlining was a relatively simple patch.