Re: What's the best hardver for PostgreSQL 8.1?

From: William Yu <wyu(at)talisys(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: What's the best hardver for PostgreSQL 8.1?
Date: 2005-12-21 23:57:56
Message-ID: docq5v$24ea$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Juan Casero wrote:
> Can you elaborate on the reasons the opteron is better than the Xeon when it
> comes to disk io? I have a PostgreSQL 7.4.8 box running a DSS. One of our

Opterons have 64-bit IOMMU -- Xeons don't. That means in 64-bit mode,
transfers to > 4GB, the OS must allocated the memory < 4GB, DMA to that
block and then the CPU must do extra work in copying the memory to >
4GB. Versus on the Opteron, it's done by the IO adaptor using DMA in the
background.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Carlos Benkendorf 2005-12-22 00:35:00 Re: ORDER BY costs
Previous Message Michael Fuhr 2005-12-21 22:10:28 Re: Speed of different procedural language