Scott Carey <sc...@richrelevance.com> writes: > They are not meaningless. It is certainly more to understand, but the test > is entirely valid without that. In a CPU bound / RAM bound case, as > concurrency increases you look for the throughput trend, the %CPU use trend > and the context switch rate trend. More information would be useful but the > test is validated by the evidence that it is held up by lock contention.
Er ... *what* evidence? There might be evidence somewhere that proves that, but Jignesh hasn't shown it. The available data suggests that the first-order performance limiter in this test is something else. Otherwise it should be possible to max out the performance with a lot less than 1000 active backends. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance