News for hackers. Stuff that matters.

A comment on Ways to Tweak Slow SQL Queries. Parent comment

Re:Ways to Tweak Slow SQL Queries by rosser on Sunday September 01, 2019 @10:56PM (#20856463)
Are you thinking of the "[NOT] MATERIALIZED" clause?

Yes, that's coming.

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit...

[ Parent | on HN ]
Re:Ways to Tweak Slow SQL Queries by war1025 on Sunday September 01, 2019 @11:10PM (#20856505)
Thanks for the info! I am a big fan of the readability of CTEs. Though I guess in production code we use SqlAlchemy, so it would just be a matter of swapping `.cte()` for `.subquery()` probably...
[ Parent | on HN ]