RE: [PHP-DB] Are there any Oracle vs Postgresql official benchmarks
So install 4.0.1 and turn on in-memory query results cache! :-) Peter On Mon, 11 Nov 2002, John W. Holmes wrote: > Interesting Quote: > > MySQL's great performance was due mostly to our use of an in-memory > query results cache that is new in MySQL 4.0.1. When we tested without > this cache, MySQL's performance fell by two-thirds. > > ---John Holmes... > > > -Original Message- > > From: Peter Beckman [mailto:beckman@;purplecow.com] > > Sent: Monday, November 11, 2002 12:29 PM > > To: Maxim Maletsky > > Cc: Manos Papagelis; [EMAIL PROTECTED] > > Subject: Re: [PHP-DB] Are there any Oracle vs Postgresql official > > benchmarks > > > > EWeek compared MySQL to Oracle 9i and a few others, and they both came > out > > on top. > > > > http://www.eweek.com/article2/0,3959,293,00.asp > > > http://www.eweek.com/slideshow/0,3670,p=1&s=1590&a=23120&po=1&i=1,00.asp > > > http://www.eweek.com/slideshow/0,3670,p=1&s=1590&a=23120&po=2&i=1,00.asp > > > > On Mon, 11 Nov 2002, Maxim Maletsky wrote: > > > > > > > > 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 > > > [EMAIL PROTECTED] > > > > > > > > > > > > "Manos Papagelis" <[EMAIL PROTECTED]> 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 > > > > > > > > > -- > > - > > Peter BeckmanSystems Engineer, Fairfax Cable Access > > Corporation > > [EMAIL PROTECTED] > > http://www.purplecow.com/ > > > > -- > > - > > > > > > -- > > 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 > --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Are there any Oracle vs Postgresql official benchmarks
Interesting Quote: MySQL's great performance was due mostly to our use of an in-memory query results cache that is new in MySQL 4.0.1. When we tested without this cache, MySQL's performance fell by two-thirds. ---John Holmes... > -Original Message- > From: Peter Beckman [mailto:beckman@;purplecow.com] > Sent: Monday, November 11, 2002 12:29 PM > To: Maxim Maletsky > Cc: Manos Papagelis; [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Are there any Oracle vs Postgresql official > benchmarks > > EWeek compared MySQL to Oracle 9i and a few others, and they both came out > on top. > > http://www.eweek.com/article2/0,3959,293,00.asp > http://www.eweek.com/slideshow/0,3670,p=1&s=1590&a=23120&po=1&i=1,00.asp > http://www.eweek.com/slideshow/0,3670,p=1&s=1590&a=23120&po=2&i=1,00.asp > > On Mon, 11 Nov 2002, Maxim Maletsky wrote: > > > > > 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 > > [EMAIL PROTECTED] > > > > > > > > "Manos Papagelis" <[EMAIL PROTECTED]> 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 > > > > -- > - > Peter BeckmanSystems Engineer, Fairfax Cable Access > Corporation > [EMAIL PROTECTED] > http://www.purplecow.com/ > -- > - > > > -- > 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
Re: [PHP-DB] Are there any Oracle vs Postgresql official benchmarks
EWeek compared MySQL to Oracle 9i and a few others, and they both came out on top. http://www.eweek.com/article2/0,3959,293,00.asp http://www.eweek.com/slideshow/0,3670,p=1&s=1590&a=23120&po=1&i=1,00.asp http://www.eweek.com/slideshow/0,3670,p=1&s=1590&a=23120&po=2&i=1,00.asp On Mon, 11 Nov 2002, Maxim Maletsky wrote: > > 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 > [EMAIL PROTECTED] > > > > "Manos Papagelis" <[EMAIL PROTECTED]> 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 > --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Are there any Oracle vs Postgresql official benchmarks
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 [EMAIL PROTECTED] "Manos Papagelis" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> wrote in message > news:2002134207.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 > > [EMAIL PROTECTED] > > > > > > > > "Manos Papagelis" <[EMAIL PROTECTED]> 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
Re: [PHP-DB] Are there any Oracle vs Postgresql official benchmarks
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" <[EMAIL PROTECTED]> wrote in message news:2002134207.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 > [EMAIL PROTECTED] > > > > "Manos Papagelis" <[EMAIL PROTECTED]> 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
Re: [PHP-DB] Are there any Oracle vs Postgresql official benchmarks
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 [EMAIL PROTECTED] "Manos Papagelis" <[EMAIL PROTECTED]> 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