Optimization idea for long IN() lists

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Optimization idea for long IN() lists
Дата
Msg-id 53E521D8.7090500@agliodbs.com
обсуждение исходный текст
Ответы Re: Optimization idea for long IN() lists
Список pgsql-performance
Folks,

So one thing we tell users who have chronically long IN() lists is that
they should create a temporary table and join against that instead.
Other than not having the code, is there a reason why PostgreSQL
shouldn't do something like this behind the scenes, automatically?

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


В списке pgsql-performance по дате отправления: