"Kevin Grittner" <Kevin.Grittner@xxxxxxxxxxxx> writes: > You misunderstood me. I wasn't addressing the affects of his change, > but rather the fact that his test shows a linear improvement in TPS up > to 1000 connections for a 64 thread machine which is dealing entirely > with RAM -- no disk access. Where's the bottleneck that allows this > to happen? Without understanding that, his results are meaningless. Yeah, that is a really good point. For a CPU-bound test you would ideally expect linear performance improvement up to the point at which number of active threads equals number of CPUs, and flat throughput with more threads. The fact that his results don't look like that should excite deep suspicion that something is wrong somewhere. This does not in itself prove that the idea is wrong, but it does say that there is some major effect happening in this test that we don't understand. Without understanding it, it's impossible to guess whether the proposal is helpful in any other scenario. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
