> 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.ucid && u.subscriptions` doesn't appear to work in my case since the comparison is `text && text[]`. Something like: ``` explain (analyze, buffers) select cv.* from channel_videos cv inner join (select subscriptions from users where email = $1) as u on array[cv.ucid] && u.subscriptions; ``` does work but unfortunately doesn't appear to be faster than the current query. Cheers
