On Tue, Apr 12, 2011 at 6:40 PM, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> wrote: > > Well, that pretty much clinches it. Your RAM access tops out at 16 > processors. It appears that your processors are spending most of > their time waiting for and contending for the RAM bus. It tops, but it doesn't drop. I'd propose that the perceived drop in TPS is due to cache contention - ie, more processes fighting for the scarce cache means less efficient use of the (constant upwards of 16 processes) bandwidth. So... the solution would be to add more servers, rather than just sockets. (or a server with more sockets *and* more bandwidth) -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
