Greg Smith 2ndquadrant.com> writes:
> You're probably running into this problem:
> http://notemagnet.blogspot.com/2008/05/pgbench-suffering-with-linux-2623-2626.html
You are so right. The last thing I would have suspected is a kernel bug. I am
definitely going to try to be more aware of kernel
Mike Bresnahan wrote:
As you see, the TPS remains the same as I increase the number of clients. These
results make it look like PostgreSQL is single-threaded and not taking advantage
of the multiple cores. Could someone please explain?
You're probably running into this problem:
http://note
On Tue, Jan 26, 2010 at 3:01 PM, Mike Bresnahan
wrote:
> During these tests top(1) reported 60-70% idle CPU.
>
> As you see, the TPS remains the same as I increase the number of clients.
> These
> results make it look like PostgreSQL is single-threaded and not taking
> advantage
> of the multipl
I have a read-only database that I am testing the performance of to get a sense
of how many concurrent users I can support. The database fits entirely in RAM so
I expect there to be little to no disk activity. Because of this, I expect
throughput to scale almost linearly with the number of CPUs I h
