> 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 by date:
Соглашаюсь с условиями обработки персональных данных
