Re: query plan with index having a btrim is different for strings of different length

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: query plan with index having a btrim is different for strings of different length
Дата
Msg-id 603c8f070812101139p189cc828hef8702f37f952b6d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: query plan with index having a btrim is different for strings of different length  (Richard Yen <dba@richyen.com>)
Ответы Re: query plan with index having a btrim is different for strings of different length
Список pgsql-performance
Дерево обсуждения 
> You guys are right.  I tried "Miller" and gave me the same result.  Is there
> any way to tune this so that for the common last names, the query run time
> doesn't jump from <1s to >300s?
> Thanks for the help!

Can you send the output of EXPLAIN ANALYZE for both cases?

...Robert

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: query plan with index having a btrim is different for strings of different length
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Experience with HP Smart Array P400 and SATA drives?