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 по дате отправления