Re: DB cache size strategies

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: DB cache size strategies
Дата
Msg-id 20040211113031.GA30118@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на Re: DB cache size strategies  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Wed, Feb 11, 2004 at 12:26:06AM -0500, Tom Lane wrote:
> Giving PG half the RAM is counterproductive no matter what --- that
> pretty much guarantees that every page that's in RAM will be in RAM
> twice, once in PG buffers and once in kernel buffers.  The two

Well, unless you're using an OS which allows you to set a nocache
option for a filesystem (Solaris allows this on UFS, for instance).
But the kernel cache, in my experience, is _still_ the winner,
because the LRU database cache isn't real efficient at large sizes.

--
Andrew Sullivan

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

Предыдущее
От: Erwin Van de Velde
Дата:
Сообщение: Converting timestamps and IP addresses
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: pg_class and relfilenode