Re: Optimizing `WHERE x IN` query
Did you create a GIN index on subscriptions column to support the && operator?
Re: Optimizing `WHERE x IN` query
> We had big performance issues with queries like that, and we modified > them to use && (see > https://www.postgresql.org/docs/current/functions-array.html ), > resulting in a big perf boost Much appreciated! Unfortunately I'm having trouble turning your suggestions into a working query. `cv