Re: PG performance comparison vs Oracle - Mailing list pgsql-admin

From Mohan, Ross
Subject Re: PG performance comparison vs Oracle
Date
Msg-id CC74E7E10A8A054798B6611BD1FEF4D30625DAE0@vamail01.thexchange.com
Whole thread Raw
In response to PG performance comparison vs Oracle  ("Lee Wu" <Lwu@mxlogic.com>)
List pgsql-admin
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@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Lee Wu
Sent: Tuesday, May 17, 2005 1:25 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] PG performance comparison vs Oracle

Hi all,

 

Anyone has it or point to me the right direction?

 

Thanks,

 

 

pgsql-admin by date:

Previous
From: "Lee Wu"
Date:
Subject: PG performance comparison vs Oracle
Next
From: Pallav Kalva
Date:
Subject: SQL logging (log_min_duration_statement) not working properly