Regex query not using index

Поиск
Список
Период
Сортировка
Искать
От
Postgres User
Тема
Regex query not using index
Дата
Msg-id
b88c3460802191932i2798352cra622e33a43af729d@mail.gmail.com
Список
Дерево обсуждения
Regex query not using index "Postgres User" <postgres.developer@gmail.com>
Re: Regex query not using index Erik Jones <erik@myemma.com>
Re: Regex query not using index "Postgres User" <postgres.developer@gmail.com>
Re: Regex query not using index Chris <dmagick@gmail.com>
Re: Regex query not using index "Postgres User" <postgres.developer@gmail.com>
Re: Regex query not using index Tom Lane <tgl@sss.pgh.pa.us>
Re: Regex query not using index "Postgres User" <postgres.developer@gmail.com>
Re: Regex query not using index "Postgres User" <postgres.developer@gmail.com>
Re: Regex query not using index Martijn van Oosterhout <kleptog@svana.org>
Re: Regex query not using index Chris <dmagick@gmail.com>
Re: Regex query not using index "Postgres User" <postgres.developer@gmail.com>
Re: Regex query not using index Tino Wildenhain <tino@wildenhain.de>
Re: Regex query not using index "Postgres User" <postgres.developer@gmail.com>
Re: Regex query not using index Tom Lane <tgl@sss.pgh.pa.us>
Re: Regex query not using index "Postgres User" <postgres.developer@gmail.com>
Re: Regex query not using index Alban Hertroys <dalroi@solfertje.student.utwente.nl>
Re: Regex query not using index "Postgres User" <postgres.developer@gmail.com>
Re: Regex query not using index Chris <dmagick@gmail.com>
I'm running a simple query on 8.2.  With this syntax, Explain indicate
that the index is scanned:
select * from eod where name = 'AA'

However, when I change the query to use simple regex:
select * from eod where name ~ 'AA'

now Explain indicates a seq scan:
Index Scan using equity_eod_symbol_idx on equity_eod  (cost=0.00..8.27
rows=1 width=149)
Index Cond: ((symbol)::text = 'AA'::text)

Is there any way to 'encourage' Postgres to hit the index when using
regex?  Do I need to create a functional index or something?
Without the index in play, I really can't use regex on any of my larger tables.
В списке pgsql-general по дате отправления
От: Geoffrey
Дата:
От: hewei
Дата:
Сообщение: How to make update rapidly?
FAQ