4 ms·
The default shared memory is 128MiB, not even 1% of typical machines today. A benchmark run with these settings is effectively crippling your hardware by making
by perrygeo 1y ago
The default shared memory is 128MiB, not even 1% of typical machines today. A benchmark run with these settings is effectively crippling your hardware by making sure 99% of your available memory is ignored by postgres. It's an invalid benchmark, unless redis is similarly crippled.
- igneo676 1y ago> If the defaults are fine for a use case then unless I want to tune it for personal interest it’s either a poor use of my fun time or a poor use of my clients funds. It doesn't matter if you've crippled the benchmark if the performance of both options still exceeds your expectations. Not all of us are trying eek out every drop of performance And, well, if you are then you can ignore the entire post because Redis offers better perf than postgres and you'd use that. It's that simple.
- perrygeo 1y agogood point, even postgres crippled was "good enough" so it doesn't change the overall message. Nonetheless, we should strive to do realistic and valid benchmarks, no?
- onraglanroad 1y ago> Not all of us are trying eek out every drop of performance You probably mean "eke out". Unless the performance is particularly scary :)
- spixy 1y agowow, default 128MiB sounds so stupid