X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EF124476353 for ; Wed, 9 Apr 2003 12:28:30 -0400 (EDT) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id 2119F47634E for ; Wed, 9 Apr 2003 12:28:30 -0400 (EDT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 2953027; Wed, 09 Apr 2003 09:28:29 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: "Matthew Nuzum" , "Pgsql-Performance" Subject: Re: choosing the right platform Date: Wed, 9 Apr 2003 09:28:01 -0700 User-Agent: KMail/1.4.3 References: <003101c2fe49$86a9fc30$6900a8c0@mattspc> In-Reply-To: <003101c2fe49$86a9fc30$6900a8c0@mattspc> MIME-Version: 1.0 Message-Id: <200304090928.01767.josh@agliodbs.com> Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-32.4 required=5.0 tests=BAYES_01,IN_REP_TO,QUOTED_EMAIL_TEXT,REFERENCES, REPLY_WITH_QUOTES,USER_AGENT_KMAIL autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/88 X-Sequence-Number: 1594 Matthew, > Currently I'm most experienced in Linux, especially RedHat. I'm > "certified" on SCO Openserver (5.x) and I've played with Irix, OSF/1 (I > don't think it's called that anymore), Free BSD (3.x) and Solaris (2.x).= =20 > I'm most > comfortable with Linux, but I'm willing to use a different platform if it > will be beneficial. I've heard that Solaris on the Sparc platform is > capable of addressing larger amounts of RAM than Linux on Intel does. I > don't know if that's true or if that has bearing, but I'd like to hear yo= ur > opinions. Please browse through the list archives. We have numerous posts on the=20 platform subject. In fact, several of us are trying to put together a=20 PostgreSQL performance test package to answer this question difinitively=20 rather than anecdotally. Anecdotal responses are: Solaris is *bad* for PostgreSQL, due to a high per-process overhead.=20=20 Universal opinion on this list has been that Solaris is optimized for=20 multi-threaded applications, not multi-process applications, and postgres i= s=20 the latter. *BSD has a *lot* of fans on the PGSQL lists, many of whom claim significant= ly=20 better performance than Linux, mostly due to better filesystem I/O. Linux is used heavily by a lot of PostgreSQL users. I have yet to see anyo= ne=20 provide actual Linux vs. BSD statistics, though ... something we hope to do. Nobody has come forward and reported on PostgreSQL on SCO Unix. Irix is widely regarded as a "dead" platform, though PostgreSQL does run on= it=20 ... Good luck, and keep watching this space! --=20 Josh Berkus Aglio Database Solutions San Francisco