RE: Question on disk contention

[Igor Neyman <ineyman@xxxxxxxxxxxxxx>]

> 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