News for hackers. Stuff that matters.

A comment on PostgreSQL 12. Parent comment

Re:PostgreSQL 12 by darksaints on Thursday October 03, 2019 @12:16PM (#21148669)
> 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.

[ Parent | on HN ]
Re:PostgreSQL 12 by tyfon on Thursday October 03, 2019 @03:26PM (#21151020)
What 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 :)

[ Parent | on HN ]
Re:PostgreSQL 12 by darksaints on Thursday October 03, 2019 @03:40PM (#21151196)
Oracle does, as well as MySQL. I thought MSSQL did as well, but I guess not...never really used it though.
[ Parent | on HN ]