Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 447279FB215 for ; Mon, 25 Sep 2006 11:45:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 92502-09 for ; Mon, 25 Sep 2006 14:45:33 +0000 (UTC) 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 92DDB9FB212 for ; Mon, 25 Sep 2006 11:45:33 -0300 (ADT) Received: from 10.10.1.93 ([10.10.1.93]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Mon, 25 Sep 2006 14:45:31 +0000 Received: from localhost.localdomain by mail.g2switchworks.com; 25 Sep 2006 09:44:34 -0500 Subject: Re: best OS and HW for postgreSQL From: Scott Marlowe To: Jim Nasby Cc: Raul Retamozo , pgsql-admin@postgresql.org In-Reply-To: <7C5352EF-F3CB-4939-AD50-3E4524EDE3D8@enterprisedb.com> References: <7C5352EF-F3CB-4939-AD50-3E4524EDE3D8@enterprisedb.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Mon, 25 Sep 2006 09:44:32 -0500 Message-Id: <1159195472.4033.6.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.2 (2.2.2-5) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=SPF_PASS, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200609/261 X-Sequence-Number: 23175 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. Many tools aren't quite there on the windows version, and it still seems to have more issues with performance and scaling than the unix flavors of PostgreSQL. > As for hardware, until recently, AMD was the un-disputed king when it > came to running PostgreSQL (and databases in general). But the newer > Intel CPUs seem to have surpassed the Opteron. I believe there's a > tweakers.net article floating around that did some performance > testing with the new CPUs. I think AMD still has an advantage for CPU >=4 due to the hypertransport (not cores, actual CPU sockets >=4) Since most loads are easily handled by two dual core CPUs nowadays, AMD and Intel are about even. 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.