can't seem to use index
От | admin |
---|---|
Тема | can't seem to use index |
Дата | |
Msg-id | Pine.BSF.4.10.10001092237130.50154-100000@server.b0x.com обсуждение исходный текст |
Ответы |
Re: [GENERAL] can't seem to use index
Re: [GENERAL] can't seem to use index Re: [GENERAL] can't seem to use index Re: can't seem to use index |
Список | pgsql-general |
I'm trying to use an index on a varchar(32) field, but explain keeps retuning a sequential scan. This is my table and index: CREATE TABLE manufacturer ( id int2, name varchar(32) ); CREATE INDEX manu_name_idx ON "manufacturer" using btree ( "name" "text_ops" ); Both my table and index have been created successfully, and the database has been vacuumed. Then I run the following query from the psql command-line: explain select * from manufacturer where name='3COM'; ... and I get a sequential scan! What gives? Any suggestions would be greatly appreciated, Marc
В списке pgsql-general по дате отправления: