Re: Wrong plan sequential scan instead of an index one

Поиск
Список
Период
Сортировка
От Claus Guttesen
Тема Re: Wrong plan sequential scan instead of an index one
Дата
Msg-id b41c75520703300251oe916648r75c16c1bf70cd10@mail.gmail.com
обсуждение исходный текст
Ответ на Wrong plan sequential scan instead of an index one  (Gaetano Mendola <mendola@bigfoot.com>)
Ответы Re: Wrong plan sequential scan instead of an index one
Список pgsql-performance
> Hi all,
> take a look at those plans:

Try changing random_page_cost from the default 4 to 2 in postgresql.conf:

random_page_cost = 2

The default in postgresql is somewhat conservative. This setting
indicates for postgresql how fast your disks are, the lower the
faster.

Could this setting be changed to 2 as default rather than 4?

regards
Claus

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

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Wrong plan sequential scan instead of an index one
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Wrong plan sequential scan instead of an index one