From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Jim Nasby <jimn@enterprisedb.com>
Cc: Raul Retamozo <revelar@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: best OS and HW for postgreSQL
Date: Mon, 25 Sep 2006 09:44:32 -0500
Message-ID: <1159195472.4033.6.camel@localhost.localdomain> (raw)
In-Reply-To: <7C5352EF-F3CB-4939-AD50-3E4524EDE3D8@enterprisedb.com>
References: <BAY124-W44B8714E23FF6A77445B50B4210@phx.gbl>
<7C5352EF-F3CB-4939-AD50-3E4524EDE3D8@enterprisedb.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: smarlowe@g2switchworks.com, jimn@enterprisedb.com, revelar@hotmail.com
Subject: Re: best OS and HW for postgreSQL
In-Reply-To: <1159195472.4033.6.camel@localhost.localdomain>
References: <BAY124-W44B8714E23FF6A77445B50B4210@phx.gbl> <7C5352EF-F3CB-4939-AD50-3E4524EDE3D8@enterprisedb.com> <1159195472.4033.6.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox