From: Thomas Munro [mailto:thomas.munro@enterprisedb.com]
> Your ~2.4% number is similar to what was reported for Linux with 4GB
> shared_buffers:
>
> https://www.postgresql.org/message-id/20130913234125.GC13697%40roobarb
> .crazydogs.org
I'm relieved to know that a similar figure was gained on Linux. Thanks for the info.
> Later in that thread there was a report of a dramatic ~15% increase in "best
> result" TPS, but that was with 60GB of shared_buffers on a machine with
> 256GB of RAM:
>
> https://www.postgresql.org/message-id/20131024060313.GA21888%40toroid.
> org
From: Andres Freund [mailto:andres@anarazel.de]
> FWIW, I've seen 2-3x increases with ~60GB of s_b.
Wow, nice figures. It's unfortunate that I don't have such a big machine available at hand.
Regards
Takayuki Tsunakawa