Re: Help Me Understand Why I'm Getting a Bad Query Plan

Поиск
Список
Период
Сортировка
От Bryan Murphy
Тема Re: Help Me Understand Why I'm Getting a Bad Query Plan
Дата
Msg-id 7fd310d10903252100n3ba13c9fuf4818a66cf7afb10@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Help Me Understand Why I'm Getting a Bad Query Plan  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Wed, Mar 25, 2009 at 10:28 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Bryan Murphy <bmurphy1976@gmail.com> writes:
>> What I did was change seq_page_cost back to 1.0 and then changed
>> random_page_cost to 0.5
>
> [ squint... ]  It makes no physical sense for random_page_cost to be
> less than seq_page_cost.  Please set them the same.
>
>                        regards, tom lane

Done.  Just  saw the tip in the docs as well.  Both are set to 0.5 now
and I'm still getting the good query plan.

Thanks!
Bryan

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Help Me Understand Why I'm Getting a Bad Query Plan
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: Raid 10 chunksize