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

Поиск
Список
Период
Сортировка
От Harald Fuchs
Тема Re: Enough RAM for entire Database.. cost aside, is this
Дата
Msg-id pufz81quh3.fsf@srv.protecting.net
обсуждение исходный текст
Ответ на Enough RAM for entire Database.. cost aside, is this going to be fastest?  ("Andy B" <abhousehuntRE-M--O--V-E@blueyonder.co.uk>)
Список pgsql-general
In article <Pine.BSO.4.58.0407081408180.1211@cyclops4.esentire.com>,
Edmund Dengler <edmundd@eSentire.com> writes:

> 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".

We _can_ tell that the OS: man madvise.

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

Предыдущее
От: Thomas Mueller
Дата:
Сообщение: Re: Column name 'user' not allowed?
Следующее
От: Jeff Eckermann
Дата:
Сообщение: Re: Training and certification