Re: DB cache size strategies

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: DB cache size strategies
Дата
Msg-id 21498.1076516293@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: DB cache size strategies  ("Ed L." <pgsql@bluepolka.net>)
Ответы Re: DB cache size strategies  ("Ed L." <pgsql@bluepolka.net>)
Список pgsql-general
"Ed L." <pgsql@bluepolka.net> writes:
> In general, would it be true to say that if one does *not* anticipate
> contention for kernel disk cache space from non-DB processes (e.g., the
> dedicated db server), then you probably want to use theory (1)?  If one
> *does* anticipate such contention (e.g. the all-on-one-box web-db app),
> then you probably want to use theory (2) in order to ensure an adequate
> cache?

If the box is doing other things then I think you definitely want to
keep shared_buffers pretty small, relying on the kernel to allocate the
available resources as best it can.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Function parameters of rowtype
Следующее
От: Mike Mascari
Дата:
Сообщение: Re: pl/pythonu