Programming, Sql, Postgresql, Performance, Data Engineering.
URLs stored for them alone. And they wanted to search for a fairly common URL pattern that relates to their business model. Preliminary Investigation Lets dive into what was happening in the database. The following was the original slow SQL query: SELECT count(*) FROM acc_{account_id}.urls as