Re: Enough RAM for entire Database.. cost aside, is this

Поиск
Список
Период
Сортировка
От Edmund Dengler
Тема Re: Enough RAM for entire Database.. cost aside, is this
Дата
Msg-id Pine.BSO.4.58.0407081408180.1211@cyclops4.esentire.com
обсуждение исходный текст
Ответ на Re: Enough RAM for entire Database.. cost aside, is this  (Mike Rylander <miker@purplefrog.com>)
Список pgsql-general
Greetings!

On Fri, 2 Jul 2004, Mike Rylander wrote:

> I find that experience does not bear this out.  There is a saying a coworker
> of mine has about apps that try to solve problems, in this case caching,
> that are well understood and generally handled well at other levels of the
> "software stack"... he calls them "too smart by half" :)

But on the other hand, general algorithms which are designed to work under
a wide variety of circumstances may fail in specific cases. I am thinking
of VACUUM which would kill most caching algorithms simply because we
cannot tell the O/S "by the by, this set of pages will not be used again,
and therefore it would be fine to use almost none of the general cache to
store this". All algorithms have assumptions of value distribution and
usages. Caches depend on locality of reference, and we do not have an easy
way to say when this is broken.

Regards!
Ed

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

Предыдущее
От:
Дата:
Сообщение: Re: enable thready safety on Mac OS X 10.3.4
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: enable thready safety on Mac OS X 10.3.4