We Built a Production, Slack-Native Agent and Open-Sourced Ittigerdata.com1 ポイント·投稿者 jpruittsql·9 か月前·0 コメント
jpruittsql·5 年前·議論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. (Timescale Engineer)