Programming, Sql, Postgresql, Performance, Data Engineering.
The JOINs are quite fast. Narrowing down the Suspects I was ready to start tweaking the query to achieve any possible perf gains possible. My team and I brainstormed 2 tactics to try out: Use EXISTS on the URLs subquery: We wanted to double check that the problem was with the URLs subquery. One way