X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A23D7D1E2AA for ; Tue, 23 Mar 2004 17:36:38 +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 89403-04 for ; Tue, 23 Mar 2004 13:36:35 -0400 (AST) Received: from fep02-mail.bloor.is.net.cable.rogers.com (fep02-mail.bloor.is.net.cable.rogers.com [66.185.86.72]) by svr1.postgresql.org (Postfix) with ESMTP id E97A5D1DC5D for ; Tue, 23 Mar 2004 13:36:33 -0400 (AST) Received: from phlogiston.dydns.org ([65.49.121.67]) by fep02-mail.bloor.is.net.cable.rogers.com (InterMail vM.5.01.05.12 201-253-122-126-112-20020820) with ESMTP id <20040323173533.BQHR289632.fep02-mail.bloor.is.net.cable.rogers.com@phlogiston.dydns.org> for ; Tue, 23 Mar 2004 12:35:33 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 664C23BE3; Tue, 23 Mar 2004 12:36:32 -0500 (EST) Date: Tue, 23 Mar 2004 12:36:32 -0500 From: Andrew Sullivan To: "'pgsql-performance@postgresql.org'" Subject: Re: [ADMIN] Benchmarking postgres on Solaris/Linux Message-ID: <20040323173632.GC14274@phlogiston.dyndns.org> Mail-Followup-To: "'pgsql-performance@postgresql.org'" References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.5.1+cvs20040105i X-Authentication-Info: Submitted using SMTP AUTH LOGIN at fep02-mail.bloor.is.net.cable.rogers.com from [65.49.121.67] using ID at Tue, 23 Mar 2004 12:35:33 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/315 X-Sequence-Number: 6171 On Mon, Mar 22, 2004 at 04:05:45PM -0800, Subbiah, Stalin wrote: > being the key performance booster for postgres. what is the preferred OS > for postgres deployment if given an option between linux and solaris. As One thing this very much depends on is what you're trying to do. Suns have a reputation for greater reliability. While my own experience with Sun hardware has been rather shy of sterling, I _can_ say that it stands head and shoulders above a lot of the x86 gear you can get. If you're planning to use Solaris on x86, don't bother. Solaris is a slow, bloated pig compared to Linux, at least when it comes to managing the largish number of processes that Postgres requires. If pure speed is what you're after, I have found that 2-way, 32 bit Linux on P-IIIs compares very favourably to 4 way 64 bit Ultra SPARC IIs. A -- Andrew Sullivan | ajs@crankycanuck.ca The fact that technology doesn't work is no bar to success in the marketplace. --Philip Greenspun