Re: NOT LIKE much faster than LIKE?

Поиск
Список
Период
Сортировка
От Andrea Arcangeli
Тема Re: NOT LIKE much faster than LIKE?
Дата
Msg-id 20060111091841.GA15897@opteron.random
обсуждение исходный текст
Ответ на Re: NOT LIKE much faster than LIKE?  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-performance
On Wed, Jan 11, 2006 at 09:07:45AM +0000, Simon Riggs wrote:
> I would suggest we do this only when all of these are true
> - when accessing more than one table, so the selectivity could effect a
> join result

FWIW my problem only happens if I join: on the main table where the
kernel_version string is stored (without joins), everything is always
blazing fast. So this requirement certainly sounds fine to me.

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: NOT LIKE much faster than LIKE?
Следующее
От: Alessandro Baretta
Дата:
Сообщение: Re: 500x speed-down: Wrong statistics!