Re: PG performance comparison vs Oracle

["Mohan, Ross" <RMohan@xxxxxxxxxxx>]

Title: Message

Lee,

 

 

Terse pointers:

 

 

 

1) Some posted already in list. Although, it may have been "performance".

    This question might be better addressed there. YMMV.

 

2) Performance of _what_? Concurrent reads? Single user batch loads?

       DW application? Multitable updates?  "pure" OLTP? "pure" OLAP? 

 

       Finding out "Who is the winner?" requires that you first design a racecourse.

 

 

3) www.tpc.org  (for ideas; no decent PG or MySQL benchmarks I could find there

 

4) Performance is measured against hw, sw budget dollars and also against user

    perceptions. This would be part of the racecourse, IMHO.

 

5)  As a "rule", at extremes of largeness, nothing beats oracle.

 

 

Hope These Help a bit,

 

 

Ross

-----Original Message-----
From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Lee Wu
Sent: Tuesday, May 17, 2005 1:25 PM
To: pgsql-admin@xxxxxxxxxxxxxx
Subject: [ADMIN] PG performance comparison vs Oracle

Hi all,

 

Anyone has it or point to me the right direction?

 

Thanks,