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.
Re: empty string causes planner to avoid index. Makes me sad. Re: empty string causes planner to avoid index. Makes me sad. |
| Список | 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 по дате отправления: