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 по дате сообщения:

От: "Jim C. Nasby"
Дата:
Сообщение: Re: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)
От: Tom Lane
Дата:
Сообщение: Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)