How to optimize this "select count" SQL? (postgres array comparision) – Postgresql
There is a table, has 10 million records, and it has a column which type is array, it looks like: id | content | contained_special_ids ---------------------------------------- 1 | abc | { 1, 2 } 2 | abd | { 1,…