Re: Bitmap scan cost model (was Re: bitmap scans, btree scans, and tid order)

Поиск
Список
Период
Сортировка
От Manfred Koizar
Тема Re: Bitmap scan cost model (was Re: bitmap scans, btree scans, and tid order)
Дата
Msg-id a2dm815pnm26564oeq2bniuhp909pkpfis@email.aon.at
обсуждение исходный текст
Ответ на Bitmap scan cost model (was Re: bitmap scans, btree scans, and tid order)  ("Jeffrey W. Baker" <jwbaker@acm.org>)
Список pgsql-hackers
On Tue, 17 May 2005 22:12:17 -0700, "Jeffrey W. Baker" <jwbaker@acm.org>
wrote:
>Incrementing random_page_cost from 4 (the default) to 5 causes the
>planner to make a better decision.

We have such a low default random_page_cost primarily to mask other
problems in the optimizer, two of which are

. multi-column index correlation

. interpolation between min_IO_Cost and max_IO_cost which approximates
max_IO_cost too fast.

ServusManfred


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

Предыдущее
От: Manfred Koizar
Дата:
Сообщение: Re: Cost of XLogInsert CRC calculations
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: Ingres dump files to PostgreSQL