Re: FYI , Intel CC and PostgreSQL , benchmark by pgsql

It would be interesting to see the results if you do this test again with :

- scaling factor somewhere in the 100->300 range (so the generated db ~= 
your ram amount)
- number of clients somewhere in 10->100
- number of transactions somewhere in 1000->1000

best wishes

Mark

P.s - Are you using the GENERIC kernel or have you built you own (e.g 
with SMP suppport for your hyperthreaded cpu?)

jihuang wrote:

> Hi,
> 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..
>
> Here is the result.
>
> ----------------------
>
> CPU: Intel(R) Xeon(TM) CPU 3.06GHz (3052.79-MHz 686-class CPU)
> Origin = "GenuineIntel"  Id = 0xf29  Stepping = 9
>
> Features=0xbfebfbff<FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CLFLUSH,DTS,ACPI,MMX 
>
> ,FXSR,SSE,SSE2,SS,HTT,TM,PBE>
> Hyperthreading: 2 logical CPUs
> real memory  = 3221200896 (3071 MB)
> avail memory = 3130855424 (2985 MB)
>
> FreeBSD 5.1-RELEASE-p11
> /usr/local/intel_cc_80/bin/icc -V
> Intel(R) C++ Compiler for 32-bit applications, Version 8.0   Build 
> 20031211Z Package ID: l_cc_p_8.0.055_pe057
> Copyright (C) 1985-2003 Intel Corporation.  All rights reserved.
> FOR NON-COMMERCIAL USE ONLY
>
> gcc -v
> Using built-in specs.
> Configured with: FreeBSD/i386 system compiler
> Thread model: posix
> gcc version 3.2.2 [FreeBSD] 20030205 (release)
>
> Application: PostgreSQL 7.4.1
> Benchmark: pgbench
>
> Result :
> 1. IntelCC ( use ports/database/postgresql7 , default )
> ./pgbench -U pgsql -c 30  test
> starting vacuum...end.
> transaction type: TPC-B (sort of)
> scaling factor: 1
> number of clients: 30
> number of transactions per client: 10
> number of transactions actually processed: 300/300
> tps = 34.975026 (including connections establishing)
> tps = 35.550815 (excluding connections establishing)
>
>
> 2. GNU cc( use ports/database/postgresql7 , default )
> ./pgbench -U pgsql -c 30  test
> starting vacuum...end.
> transaction type: TPC-B (sort of)
> scaling factor: 1
> number of clients: 30
> number of transactions per client: 10
> number of transactions actually processed: 300/300
> tps = 38.968321 (including connections establishing)
> tps = 39.707451 (excluding connections establishing)
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>