RE: Question on disk contention

Поиск
Список
Период
Сортировка
От Igor Neyman
Тема RE: Question on disk contention
Дата
Msg-id DM5PR17MB153291332FB18F815366CCD1DA630@DM5PR17MB1532.namprd17.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Question on disk contention  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general



> Why isn't the OS caching the disk blocks, and why isn't Postgres using the cached data?

It does, but the cache is for each connection/job. They are not shared.

--

Melvin Davidson
Maj. Database & Exploration Specialist

Universe Exploration Command – UXC

Employment by invitation only!

 

 

 

That is simply not true: shared_buffers have this name for a reason. What’s not shared is work_mem used for sorting, etc…

Also OS cache is shared too.

 

Regards,

Igor Neyman

 

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

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: Question on disk contention
Следующее
От: Fabio Pardi
Дата:
Сообщение: Re: Question on disk contention