planner doesn't use multicolumn index

Поиск
Список
Период
Сортировка
От Adrian Demaestri
Тема planner doesn't use multicolumn index
Дата
Msg-id 20031008140859.21016.qmail@web10510.mail.yahoo.com
обсуждение исходный текст
Ответы Re: planner doesn't use multicolumn index  (Tomasz Myrta <jasiek@klaster.net>)
Re: planner doesn't use multicolumn index  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Re: planner doesn't use multicolumn index  (Manfred Koizar <mkoi-pg@aon.at>)
Список pgsql-performance
We've a table with about 8 million rows, and we need to get rows by the value of two of its fields( the type of the fields are int2 and int4, the where condition is v.g. partido=99 and partida=123). We created a multicolumn index on that fields but the planner doesn't use it, it still use a seqscan. That fields are primary key of the table and we clusterded the table based on that index, but it still doesn't work. We also set the enviroment variable enable_seqscan to false and nathing happends. The only way the planner use it is in querys that order by the expression of the index.
Any idea?
thanks.
Adrián



Do You Yahoo!?
Todo lo que quieres saber de Estados Unidos, América Latina y el resto del Mundo.
Visíta Yahoo! Noticias.

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

Предыдущее
От: Greg Spiegelberg
Дата:
Сообщение: Compare rows
Следующее
От: Tomasz Myrta
Дата:
Сообщение: Re: planner doesn't use multicolumn index