Re: per table random-page-cost?

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: per table random-page-cost?
Дата
Msg-id 407d949e0910191629w7607e384g24535e3d760a811c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: per table random-page-cost?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: per table random-page-cost?  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-hackers
On Mon, Oct 19, 2009 at 4:21 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> marcin mank <marcin.mank@gmail.com> writes:
>>> This proposal is just "hints by the back door", ISTM. As Tom says, there is
>>> a justification for having it on tablespaces but not on individual tables.
>
>> If the parameter is defined as "the chance that a page is in cache"
>> there is very real physical meaning to it.
>
> We have no such parameter...


And we want our parameters to be things the DBA has a chance of being
able to estimate. How would you come up with sensible figures for this
hypothetical parameter?


-- 
greg


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: per table random-page-cost?
Следующее
От: Greg Stark
Дата:
Сообщение: Re: per table random-page-cost?