2 ms·
> it still hits disk on db reads because they offload memory management to the OS Or rather: It hits the OS's disk cache. I'm not saying that this isn't a prob
by Qerub 14y ago
> it still hits disk on db reads because they offload memory management to the OS
Or rather: It hits the OS's disk cache. I'm not saying that this isn't a problem, but it's far from as bad you make it sound.
(http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Serve... actually recommends limiting `shared_buffers` (PostgreSQL's in-memory cache) to let the OS disk cache do its magic.)a