specify whitch index to use

Поиск
Список
Период
Сортировка
Искать
От
pgsql-general@list.coretech.ro
Тема
specify whitch index to use
Дата
Msg-id
45574DA4.9090206@list.coretech.ro
Список
Дерево обсуждения
specify whitch index to use "pgsql-general@list.coretech.ro" <pgsql-general@list.coretech.ro>
Re: specify whitch index to use Andreas Kretschmer <akretschmer@spamfence.net>
Re: specify whitch index to use "pgsql-general@list.coretech.ro" <pgsql-general@list.coretech.ro>

hello,

I have two indexes on a table on cols col1 and col2, the table has ~10M 
rows on pg v8.1.4

when I use "where col1 = val1" the query is fast and returns 0 rows
when I use "where col2 > val2" the query is slow and returns ~1M rows

in both cases the corresponding indexes are used.
when I use "where col1 = val1 and col2 > val2" the query is slow and 
returns 0 rows using the index on col2

is there any way for postgres to use both indexes when relevant columns 
are present in a where clause ?
is it possible to specify which index to use in a query ?


thanks,
razvan radu


В списке pgsql-general по дате отправления
От: Chris Mair
Дата:
От: Andreas Kretschmer
Дата:
FAQ