| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | yutaka_inada(at)justsystem(dot)co(dot)jp |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: executing pgsql on Xeon-dual machine |
| Date: | 2002-12-27 18:35:58 |
| Message-ID: | 25730.1041014158@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
yutaka_inada(at)justsystem(dot)co(dot)jp writes:
> 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.
If you set fsync off, how do the pgbench results change?
> [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
I'm suspicious that the IDE drive may be configured to lie about write
completion. If it reports write complete when it's really only buffered
the data in controller RAM, then you're effectively running with fsync
off on the PE600.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | li li | 2002-12-29 22:09:10 | A question about inheritance |
| Previous Message | yutaka_inada | 2002-12-27 07:03:48 | executing pgsql on Xeon-dual machine |