Re: [HACKERS] too low cost of Bitmap index scan

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] too low cost of Bitmap index scan
Дата
Msg-id 6271.1482274893@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [HACKERS] too low cost of Bitmap index scan  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: [HACKERS] too low cost of Bitmap index scan  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
Pavel Stehule <pavel.stehule@gmail.com> writes:
> I am trying to fix slow query on PostgreSQL 9.5.4.
> The data are almost in RAM

If it's all in RAM, you'd likely be well-served to lower random_page_cost.
It looks to me like the planner is estimating pretty accurately how many
heap fetches will be eliminated by using the extra index; where it's off
seems to be in the cost of those heap fetches relative to the index work.
        regards, tom lane

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] Make pg_basebackup -x stream the default
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: pg_authid.rolpassword format (was Re: [HACKERS] Passwordidentifiers, protocol aging and SCRAM protocol)