From: Subbiah, Stalin <SSubbiah@netopia.com>
To: Andrew Sullivan <ajs@crankycanuck.ca>
To: 'pgsql-performance@postgresql.org' <pgsql-performance@postgresql.org>
Subject: Re: [ADMIN] Benchmarking postgres on Solaris/Linux
Date: Tue, 23 Mar 2004 10:40:32 -0800
Message-ID: <F1F84A2E5F9EBD46A9BDB905EB5B103937C1@mxca1.netopia.com> (raw)
We are looking into Sun V210 (2 x 1 GHz cpu, 2 gig ram, 5.8Os) vs. Dell 1750
(2 x 2.4 GHz xeon, 2 gig ram, RH3.0). database will mostly be
write intensive and disks will be on raid 10. Wondering if 64bit 1 GHz to
32bit 2.4 GHz make a big difference here.
Thanks!
-----Original Message-----
From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-owner@postgresql.org]On Behalf Of Andrew
Sullivan
Sent: Tuesday, March 23, 2004 9:37 AM
To: 'pgsql-performance@postgresql.org'
Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux
On Mon, Mar 22, 2004 at 04:05:45PM -0800, Subbiah, Stalin wrote:
> being the key performance booster for postgres. what is the preferred OS
> for postgres deployment if given an option between linux and solaris. As
One thing this very much depends on is what you're trying to do.
Suns have a reputation for greater reliability. While my own
experience with Sun hardware has been rather shy of sterling, I _can_
say that it stands head and shoulders above a lot of the x86 gear you
can get.
If you're planning to use Solaris on x86, don't bother. Solaris is a
slow, bloated pig compared to Linux, at least when it comes to
managing the largish number of processes that Postgres requires.
If pure speed is what you're after, I have found that 2-way, 32 bit
Linux on P-IIIs compares very favourably to 4 way 64 bit Ultra SPARC
IIs.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
The fact that technology doesn't work is no bar to success in the
marketplace.
--Philip Greenspun
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: SSubbiah@netopia.com, ajs@crankycanuck.ca
Subject: Re: [ADMIN] Benchmarking postgres on Solaris/Linux
In-Reply-To: <F1F84A2E5F9EBD46A9BDB905EB5B103937C1@mxca1.netopia.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