Re: Benchmark Data requested - Mailing list pgsql-performance

From Gregory Stark
Subject Re: Benchmark Data requested
Date
Msg-id 873as85kkw.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: Benchmark Data requested  ("Jignesh K. Shah" <J.K.Shah@Sun.COM>)
Responses Re: Benchmark Data requested
List pgsql-performance
"Jignesh K. Shah" <J.K.Shah@Sun.COM> writes:

> Then for the power run that is essentially running one query at a time should
> essentially be able to utilize the full system (specially multi-core systems),
> unfortunately PostgreSQL can use only one core. (Plus since this is read only
> and there is no separate disk reader all other processes are idle) and system
> is running at 1/Nth capacity (where N is the number of cores/threads)

Is the whole benchmark like this or is this just one part of it?

Is the i/o system really able to saturate the cpu though?

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's On-Demand Production Tuning

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Benchmark Data requested
Next
From: Gregory Stark
Date:
Subject: Re: Benchmark Data requested