Re: shared_buffers vs Linux file cache

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: shared_buffers vs Linux file cache
Дата
Msg-id CAMkU=1x0R1pkSOMS08pid=c0Ruu6ZwWo_JXU-2cTDL0ivai2+A@mail.gmail.com
обсуждение исходный текст
Ответ на shared_buffers vs Linux file cache  (Huan Ruan <huan.ruan.it@gmail.com>)
Ответы Re: shared_buffers vs Linux file cache
Список pgsql-performance

On Thu, Jan 15, 2015 at 3:30 AM, Huan Ruan <huan.ruan.it@gmail.com> wrote:
Hi All

I thought 'shared_buffers' sets how much memory that is dedicated to PostgreSQL to use for caching data, therefore not available to other applications.

However, as shown in the following screenshots, The server (CentOS 6.6 64bit) has 64GB of RAM, and 'shared_buffer' is set to 32GB, but the free+buffer+cache is 60GB. 

Shouldn't the maximum value for free+buffer+cache be 32GB ( 64 - 32)?
Is 'shared_buffers' pre allocated to Postgres, and Postgres only?

While PostgreSQL has reserves the right to use 32GB, as long as PostgreSQL has not actually dirtied that RAM yet, then the kernel is free to keep using it to cache files.

 
Cheers,

Jeff

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

Предыдущее
От: Glyn Astill
Дата:
Сообщение: Re: shared_buffers vs Linux file cache
Следующее
От: Josh Berkus
Дата:
Сообщение: Strange choice of general index over partial index