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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Help Me Understand Why I'm Getting a Bad Query Plan
Дата
Msg-id 12624.1238038097@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Help Me Understand Why I'm Getting a Bad Query Plan  (Bryan Murphy <bmurphy1976@gmail.com>)
Ответы Re: Help Me Understand Why I'm Getting a Bad Query Plan  (Bryan Murphy <bmurphy1976@gmail.com>)
Список pgsql-performance
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

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

Предыдущее
От: Bryan Murphy
Дата:
Сообщение: 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