Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster
Дата
Msg-id 4F7D753C0200002500046BF5@gw.wicourts.gov
обсуждение исходный текст
Ответ на Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster  (Kim Hansen <kim@rthansen.dk>)
Ответы Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster  (Kim Hansen <kim@rthansen.dk>)
Список pgsql-performance
Kim Hansen <kim@rthansen.dk> wrote:

> I have a query where the planner makes a wrong cost estimate, it
> looks like it underestimates the cost of a "Bitmap Heap Scan"
> compared to an "Index Scan".

> What can I do to fix the cost estimate?

Could you try running the query with cpu_tuple_cost = 0.05 and let
us know how that goes?

-Kevin

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: about multiprocessingmassdata
Следующее
От: Gregg Jaskiewicz
Дата:
Сообщение: heavly load system spec