Unix Technical Forum

Performance of PostgreSQL and Oracle

This is a discussion on Performance of PostgreSQL and Oracle within the Pgsql Performance forums, part of the PostgreSQL category; --> Hello, I have seen some performance testing indicates that apparently the PostgreSQL 8 is faster in writing data while ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > Pgsql Performance

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-19-2008, 11:10 AM
lai yoke hman
 
Posts: n/a
Default Performance of PostgreSQL and Oracle


Hello,
I have seen some performance testing indicates that apparently the PostgreSQL 8 is faster in writing data while seems like Oracle 10g is better in reading data from database, can any one tell me why? Or is there anyone done performance benchmark on them before?
This is urgent.
Thanks.
__________________________________________________ _______________
Call friends with PC-to-PC calling for free!
http://get.live.com/messenger/overview

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-19-2008, 11:10 AM
Tom Lane
 
Posts: n/a
Default Re: Performance of PostgreSQL and Oracle

lai yoke hman <lllhman@hotmail.com> writes:
> I have seen some performance testing indicates that apparently the PostgreSQL 8 is faster in writing data while seems like Oracle 10g is better in reading data from database, can any one tell me why? Or is there anyone done performance benchmark on them before?


You won't find anything particularly definitive on this, because Oracle
forbids publishing benchmarks of their software.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-19-2008, 11:10 AM
Lew
 
Posts: n/a
Default Re: Performance of PostgreSQL and Oracle

Tom Lane wrote:
> Oracle forbids publishing benchmarks of their software.


Does anyone have a clue why Oracle forbids publication of benchmarks? Are
they embarrassed by the results?

Doesn't such a ban violate free speech rights in the U.S.? How can a company
get away with forbidding the publication of facts?

My personal opinion is that this makes Oracle a Bad Guy and a Minion of Evil.

--
Lew
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-19-2008, 11:10 AM
andy
 
Posts: n/a
Default Re: Performance of PostgreSQL and Oracle

Lew wrote:
> Tom Lane wrote:
>> Oracle forbids publishing benchmarks of their software.

>
> Does anyone have a clue why Oracle forbids publication of benchmarks?
> Are they embarrassed by the results?
>
> Doesn't such a ban violate free speech rights in the U.S.? How can a
> company get away with forbidding the publication of facts?
>
> My personal opinion is that this makes Oracle a Bad Guy and a Minion of
> Evil.
>


> "publication of facts"


I think you exactly described why they don't allow it. Its so easy to
do benchmarks wrong, with such drastically differing hardware, software,
etc, how can you publish a "factual benchmark"?

Oracle (and microsoft) are protecting themselves from messed up
benchmarks, they are not afraid of competition (well, Oracle isnt).

-Andy
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 04-19-2008, 11:10 AM
Lew
 
Posts: n/a
Default Re: Performance of PostgreSQL and Oracle

andy wrote:
> Lew wrote:
>> Tom Lane wrote:
>>> Oracle forbids publishing benchmarks of their software.

>>
>> Does anyone have a clue why Oracle forbids publication of benchmarks?
>> Are they embarrassed by the results?
>>
>> Doesn't such a ban violate free speech rights in the U.S.? How can a
>> company get away with forbidding the publication of facts?
>>
>> My personal opinion is that this makes Oracle a Bad Guy and a Minion
>> of Evil.
>>

>
> > "publication of facts"

>
> I think you exactly described why they don't allow it. Its so easy to
> do benchmarks wrong, with such drastically differing hardware, software,
> etc, how can you publish a "factual benchmark"?
>
> Oracle (and microsoft) are protecting themselves from messed up
> benchmarks, they are not afraid of competition (well, Oracle isnt).


While the validity of a particular benchmark may be questioned, the fact of
its results is still a fact.

Again, the issue isn't whether the facts are meaningful, but how they can get
away with suppressing them.

--
Lew
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 06:16 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com