On Fri, Mar 29, 2013 at 8:31 AM, Franck Routier <franck.rout...@axege.com>wrote:

> Hi,
>
>  I don't know that tcp-b does
>>
> tpcb.jar is a java implementation of the http://www.tpc.org/tpcb/benchmark. 
> It is not particularly representative of my workload, but gives
> a synthetic, db-agnostic, view of the system performance.
> We use it to have quick view to compare differents servers (different OS,
> different RDBMS, etc...).
>

I took a quick look at that implementation, and I can't make heads nor
tails of it.  It is just a lit of .java files.  There is no documentation,
README, instructions, or example usage.  Am I missing something?  How do I
run it, and tell it what scale to use and what database to connect to?



> That said, the test wil create tables, load them with data, and perform
> some transactions on them.
> The point that makes me wonder what happens, is that the test run on my
> main database is slow, while the same test run on a database on its own is
> quick.
> This is the same postgresql cluster (same postgresql.conf), same
> tablespace (so same disks), same hardware obviously.
>
> Regarding the server activity, it seems quite flat : iostat shows that
> disks are not working much (less than 5%),


Which column of the iostat output is that coming from?


> top shows only one active core, and load average is well under 1...
>

Can you show the first few rows of the top output?

Cheers,

Jeff

Reply via email to