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 E36358B9E35 for ; Wed, 2 Feb 2005 18:35:26 +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 32572-06 for ; Wed, 2 Feb 2005 18:35:23 +0000 (GMT) Received: from candle.pha.pa.us (candle.pha.pa.us [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id 750468B9D02 for ; Wed, 2 Feb 2005 18:35:22 +0000 (GMT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id j12IZKA04787; Wed, 2 Feb 2005 13:35:20 -0500 (EST) From: Bruce Momjian Message-Id: <200502021835.j12IZKA04787@candle.pha.pa.us> Subject: Re: High end server and storage for a PostgreSQL OLTP system In-Reply-To: <4201195B.6000203@talisys.com> To: William Yu Date: Wed, 2 Feb 2005 13:35:20 -0500 (EST) Cc: pgsql-performance@postgresql.org X-Mailer: ELM [version 2.4ME+ PL121 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/36 X-Sequence-Number: 10365 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? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073