Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] PostgreSQL Benchmarks

From: "Shridhar Daithankar<shridhar_daithankar(at)persistent(dot)co(dot)in>" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: <pgsql-hackers(at)postgresql(dot)org>
Cc: <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: [HACKERS] PostgreSQL Benchmarks
Date: 2003-02-12 06:14:54
Message-ID: 200302121144.54878.shridhar_daithankar@persistent.co.in (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackers
On Tuesday 11 Feb 2003 8:01 pm, Mario Weilguni wrote:
> >Hrm.  I just saw that the PHP ADODB guy just published a bunch of database
> >benchmarks.  It's fairly evident to me that benchmarking PostgreSQL on
> >Win32 isn't really fair:
> >
> >http://php.weblogs.com/oracle_mysql_performance
>
> And why is the highly advocated transaction capable MySQL 4 not tested?
> That's the problem, for every performance test they choose ISAM tables, and
> when transactions are mentioned it's said "MySQL has transactions". But why
> no benchmarks?

I did benchmark mysql/postgresql/oracle sometime back. Mysql with transaction 
is 90% as fast as postgresql. But it dies down with increased number of users 
no matter how much resources you throw at it.

Oracle is 130% of postgresql. This was postgresql 7.2.x series so things have 
changed for sure, but you got the idea, right?

 Shridhar

In response to

Responses

pgsql-hackers by date

Next:From: Shridhar Daithankar<shridhar_daithankar@persistent.co.in>Date: 2003-02-12 06:21:44
Subject: Re: Changing the default configuration (was Re: [pgsql-advocacy]
Previous:From: Tom LaneDate: 2003-02-12 05:51:22
Subject: Re: Projection while performing joins.

pgsql-advocacy by date

Next:From: Shridhar Daithankar<shridhar_daithankar@persistent.co.in>Date: 2003-02-12 06:21:44
Subject: Re: Changing the default configuration (was Re: [pgsql-advocacy]
Previous:From: Christopher Kings-LynneDate: 2003-02-12 05:35:38
Subject: Re: [HACKERS] PostgreSQL Tuning Results

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group