pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: 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 12:36:32 -0500
Message-ID: <20040323173632.GC14274@phlogiston.dyndns.org> (raw)
In-Reply-To: <F1F84A2E5F9EBD46A9BDB905EB5B103937BB@mxca1.netopia.com>
References: <F1F84A2E5F9EBD46A9BDB905EB5B103937BB@mxca1.netopia.com>

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



view thread (22+ messages)  latest in thread

Message-ID: <20040323173632.GC14274@phlogiston.dyndns.org>
Permalink:  ../20040323173632.GC14274@phlogiston.dyndns.org/
Also on:    postgresql.org/message-id/20040323173632.GC14274@phlogiston.dyndns.org

 · 

reply

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: ajs@crankycanuck.ca
  Subject: Re: [ADMIN] Benchmarking postgres on Solaris/Linux
  In-Reply-To: <20040323173632.GC14274@phlogiston.dyndns.org>

* 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