Re: 8.2 and 8.3 postgresql.conf oddity

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 8.2 and 8.3 postgresql.conf oddity
Дата
Msg-id 22060.1201107851@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 8.2 and 8.3 postgresql.conf oddity  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Список pgsql-bugs
"Guillaume Smet" <guillaume.smet@gmail.com> writes:
> On Jan 23, 2008 4:22 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> What do you find odd about it?  Whatever scale you choose to think these
>> values are in, they all have to be on the same scale.

> So they are not defined in relation compared to the sequential page
> fetch cost as they were before?

Well, you could choose to stick to the traditional scale, in which
seq_page_cost is always 1.0 and everything else is relative to that.
Or you could try to make them all measure actual milliseconds on
your actual machine.  Or something else.

> I mean, if I change seq_page_cost
> only, it doesn't change the overall behaviour?

Certainly it would.  If you multiply *all* the cost constants by the same
factor, then the behavior wouldn't change.

            regards, tom lane

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

Предыдущее
От: "Guillaume Smet"
Дата:
Сообщение: Re: 8.2 and 8.3 postgresql.conf oddity
Следующее
От: "David Gradwell"
Дата:
Сообщение: BUG #3897: plJava dll still doesn't load