Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 731A09FB2A2 for ; Mon, 25 Sep 2006 03:36:47 -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 04064-02 for ; Mon, 25 Sep 2006 06:36:43 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id D24D09FB293 for ; Mon, 25 Sep 2006 03:36:43 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from webmail.enterprisedb.com (webmail.enterprisedb.com [63.246.7.176]) by svr4.postgresql.org (Postfix) with ESMTP id 0BCD25AF99E for ; Mon, 25 Sep 2006 06:36:43 +0000 (GMT) Received: from [192.168.0.59] (unknown [12.161.221.132]) by webmail.enterprisedb.com (Postfix) with ESMTP id DE61AA24DFC; Mon, 25 Sep 2006 01:11:39 -0500 (CDT) In-Reply-To: References: Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <7C5352EF-F3CB-4939-AD50-3E4524EDE3D8@enterprisedb.com> Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: 7bit From: Jim Nasby Subject: Re: best OS and HW for postgreSQL Date: Sun, 24 Sep 2006 20:18:06 -0400 To: Raul Retamozo X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.478 tagged_above=0 required=5 tests=DATE_IN_PAST_03_06 X-Spam-Level: X-Archive-Number: 200609/259 X-Sequence-Number: 23173 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. 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. -- Jim Nasby jimn@enterprisedb.com EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)