Re: Planner chooses multi-column index in 9.2 when maybe it should not

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Planner chooses multi-column index in 9.2 when maybe it should not
Дата
Msg-id 13660.1349913045@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Planner chooses multi-column index in 9.2 when maybe it should not  (Greg Sabino Mullane <greg@endpoint.com>)
Список pgsql-general
Greg Sabino Mullane <greg@endpoint.com> writes:
> Found a good demonstration of the problem. Here's explain analyze of a
> query on 9.2 with enable_indexonlyscan = off; This produces the exact same
> plan as 8.3. The tables in question have been analyzed. Changing
> random_page_cost has no effect. The main foobar table has 17M rows.

Can you provide a self-contained test case for this (ie, sample data)?

            regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Index only scan
Следующее
От: Ondrej Ivanič
Дата:
Сообщение: Re: moving from MySQL to pgsql