pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Greg Stark <gsstark@mit.edu>
To: Jeff <threshar@torgo.978.org>
Cc: Mitch Pirtle <mitch.pirtle@gmail.com>
Cc: performance pgsql <pgsql-performance@postgresql.org>
Subject: Re: Benchmark
Date: 11 Feb 2005 10:04:08 -0500
Message-ID: <873bw387fb.fsf@stark.xeocode.com> (raw)
In-Reply-To: <A509BF5A-7C2F-11D9-84A4-000D9366F0C4@torgo.978.org>
References: <20050210054910.76921.qmail@web50005.mail.yahoo.com>
	<A07E1E9E-7B66-11D9-84A4-000D9366F0C4@torgo.978.org>
	<330532b60502102122638d887@mail.gmail.com>
	<7414.1108103893@sss.pgh.pa.us>
	<330532b605021023043b34e03@mail.gmail.com>
	<A509BF5A-7C2F-11D9-84A4-000D9366F0C4@torgo.978.org>

Jeff <threshar@torgo.978.org> writes:

> After using oracle in the last few months..  I can see why they'd want to
> prevent those numbers.. Oracle really isn't that good.  I had been under the
> impression that it was holy smokes amazingly fast.  It just isn't.  At least,
> in my experience it isn't.  but that is another story.

Oracle's claim to performance comes not from tight coding and low overhead.
For that you use Mysql :)

Oracle's claim to performance comes from how you can throw it at a machine
with 4-16 processors and it really does get 4-16x as fast. Features like
partitioned tables, parallel query, materialized views, etc make it possible
to drive it further up the performance curve than Sybase/MSSQL or Postgres.

In terms of performance, Oracle is to Postgres as Postgres is to Mysql: More
complexity, more overhead, more layers of abstraction, but in the long run it
pays off when you need it. (Only without the user-friendliness of either
open-source softwares.)

-- 
greg




view thread (26+ messages)  latest in thread

Message-ID: <873bw387fb.fsf@stark.xeocode.com>
Permalink:  ../873bw387fb.fsf@stark.xeocode.com/
Also on:    postgresql.org/message-id/873bw387fb.fsf@stark.xeocode.com

 · 

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: gsstark@mit.edu, threshar@torgo.978.org, mitch.pirtle@gmail.com
  Subject: Re: Benchmark
  In-Reply-To: <873bw387fb.fsf@stark.xeocode.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