Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id BE6F49FA111 for ; Mon, 25 Sep 2006 13:24:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 16372-04 for ; Mon, 25 Sep 2006 13:24:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 88BBE9FB318 for ; Mon, 25 Sep 2006 13:24:41 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Mon, 25 Sep 2006 16:24:39 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 25 Sep 2006 11:24:38 -0500 Subject: Re: best OS and HW for postgreSQL From: Scott Marlowe To: "Joshua D. Drake" Cc: Jim Nasby , Raul Retamozo , pgsql-admin@postgresql.org In-Reply-To: <4517F594.7000404@commandprompt.com> References: <7C5352EF-F3CB-4939-AD50-3E4524EDE3D8@enterprisedb.com> <1159195472.4033.6.camel@localhost.localdomain> <4517F594.7000404@commandprompt.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1159201478.26848.15.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 25 Sep 2006 11:24:38 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.081 tagged_above=0 required=5 tests=AWL, SPF_PASS, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200609/266 X-Sequence-Number: 23180 On Mon, 2006-09-25 at 10:28, Joshua D. Drake wrote: > Scott Marlowe wrote: > > On Sun, 2006-09-24 at 20:18 -0400, Jim Nasby wrote: > >> On Sep 22, 2006, at 6:12 PM, Raul Retamozo wrote: > >>> Hi everyone on the list. I want to know what is the reccommended OS > >>> to work with PostgreSQL , on specific with PostGIS: > >>> One more question is about what HW (server) offers the best > >>> performance for a Web Map Server bases on PostGIS and mapserver. > >> In general, you're probably best off running whatever OS you're most > >> comfortable with. > > > > I'd amend that to say whatever flavor of unix you're most comfortable > > with. > > Well honestly that isn't true either. Linux is faster then Solaris for > PostgreSQL in a lot of cases. In reality... I would say the best OS for > PostgreSQL is either Linux or FreeBSD. Win32 is great for a small > installation or development. > > The Solaris argument may change for 8.2, I don't know. Seems the same thing is true for other databases (the one that cannot be named comes to mind). > > > > Much more important is your disk subsystem. Using an Areca RAID > > controller with battery backed cache and a half dozen or more hard > > drives is often the real winner for performance. > > Yes, LSI and 3Ware are also good. I am particularly fond of LSI but > Areca has PCI-Express cards which means you can put them on cheaper > motherboards :) I too have a soft spot in my heart for LSI MegaRAID cards. They've never treated me badly.