Re: empty string causes planner to avoid index. Makes me sad.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: empty string causes planner to avoid index. Makes me sad.
Дата
Msg-id 21905.1259363431@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: empty string causes planner to avoid index. Makes me sad.  (Jeff Amiel <becauseimjeff@yahoo.com>)
Ответы Re: empty string causes planner to avoid index. Makes me sad.  (Steve Crawford <scrawford@pinpointresearch.com>)
Список pgsql-general
Дерево обсуждения 
Jeff Amiel <becauseimjeff@yahoo.com> writes:
> Ok...third try.  The cost when passing in an empty string is SIGNIFICANTLY higher than when not.

That just reflects the fact that it's expecting a lot more rows matching
that query.  I suppose this is because the statistics show you've got a
lot more rows containing the empty string than other values.

            regards, tom lane

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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: empty string causes planner to avoid index. Makes me sad.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Cannot allocate memory for output buffer