FYI , Intel CC and PostgreSQL , benchmark by pgsql

From: jihuang <jihuang(at)iis(dot)sinica(dot)edu(dot)tw>
To: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: FYI , Intel CC and PostgreSQL , benchmark by pgsql
Date: 2004-01-15 11:11:30
Message-ID: 40067562.7090901@iis.sinica.edu.tw
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Glaesemann 2004-01-15 11:29:41 Re: Bug and/or feature? Complex data types in tables...
Previous Message Hannu Krosing 2004-01-15 11:10:16 Re: Encoding problems in PostgreSQL with XML data