3 ms·
Well it doesn't serve it from disk. It's persisted to disk and Postgres buffer cache keeps the working set in memory.
by nikita 3y ago
Well it doesn't serve it from disk. It's persisted to disk and Postgres buffer cache keeps the working set in memory.
- HammadB 3y agoMaybe I am misunderstanding but the postgres buffer cache is LRU and will evict pages right? At times data may go to disk and then during serving it will have to be loaded into memory? So it is quite dependent on the size of your buffer cache as well as contention for that buffer cache. Also the cache access patterns will vary between these implementations and is worth considering.
- nikita 3y agoFor sure.