Re: index / sequential scan problem

От: Fabian Kreitner
Тема: Re: index / sequential scan problem
Дата: ,
Msg-id: 5.1.0.14.0.20030718070624.0397b6b0@195.145.148.245
(см: обсуждение, исходный текст)
Ответ на: Re: index / sequential scan problem  (Fabian Kreitner)
Ответы: Re: index / sequential scan problem  (Dennis Björklund)
Список: pgsql-performance

Скрыть дерево обсуждения

index / sequential scan problem  (Fabian Kreitner, )
 Re: index / sequential scan problem  ("Shridhar Daithankar", )
  Re: index / sequential scan problem  (Fabian Kreitner, )
   Re: index / sequential scan problem  ("Shridhar Daithankar", )
 Re: index / sequential scan problem  (Paul Thomas, )
  Re: index / sequential scan problem  (Fabian Kreitner, )
   Re: index / sequential scan problem  (Paul Thomas, )
    Re: index / sequential scan problem  (Fabian Kreitner, )
     Re: index / sequential scan problem  ("Shridhar Daithankar", )
     Re: index / sequential scan problem  (Jord Tanner, )
     Re: index / sequential scan problem  (Paul Thomas, )
      Re: index / sequential scan problem  (Tom Lane, )
   Re: index / sequential scan problem  (Tom Lane, )
    Re: index / sequential scan problem  (Fabian Kreitner, )
     Re: index / sequential scan problem  (Fabian Kreitner, )
      Re: index / sequential scan problem  (Dennis Björklund, )
       Re: index / sequential scan problem  (Tom Lane, )
        Re: index / sequential scan problem  ("scott.marlowe", )
        Re: index / sequential scan problem  (Dennis Björklund, )

Hi all,

Adjusting the cpu_tuple_cost to 0.042 got the planner to choose the index.

Anything I need to consider when raising it to such "high" values?

Thanks for the help,
   Fabian



В списке pgsql-performance по дате сообщения:

От: Ron Johnson
Дата:
Сообщение: Re: Hardware performance
От: Andrew Sullivan
Дата:
Сообщение: Re: Clearing rows periodically