jpruittsql

3 ms·

1. 1.▲
   We Built a Production, Slack-Native Agent and Open-Sourced It(tigerdata.com)

   1 points by jpruittsql 11mo ago|0 comments
2. 2.▲
   by jpruittsql 5y ago

   CTEs are wonderful for readability, but until recent versions of PostgreSQL they were always "materialized" which can have performance implications vs. subqueries. The NOT MATERIALIZED option to CTEs was added in PostgreSQL 12. (T