Re: SQL WHERE: many sql or large IN()

Поиск
Список
Период
Сортировка
От Markus Schiltknecht
Тема Re: SQL WHERE: many sql or large IN()
Дата
Msg-id 4616791B.5000704@bluegap.ch
обсуждение исходный текст
Ответ на SQL WHERE: many sql or large IN()  (tom <tom@tacocat.net>)
Ответы Re: SQL WHERE: many sql or large IN()
Список pgsql-general
Hi,

tom wrote:
> Initially it seems that the WHERE IN (...) approach takes a turn for the
> worse when the list gets very large.

What version do you use? PostgreSQL 8.2 had great improvements for that
specific issue. Did you try EXPLAIN?

Regards

Markus


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