X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9F0088B9E18 for ; Wed, 2 Feb 2005 18:49:44 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33896-07 for ; Wed, 2 Feb 2005 18:49:41 +0000 (GMT) Received: from rwcrmhc12.comcast.net (rwcrmhc12.comcast.net [216.148.227.85]) by svr1.postgresql.org (Postfix) with ESMTP id B53648B9D02 for ; Wed, 2 Feb 2005 18:49:40 +0000 (GMT) Received: from [192.168.0.100] (c-24-5-74-176.client.comcast.net[24.5.74.176]) by comcast.net (rwcrmhc12) with ESMTP id <20050202184939014003d6t4e>; Wed, 2 Feb 2005 18:49:39 +0000 Message-ID: <420120BF.5050208@talisys.com> Date: Wed, 02 Feb 2005 10:49:35 -0800 From: William Yu User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Bruce Momjian Cc: pgsql-performance@postgresql.org Subject: Re: High end server and storage for a PostgreSQL OLTP system References: <200502021835.j12IZKA04787@candle.pha.pa.us> In-Reply-To: <200502021835.j12IZKA04787@candle.pha.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200502/38 X-Sequence-Number: 10367 Bruce Momjian wrote: > William Yu wrote: > >>>>You can get 64-bit Xeons also but it takes hit in the I/O department due >>>>to the lack of a hardware I/O MMU which limits DMA transfers to >>>>addresses below 4GB. This has a two-fold impact: >>>> >>>>1) transfering data to >4GB require first a transfer to <4GB and then a >>>>copy to the final destination. >>>> >>>>2) You must allocate real memory 2X the address space of the devices to >>>>act as bounce buffers. This is especially problematic for workstations >>>>because if you put a 512MB Nvidia card in your computer for graphics >>>>work -- you've just lost 1GB of memory. (I dunno how much the typical >>>>SCSI/NIC/etc take up.) > > > When you say "allocate real memory 2X" are you saying that if you have > 16GB of RAM only 8GB is actually usable and the other 8GB is for > bounce buffers, or is it just address space being used up? > It's 2x the memory space of the devices. E.g. a Nvidia Graphics card w/ 512MB of RAM would require 1GB of memory to act as bounce buffers. And it has to be real chunks of memory in 64-bit mode since DMA transfer must drop it into real memory in order to then be copied to > 4GB.