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 38FD18B9C1E for ; Wed, 2 Feb 2005 04:25:27 +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 50162-08 for ; Wed, 2 Feb 2005 04:25:17 +0000 (GMT) Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id BCD5D8B9BD8 for ; Wed, 2 Feb 2005 04:25:16 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 3DE613198C; Wed, 2 Feb 2005 05:25:15 +0100 (MET) From: William Yu X-Newsgroups: pgsql.performance Subject: Re: High end server and storage for a PostgreSQL OLTP system Date: Tue, 01 Feb 2005 20:25:09 -0800 Organization: Hub.Org Networking Services Lines: 29 Message-ID: References: <41FE97FC.3060106@streppone.it> <20050201045645.GC32356@decibel.org> <41FF2337.7070809@streppone.it> <20050201112727.GF32356@decibel.org> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en In-Reply-To: <20050201112727.GF32356@decibel.org> To: pgsql-performance@postgresql.org 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/26 X-Sequence-Number: 10355 Jim C. Nasby wrote: > On Tue, Feb 01, 2005 at 07:35:35AM +0100, Cosimo Streppone wrote: > >>>You might look at Opteron's, which theoretically have a higher data >>>bandwidth. If you're doing anything data intensive, like a sort in >>>memory, this could make a difference. >> >>Would Opteron systems need 64-bit postgresql (and os, gcc, ...) >>build to have that advantage? > > > Well, that would give you the most benefit, but the memory bandwidth is > still greater than on a Xeon. There's really no issue with 64 bit if > you're using open source software; it all compiles for 64 bits and > you're good to go. http://stats.distributed.net runs on a dual opteron > box running FreeBSD and I've had no issues. 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.)