> iostat -xd 10
>
> have to say about it?
Yes i was indeed maxing out my IO subsystem. % CPU utilization for io
is around 90 percent. I could not notice this earlier because i was
firing CPU load queries from a remote machine hence network overhead
was coming into picture .Thanks a lot for your
>Rahila, if you want to saturate the CPU and don't care about the
> particular benchmark, try to use read-only transactions. Either just add
> "-S" at the pgbench command line, or write something SELECT-only on your
> own. Anyway, use '-j' in such cases.
Thanks a lot for your suggestion. Using se
On 25.10.2013 19:04, Scott Marlowe wrote:
> On Fri, Oct 25, 2013 at 8:29 AM, Rahila Syed wrote:
>>
>> Configurations of my machine is:
>>
>> Processors: Xeon E5-2650 Processor Kit
>> Intel® Xeon ® Processor E5-2650 (2 GHz, 8C/16T,
>> 20 MB) * 2 nos
>>
>>
>> RAM : 32GB DDR3
On Fri, Oct 25, 2013 at 8:29 AM, Rahila Syed wrote:
> Hello All,
>
> I am using jdbcrunner-1.2 to run PostgreSQL performance tests. For
> certain tests, i need to increase the CPU usage of the servers
> especially at user level.
> I tried using both tpcc and tpcb load with scale factor of 100. Eve
Hello All,
I am using jdbcrunner-1.2 to run PostgreSQL performance tests. For
certain tests, i need to increase the CPU usage of the servers
especially at user level.
I tried using both tpcc and tpcb load with scale factor of 100. Even
after setting the number of client connections as high as 420,
