From: Josh Berkus <josh@agliodbs.com>
To: Matthew Nuzum <cobalt@bearfruit.org>
To: Pgsql-Performance <pgsql-performance@postgresql.org>
Subject: Re: choosing the right platform
Date: Wed, 9 Apr 2003 09:28:01 -0700
Message-ID: <200304090928.01767.josh@agliodbs.com> (raw)
In-Reply-To: <003101c2fe49$86a9fc30$6900a8c0@mattspc>
References: <003101c2fe49$86a9fc30$6900a8c0@mattspc>
Matthew,
> Currently I'm most experienced in Linux, especially RedHat. I'm
> "certified" on SCO Openserver (5.x) and I've played with Irix, OSF/1 (I
> don't think it's called that anymore), Free BSD (3.x) and Solaris (2.x).
> I'm most
> comfortable with Linux, but I'm willing to use a different platform if it
> will be beneficial. I've heard that Solaris on the Sparc platform is
> capable of addressing larger amounts of RAM than Linux on Intel does. I
> don't know if that's true or if that has bearing, but I'd like to hear your
> opinions.
Please browse through the list archives. We have numerous posts on the
platform subject. In fact, several of us are trying to put together a
PostgreSQL performance test package to answer this question difinitively
rather than anecdotally.
Anecdotal responses are:
Solaris is *bad* for PostgreSQL, due to a high per-process overhead.
Universal opinion on this list has been that Solaris is optimized for
multi-threaded applications, not multi-process applications, and postgres is
the latter.
*BSD has a *lot* of fans on the PGSQL lists, many of whom claim significantly
better performance than Linux, mostly due to better filesystem I/O.
Linux is used heavily by a lot of PostgreSQL users. I have yet to see anyone
provide actual Linux vs. BSD statistics, though ... something we hope to do.
Nobody has come forward and reported on PostgreSQL on SCO Unix.
Irix is widely regarded as a "dead" platform, though PostgreSQL does run on it
...
Good luck, and keep watching this space!
--
Josh Berkus
Aglio Database Solutions
San Francisco
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-performance@postgresql.org
Cc: josh@agliodbs.com, cobalt@bearfruit.org
Subject: Re: choosing the right platform
In-Reply-To: <200304090928.01767.josh@agliodbs.com>
References: <003101c2fe49$86a9fc30$6900a8c0@mattspc> <200304090928.01767.josh@agliodbs.com>
* 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