On 08/31/2015 01:16 PM, Josh Berkus wrote:
All, Bruce:
I'm also going to pontificate that, for a future solution, we should not focus on write *IO*, but rather on CPU and RAM. The reason for this thinking is that, with the latest improvements in hardware and 9.5 improvements, it's increasingly rare for machines to be bottlenecked on writes to the transaction log (or the heap). This has some implications for system design. For example, solutions which require all connections to go through a single master node do not scale sufficiently to be worth bothering with.
We see this already, under very high concurrency (lots of connections, many cores) we often see a significant drop in performance that is not related to IO in any meaningful way.
JD -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consulting and development. Announcing "I'm offended" is basically telling the world you can't control your own emotions, so everyone else should do it for you. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
