Programming, Sql, Postgresql, Performance, Data Engineering.
Initially I thought that perhaps the ‘ILIKE’ operation on all those long URLs — we have more than 1.4 million unique URLs captured for this account — might be causing the slowdown. But that isn’t the case at all! SELECT id FROM urls WHERE url ILIKE '%enterprise_customer.com/jobs%'; id -------- ...