3 ms·
This is a good point, although it’s worth noting that there are definitely cases where you want the sun table to be materialised (esp. when that table is small
by nicoburns 4y ago
This is a good point, although it’s worth noting that there are definitely cases where you want the sun table to be materialised (esp. when that table is small and referenced many times)
- dragonwriter 4y agoYeah, its definitely one of those things where it is worth reading the docs [0], and not just adopting an “always do it this way” rule of thumb. [0] https://www.postgresql.org/docs/current/queries-with.html#id-1.5.6.12.7 https://www.postgresql.org/docs/current/queries-with.html#id...
- bolanyo 4y agoIs 'sun table' a particular concept here? A typo?
- nicoburns 4y agoIt's a typo. I was trying to write 'CTE table' and iOS "helpfully" autocorrected it.