Re: select on 1milion register = 6s

Поиск
Список
Период
Сортировка
От Jan Dittmer
Тема Re: select on 1milion register = 6s
Дата
Msg-id 46B0C4C7.7000202@l4x.org
обсуждение исходный текст
Ответ на Re: select on 1milion register = 6s  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-performance
Scott Marlowe wrote:
>> random_page_cost = 1                    # units are one sequential page
>> fetch
>
> Seldom if ever is it a good idea to bonk the planner on the head with
> random_page_cost=1.  setting it to 1.2 ot 1.4 is low enough, but 1.4
> to 2.0 is more realistic.

Which is probably the reason why the planner thinks a seq scan is
faster than an index scan...

Jan

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: RES: Improving select peformance
Следующее
От: "Luke Lonergan"
Дата:
Сообщение: Re: Postgres configuration for 64 CPUs, 128 GB RAM...