Re: [PERFORM] Estimation problem with a LIKE clause containing a /

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PERFORM] Estimation problem with a LIKE clause containing a /
Дата
Msg-id 11342.1194626025@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PERFORM] Estimation problem with a LIKE clause containing a /  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: [PERFORM] Estimation problem with a LIKE clause containing a /  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Re: [PERFORM] Estimation problem with a LIKE clause containing a /  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Список pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> Could we not use the bogus range to calculate the histogram estimate
> but apply the LIKE pattern directly to the most-frequent-values
> instead of applying the bogus range? Or would that be too much code
> re-organization for now?

We have already done that for quite some time.  It won't help
Guillaume's case anyhow: he's got no MCVs, presumably because the field
is unique.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: New tzdata available
Следующее
От: "Guillaume Smet"
Дата:
Сообщение: Re: [PERFORM] Estimation problem with a LIKE clause containing a /