forcing use of more indexes (bitmap AND)

Поиск
Список
Период
Сортировка
От Ow Mun Heng
Тема forcing use of more indexes (bitmap AND)
Дата
Msg-id 1205476095.354.29.camel@neuromancer.home.net
обсуждение исходный текст
Ответы Re: forcing use of more indexes (bitmap AND)
Re: forcing use of more indexes (bitmap AND)
Список pgsql-general
query is something like this

    Select *
    from v_test
    where acode Like 'PC%'
    and rev = '0Q'
    and hcm = '1'
    and mcm = 'K'

where acode, rev, hcm, mcm are all indexes.

Currently this query is only using the rev and mcm for the bitmapAND.
it then does a bitmap heap scan using the acode and the hcm indexes.

I would like to try to see if forcing the planner to favour heavier usage of the indexes would yield faster results.

I've tried lowering random_page_cost(default 4) down to 2 with no change in planner.


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

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Can't rename an existnig DB because it doesn't exist???
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: tsearch2 word separators