Re: Planning large IN lists

Поиск
Список
Период
Сортировка
От Lukas Kahwe Smith
Тема Re: Planning large IN lists
Дата
Msg-id 464367A0.9010003@pooteeweet.org
обсуждение исходный текст
Ответ на Planning large IN lists  (Neil Conway <neilc@samurai.com>)
Список pgsql-hackers
Neil Conway wrote:

> Clearly, the current approach is fine when the array is small -- perhaps
> for arrays above a certain number of elements, we could switch to
> randomly sampling array elements, estimating their selectivities, and
> then using that information to infer the estimated selectivity of the
> entire array expression. That seems fairly crude, though: does anyone
> have any better ideas?

Optimizer hints in SQL
/me ducks and runs for cover.

regards,
Lukas


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

Предыдущее
От: "CK Tan"
Дата:
Сообщение: Re: Seq scans roadmap
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Planning large IN lists