From: Thomas Munro [mailto:thomas.mu...@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:and...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
