Programming, Sql, Postgresql, Performance, Data Engineering.
from acc_{account_id}.urls where url ILIKE '%enterprise_customer.com/jobs%' )::text[] This query is slow. Since JOINs are fast, and the subquery is fast, the only thing left is the && operator. Except, this is a crucial operation. We always need to search throughout the primary urls table to do