Re: Optimizing `WHERE x IN` query - Mailing list pgsql-performance

From Omar Roth
Subject Re: Optimizing `WHERE x IN` query
Date
Msg-id DM5PR18MB10510CC0FAA5E7C49F573C09DFF10@DM5PR18MB1051.namprd18.prod.outlook.com
Whole thread Raw
In response to Re: Optimizing `WHERE x IN` query  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-performance
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?





pgsql-performance by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: UUID v1 optimizations...
Next
From: Nicolas Charles
Date:
Subject: Re: Optimizing `WHERE x IN` query