match_special_index_operator don't work in 7.2.1

Поиск
Список
Период
Сортировка
От Andriy I Pilipenko
Тема match_special_index_operator don't work in 7.2.1
Дата
Msg-id 20020519132049.L2323-100000@bamby.marka.net.ua
обсуждение исходный текст
Ответы Re: match_special_index_operator don't work in 7.2.1  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: match_special_index_operator don't work in 7.2.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Your name        :    Andriy I Pilipenko
Your email address    :    bamby@marka.net.ua


System Configuration
---------------------
  Architecture      : Intel Pentium

  Operating System     : FreeBSD 4.5-STABLE

  PostgreSQL version     : PostgreSQL-7.2.1

  Compiler used     : gcc 2.95.3



Please enter a FULL description of your problem:
------------------------------------------------

I've upgraded from 7.0.3 to 7.2.1 and noticed that queries like

SELECT ... WHERE field LIKE 'something%'

take too much time to execute now.



Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

bamby=# create table t (f varchar(100));
CREATE
bamby=# create index i_t__f on t(f);
CREATE
bamby=# SET enable_seqscan TO 'off';
SET VARIABLE
bamby=# EXPLAIN SELECT * from t where f = 'aa';
NOTICE:  QUERY PLAN:

Index Scan using i_t__f on t  (cost=0.00..17.07 rows=5 width=68)

EXPLAIN
bamby=# EXPLAIN SELECT * from t where f LIKE 'aa%';
NOTICE:  QUERY PLAN:

Seq Scan on t  (cost=100000000.00..100000022.50 rows=5 width=68)

EXPLAIN



If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

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

Предыдущее
От: "Enke, Michael"
Дата:
Сообщение: Re: [HACKERS] Bug #659: lower()/upper() bug on
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: match_special_index_operator don't work in 7.2.1