Re: FYI , Intel CC and PostgreSQL , benchmark by pgsql - Mailing list pgsql-hackers

From Tom Lane
Subject Re: FYI , Intel CC and PostgreSQL , benchmark by pgsql
Date
Msg-id 22093.1074179401@sss.pgh.pa.us
Whole thread Raw
In response to FYI , Intel CC and PostgreSQL , benchmark by pgsql  (jihuang <jihuang@iis.sinica.edu.tw>)
List pgsql-hackers
jihuang <jihuang@iis.sinica.edu.tw> writes:
> I have a new server and some time to do an interesting simple benchmark.
> Compile PostgreSQL 7.4.1R by gcc3.2 and Intel CC 8.0 , and use pgbench 
> to evaluate any difference..

In my experience, a 10% difference in pgbench results is below the noise
level :-(.  And when you only run 300 transactions, the results are too
unrepeatable even to be worth posting.

If you had run, say, 10000-transaction tests and averaged the results
over a couple dozen runs, the mean and standard deviation of those
results might be enough data to tell something.

BTW, when you use a number of clients greater than the scaling
factor, what you're measuring is mostly contention artifacts ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: ohp@pyrenet.fr
Date:
Subject: set search_path and pg_dumpall
Next
From: Andrew Dunstan
Date:
Subject: Re: [pgsql-hackers-win32] Microsoft releses Services for Unix