
Memory
Postgres FM
00:00
The Importance of Cash in Postgres
Postgres never reads files from disk from file system it always goes through page cache. The rule of thunder right now is 25% I remember when we started to have more than a couple of gigabytes of memory on most machines there was a debate like at some point the rule was 25 if it does exceed like 8 gigabytes but now it's already it's okay to allocate 100 200 gigabytes and it's normal.
Transcript
Play full episode