I don't think these two are very comparable. True, PgSQL is getting closer and closer to Oracle, but Oracle is still ahead, especially in how it handles objects, PL/SQL and relational logic. But, doesn't it matter to you whether you have to pay the license or not? pgSQL is an Open Source, Oracle is a lot of money... So, if there are no budget problems (means you spend no cent extra) go for Oracle, otherwise choose pgSQL as it is also very powerfull. -- Maxim Maletsky maxim@php.net "Manos Papagelis" <papaggel@csd.uoc.gr> wrote... : > Any kind of results are precious although I would prefer some official > benchmarks. > If I can give a hint I would say that I am mostly interested to Object > features of both and how well they do when transitive closure queries are > concerned (queries that combine many tables and relations - extended use of > unions etc...). > That's because of path expressions used in my queries. (e.g. where is > something that someone has created that has create something else and is > also find somwhere else ...blah blah blah) > > - Manos Papagelis > > "Maxim Maletsky" <maxim@php.net> wrote in message > 20021111134207.1DAE.MAXIM@php.net">news:20021111134207.1DAE.MAXIM@php.net... > > > > I can already say that Oracle is faster. But official benchmark I have > > never seen. Have you wondered aboout ACID test results for both? > > > > > > -- > > Maxim Maletsky > > maxim@php.net > > > > > > > > "Manos Papagelis" <papaggel@csd.uoc.gr> wrote... : > > > > > Hello to all, > > > > > > I have searched enough to find some official benchmarks about oracle and > > > postgresql but it seems that don't exist any (mostly because oracle > license > > > don't permit it). If someone has something in mind it would be very > helpful > > > to keep me informed. > > > I am stressly interested about official performance benchamarks of > Oracle > > > 9.1 vs Postgresql 7.2.*, however any older benchmark that can give a > sense > > > is welcomed. > > > > > > thanx in advance, > > > > > > - Manos Papagelis > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
