Re: NOT LIKE much faster than LIKE?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: NOT LIKE much faster than LIKE?
Дата
Msg-id 152.1136908013@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: NOT LIKE much faster than LIKE?  (Andrea Arcangeli <andrea@cpushare.com>)
Ответы Re: NOT LIKE much faster than LIKE?  (Andrea Arcangeli <andrea@cpushare.com>)
Список pgsql-performance
Andrea Arcangeli <andrea@cpushare.com> writes:
> There's only one preempt near the end, not sure if it would work?

Not with that data, but maybe if you increased the statistics target for
the column to 100 or so, you'd catch enough values to get reasonable
results.

            regards, tom lane

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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: NOT LIKE much faster than LIKE?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: NOT LIKE much faster than LIKE?