3 ms·
> CTEs no longer act as an optimization barrier. I've been waiting for years for this, one of my last few complaints about Postgres that some other DBs did bet
by darksaints 7y ago
> CTEs no longer act as an optimization barrier.
I've been waiting for years for this, one of my last few complaints about Postgres that some other DBs did better. It's so frustrating to have to resort to worse composability in order to get reasonable performance.
- tyfon 7y agoWhat other DB does this better? At work I constantly have to create temporary tables instead of CTEs in MS SQL server to avoid crashing the server completely. I guess Oracle maybe but I've never used that db, or DB2. But regardless of who does it better, this is very very welcome news for postgres in any case :)
- darksaints 7y agoOracle does, as well as MySQL. I thought MSSQL did as well, but I guess not...never really used it though.