Re: Optimizing `WHERE x IN` query

Omar Roth <[email protected]>
Newsgroups gmane.comp.db.postgresql.performance
Message-ID <DM5PR18MB10510CC0FAA5E7C49F573C09DFF10@DM5PR18MB1051.namprd18.prod.outlook.com>
The suggested query indeed appears to be faster. Thank you.

> Did you try if a properly normalized model performs better?

I've tested the below schema, which doesn't appear to perform much better but 
has a couple other advantages for my application:

```
create table subscriptions (
    email text references users(email),
    ucid text,
    primary key (email, ucid)
);

explain (analyze, buffers) select cv.* from channel_videos cv, subscriptions s 
where cv.ucid = s.ucid and s.email = $1;

```

Is there something else here I'm missing?
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.