X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4F5CCD1B45A for ; Thu, 11 Dec 2003 21:00:24 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 11733-04 for ; Thu, 11 Dec 2003 16:59:54 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 2E7E5D1B456 for ; Thu, 11 Dec 2003 16:59:52 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id hBBKxobI038025 for ; Thu, 11 Dec 2003 20:59:51 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id hBBKo3Me037153 for pgsql-performance@postgresql.org; Thu, 11 Dec 2003 20:50:03 GMT From: William Yu X-Newsgroups: comp.databases.postgresql.performance Subject: Re: Hardware suggestions for Linux/PGSQL server Date: Thu, 11 Dec 2003 12:50:06 -0800 Organization: Hub.Org Networking Services Lines: 40 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5) Gecko/20031007 X-Accept-Language: en-us, en In-Reply-To: To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/185 X-Sequence-Number: 5045 Jeff Bohmer wrote: > We're willing to shell out extra bucks to get something that will > undoubtedly handle the projected peak load in 12 months with excellent > performance. But we're not familiar with PG's performance on Linux and > don't like to waste money. Properly tuned, PG on Linux runs really nice. A few people have mentioned the VM swapping algorithm on Linux is semi-dumb. I get around that problem by having a ton of memory and almost no swap. > I've been thinking of this (overkill? not enough?): > 2 Intel 32-bit CPUs > Lowest clock speed chip for the fastest available memory bus > 4 GB RAM (maybe we only need 3 GB to start with?) > SCSI RAID 1 for OS > For PostgreSQL data and logs ... > 15k rpm SCSI disks > RAID 5, 7 disks, 256MB battery-backed write cache > (Should we save $ and get a 4-disk RAID 10 array?) > > I wonder about the 32bit+bigmem vs. 64bit question. At what database > size will we need more than 4GB RAM? With 4GB of RAM, you're already running into bigmem. By default, Linux gives 2GB of address space to programs and 2GB to kernel. I usually see people quote 5%-15% penalty in general for using PAE versus a flat address space. I've seen simple MySQL benchmarks where 64-bit versions run 35%+ faster versus 32-bit+PAE but how that translates to PG, I dunno yet. > We'd like to always have enough RAM to cache the entire database. While > 64bit is in our long-term future, we're willing to stick with 32bit > Linux until 64bit Linux on Itanium/Opteron and 64bit PostgreSQL "settle > in" to proven production-quality. Well if this is the case, you probably should get an Opteron server *now* and just run 32-bit Linux on it until you're sure about the software. No point in buying a Xeon and then throwing the machine away in a year when you decide you need 64-bit for more speed.