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