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 CA8D7D1EC4A for ; Tue, 23 Mar 2004 18:40:45 +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 16896-10 for ; Tue, 23 Mar 2004 14:40:44 -0400 (AST) Received: from mxca1.netopia.com (host222.netopia.com [65.206.239.222]) by svr1.postgresql.org (Postfix) with ESMTP id 29AADD1EC43 for ; Tue, 23 Mar 2004 14:40:40 -0400 (AST) Received: by mxca1.netopia.com with Internet Mail Service (5.5.2657.72) id ; Tue, 23 Mar 2004 10:40:40 -0800 Message-ID: From: "Subbiah, Stalin" To: 'Andrew Sullivan' , "'pgsql-performance@postgresql.org'" Subject: Re: [ADMIN] Benchmarking postgres on Solaris/Linux Date: Tue, 23 Mar 2004 10:40:32 -0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain; charset="ISO-8859-1" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/317 X-Sequence-Number: 6173 We are looking into Sun V210 (2 x 1 GHz cpu, 2 gig ram, 5.8Os) vs. Dell 1750 (2 x 2.4 GHz xeon, 2 gig ram, RH3.0). database will mostly be write intensive and disks will be on raid 10. Wondering if 64bit 1 GHz to 32bit 2.4 GHz make a big difference here. Thanks! -----Original Message----- From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org]On Behalf Of Andrew Sullivan Sent: Tuesday, March 23, 2004 9:37 AM To: 'pgsql-performance@postgresql.org' Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)