Skip site navigation (1) Skip section navigation (2)

executing pgsql on Xeon-dual machine

From: yutaka_inada(at)justsystem(dot)co(dot)jp
To: pgsql-performance(at)postgresql(dot)org
Subject: executing pgsql on Xeon-dual machine
Date: 2002-12-27 07:03:48
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

I'm facing to a performance problem, when I run PostgreSQL 7.
2.1 + RedHat Linux 7.3 on a Xeon Dual CPU machine.

Compared with a P4 2.4GHz machine, pgbench shows 1/10 on the 
Xeon machine (detail is describled below), while hdparm 
shows 2 times faster.

Disabling HTT had no effects. PostgreSQL 7.2.3 is also slow  
on the machine.

I'm grateful if any of you can give me an advice. 

thank you.

data ---------------

[Hardware Profile]
DELL PowerEdge 2600
    CPU     Xeon 2GHz Dual
    Memory  2GB PC2100 ECC DDR266 SDRAM
    HDD     73GB 10,000rpm U320 SCSI

DELL PowerEdge 600SC (for comparison)
    CPU     Pentium 4 2.4GHz Single
    Memory  1GB 400MHz ECC DDR SDRAM 
    HDD     80GB 7,200rpm EIDE

[pgbench result]

multiplicity  |  1  |  128
PE 600        |259.2|178.2  [tps]
PE 2600       | 22.9| 34.8  [tps]

- wal_sync_method( fsync
- 200,000 data items

Yutaka Inada [Justsystem Corporation]


pgsql-performance by date

Next:From: Tom LaneDate: 2002-12-27 18:35:58
Subject: Re: executing pgsql on Xeon-dual machine
Previous:From: Tom LaneDate: 2002-12-26 23:43:39
Subject: Re: View performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group