Programming, Sql, Postgresql, Performance, Data Engineering.
can be broken down to isolate bottlenecks Not all optimizations are reductive in nature Using EXIST where possible can provide drastic perf gains We went from a query time of ~24 mins to 2 seconds, an extremely dramatic performance improvement! While this blog post is long, all of the experiments