Memory
Postgres FM
00:00
How to Optimize Your Postgres Database Performance
The shared buffers the Postgres cache versus operating system cache and I think Andra's does a great job of simplifying the fact that you can have it saved in both. If you have the same data duplicated that's inefficient for your cache hit rate so 50 probably is not a good idea at all right. In my opinion if you start with 25% for all TP workloads and then say we are going to optimize it and say maybe 40 is better you have premature optimization because most likely you have different things to tune first, he says.
Transcript
Play full episode
