executing pgsql on Xeon-dual machine
От | yutaka_inada@justsystem.co.jp |
---|---|
Тема | executing pgsql on Xeon-dual machine |
Дата | |
Msg-id | JM20021227160348.874241733@justsystem.co.jp обсуждение исходный текст |
Ответы |
Re: executing pgsql on Xeon-dual machine
|
Список | pgsql-performance |
Hello, 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(wal_method.sh) fsync - 200,000 data items --- Yutaka Inada [Justsystem Corporation]
В списке pgsql-performance по дате отправления: