Re: IN list processing performance (yet again)

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: IN list processing performance (yet again)
Дата
Msg-id 20030528184150.GB6118@wolff.to
обсуждение исходный текст
Ответ на Re: IN list processing performance (yet again)  (Dave Tenny <tenny@attbi.com>)
Ответы Re: IN list processing performance (yet again)  (Dave Tenny <tenny@attbi.com>)
Список pgsql-performance
On Wed, May 28, 2003 at 13:58:14 -0400,
  Dave Tenny <tenny@attbi.com> wrote:
> A join isn't an option, these elements come a a selection of entity ID's
> that are specific to some client context.
> Some other people suggested joins too.

You can union the values together and then join (or use where exists) with the
result. This may not be faster and you may not be able to union several
thousand selects together in a single statement. But it shouldn't be too
much work to test it out.

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: IN list processing performance (yet again)
Следующее
От: Dave Tenny
Дата:
Сообщение: Re: IN list processing performance (yet again)