It's also possible to figure out what your actual shared buffers needs are as well! #postgresql https://www.keithf4.com/a-small-database-does-not-mean-small-shared_buffers/ …https://twitter.com/AndresFreundTec/status/1178765225895399424 …
-
-
Iteratively applying the approach presented, will almost always lead to a even smaller shared buffers recommendation in each further round. With a smaller s_b setting, there necessarily needs to be buffer replacement, which in turn means there'll be buffers with usagecount < 3.
-
If it's an accident, it sure has worked out well for several years now. And iteratively applying it certainly has not resulted in smaller values all the time. I've watched it fluctuate up and down wildly, depending on the sampling rate.
- 5 more replies
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.