Re: Optimizing `WHERE x IN` query

Поиск
Список
Период
Сортировка
От Omar Roth
Тема Re: Optimizing `WHERE x IN` query
Дата
Msg-id DM5PR18MB10510CC0FAA5E7C49F573C09DFF10@DM5PR18MB1051.namprd18.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Optimizing `WHERE x IN` query  (Thomas Kellerer <spam_eater@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: UUID v1 optimizations...
Следующее
От: Nicolas Charles
Дата:
Сообщение: Re: Optimizing `WHERE x IN` query