Re: Any way to speed this up?

Список
Период
Сортировка
От Tom Lane
Тема Re: Any way to speed this up?
Дата
Msg-id 11372.1112892168@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Any way to speed this up?  ("Joel Fradkin")
Ответы Re: Any way to speed this up?  ("Joel Fradkin")
Список pgsql-performance
Дерево обсуждения
Any way to speed this up?  ("Joel Fradkin", )
 Re: Any way to speed this up?  ("Keith Worthington", )
 Re: Any way to speed this up?  (John Arbash Meinel, )
  Re: Any way to speed this up?  (Tom Lane, )
 Re: Any way to speed this up?  (Tom Lane, )
  Re: Any way to speed this up?  ("Joel Fradkin", )
   Re: Any way to speed this up?  (Tom Lane, )
    Re: Any way to speed this up?  ("Joel Fradkin", )
     Re: Any way to speed this up?  (John Arbash Meinel, )
     Re: Any way to speed this up?  ("Jim C. Nasby", )
   Re: Any way to speed this up?  (John Arbash Meinel, )
"Joel Fradkin" <> writes:
> random_page_cost = 1.2#4        # units are one sequential page
> fetch cost

That is almost certainly overoptimistic; it's causing the planner to
use indexscans when it shouldn't.  Try 2 or 3 or thereabouts.

            regards, tom lane

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

Предыдущее
От: "Joel Fradkin"
Дата:
Сообщение: Re: Any way to speed this up?
Следующее
От: John Arbash Meinel
Дата:
Сообщение: Re: Any way to speed this up?