Re: index / sequential scan problem

Поиск
Список
Период
Сортировка
От Dennis Björklund
Тема Re: index / sequential scan problem
Дата
Msg-id Pine.LNX.4.44.0307182037580.4146-100000@zigo.dhs.org
обсуждение исходный текст
Ответ на Re: index / sequential scan problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Fri, 18 Jul 2003, Tom Lane wrote:

> >> Adjusting the cpu_tuple_cost to 0.042 got the planner to choose the index.
>
> > Doesn't sound very good and it will most likely make other queries slower.
>
> Seems like a reasonable approach to me --- certainly better than setting
> random_page_cost to physically nonsensical values.

Hehe, just before this letter there was talk about changing
random_page_cost. I kind of responed that 0.042 is not a good random page
cost. But now of course I can see that it says cpu_tuple_cost :-)

Sorry for adding confusion.

--
/Dennis


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

Предыдущее
От:
Дата:
Сообщение: Re: Yet another slow join query.. [ SOLVED ]
Следующее
От: "Nick Fankhauser"
Дата:
Сообщение: Re: Sanity check requested