On Tue, Jan 26, 2010 at 3:01 PM, Mike Bresnahan <mike.bresnahan@xxxxxxxxxxx> 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 multiple cores. Could someone please explain? This is more likely a limitation of pgbench and not postgresql. pgsql 9.0 has a multi-threaded pgbench coming with it that should help for testing these situations. http://www.depesz.com/index.php/2009/08/26/waiting-for-8-5-multi-threaded-pgbench/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
