Programming, Sql, Postgresql, Performance, Data Engineering.
"http://google.com/", "http://wingify.com/" }. I started googling for a way to do set-intersection in Postgres without using the && and it wasn't going anywhere. In the end, we decided to simply solve the problem in isolation: Get me all the urls rows for which the url matches the pattern. Given