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

Поиск
Список
Период
Сортировка
От Jeff Amiel
Тема Re: empty string causes planner to avoid index. Makes me sad.
Дата
Msg-id 987026.87261.qm@web65503.mail.ac4.yahoo.com
обсуждение исходный текст
Ответ на Re: empty string causes planner to avoid index. Makes me sad.  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: empty string causes planner to avoid index. Makes me sad.  (Guillaume Lelarge <guillaume@lelarge.info>)
Re: empty string causes planner to avoid index. Makes me sad.  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: empty string causes planner to avoid index. Makes me sad.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения 
--- On Fri, 11/27/09, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> You didn't show us any evidence of that, either.  Both
> of your test
> cases are using the index.

Ok...third try.  The cost when passing in an empty string is SIGNIFICANTLY higher than when not.  Wouldn't seem that
theplanner is using the index effectively. 

Aggregate  (cost=231884.57..231884.57 rows=1 width=0)

versus

Aggregate  (cost=34.83..34.83 rows=1 width=0)


By

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

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: vacuumdb -z do a reindex?
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: empty string causes planner to avoid index. Makes me sad.