pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Frank Wiles <frank@wiles.org>
To: Randolf Richardson <rr@8x.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL vs. Oracle vs. Microsoft
Date: Sun, 9 Jan 2005 18:04:52 -0600
Message-ID: <20050109180452.03723387.frank@wiles.org> (raw)
In-Reply-To: <Xns95D671D321E39rr8xca@200.46.204.72>
References: <Xns95D671D321E39rr8xca@200.46.204.72>

On Thu, 6 Jan 2005 19:01:38 +0000 (UTC)
Randolf Richardson <rr@8x.ca> wrote:

>     	I'm looking for recent performance statistics on PostgreSQL vs.
>     	Oracle 
> vs. Microsoft SQL Server.  Recently someone has been trying to
> convince my client to switch from SyBASE to Microsoft SQL Server (they
> originally wanted to go with Oracle but have since fallen in love with
> Microsoft).  All this time I've been recommending PostgreSQL for cost
> and stability (my own testing has shown it to be better at handling
> abnormal shutdowns and using fewer system resources) in addition to
> true cross-platform compatibility.
> 
>     	If I can show my client some statistics that PostgreSQL
>     	outperforms 
> these (I'm more concerned about it beating Oracle because I know that 
> Microsoft's stuff is always slower, but I need the information anyway
> to protect my client from falling victim to a 'sales job'), then
> PostgreSQL will be the solution of choice as the client has always
> believed that they need a high-performance solution.
> 
>     	I've already convinced them on the usual price, cross-platform 
> compatibility, open source, long history, etc. points, and I've been
> assured that if the performance is the same or better than Oracle's
> and Microsoft's solutions that PostgreSQL is what they'll choose.

  While this doesn't exactly answer your question, I use this little
  tidbit of information when "selling" people on PostgreSQL.  PostgreSQL
  was chosen over Oracle as the database to handle all of the .org TLDs
  information.  While I don't believe the company that won was chosen 
  solely because they used PostgreSQL vs Oracle ( vs anything else ),
  it does go to show that PostgreSQL can be used in a large scale
  environment.  

  Another tidbit you can use in this particular case: I was involved
  in moving www.ljworld.com, www.lawrence.com, and www.kusports.com from
  a Sybase backend to a PostgreSQL backend back in 2000-2001.  We got
  roughly a 200% speed improvement at that time and PostgreSQL has only
  improved since then.  I would be more than happy to elaborate on this
  migration off list if you would like.  kusports.com gets a TON of 
  hits especially during "March Madness" and PostgreSQL has never been
  an issue in the performance of the site. 

 ---------------------------------
   Frank Wiles <frank@wiles.org>
   http://www.wiles.org
 ---------------------------------




view thread (46+ messages)  latest in thread

Message-ID: <20050109180452.03723387.frank@wiles.org>
Permalink:  ../20050109180452.03723387.frank@wiles.org/
Also on:    postgresql.org/message-id/20050109180452.03723387.frank@wiles.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: frank@wiles.org, rr@8x.ca
  Subject: Re: PostgreSQL vs. Oracle vs. Microsoft
  In-Reply-To: <20050109180452.03723387.frank@wiles.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