Re: PostgreSQL vs. MySQL

From: "Bjoern Metzdorf" <bm(at)turtle-entertainment(dot)de>
To: "Brian Tarbox" <btarbox(at)theworld(dot)com>, "Postgresql Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: PostgreSQL vs. MySQL
Date: 2003-07-04 22:24:18
Message-ID: 032f01c3427b$031479b0$0564a8c0@shock
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general pgsql-hackers pgsql-performance

>> Afaik, your original posting said postgresql was 3 times slower than
>> mysql and that you are going to leave this list now. This implied
>> that you have made your decision between postgresql and mysql,
>> taking mysql because it is faster.
>
> Well, that shows what you get for making implications. The client is
> sticking with postgres and we are coding around the issue in other
> ways.

As many other guys here pointed out, there are numerous ways to tune
postgresql for maximum performance. If you are willing to share more
information about your particular project, we might be able to help you out
and optimize your application, without the need to code around the issue as
much as you may be doing right now.
Even if it is not possible for you to share enough information, there are a
lot of places where you can read about performance tuning (if not in the
docs then in the archives).

>> If I was your client and gave you the task to choose a suitable
>> database for my application and you evaluated suitable databases
>> this way, then something is seriously wrong with your work.
>>
> Glad to see you're not getting personal with this. Ad hominin attacks
> are for folks with no better answers.

Yep, you're right. Sorry for that, I didn't mean to get personal. I was
somehow irritated that you come here, post your database comparison and want
to leave right afterwards, without going into detail (what should be the
case normally).

Again our offer: Post (possibly obfuscated) schema information, and we will
certainly be able to help you with performance tuning.

Regards,
Bjoern

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Grega Bremec 2003-07-05 16:39:37 Re: PostgreSQL vs. MySQL
Previous Message Tim Conrad 2003-07-04 21:28:32 Re: PostgreSQL vs. MySQL

Browse pgsql-general by date

  From Date Subject
Next Message Dan Langille 2003-07-05 00:58:17 Re: Are we backwards on the sign of timezones?
Previous Message Alvaro Herrera 2003-07-04 21:54:08 Re: Datatypes and performance

Browse pgsql-hackers by date

  From Date Subject
Next Message David Blasby 2003-07-04 23:00:40 Re: '_' < '5' -- different answer on 7.2 and 7.3
Previous Message Tim Conrad 2003-07-04 21:28:32 Re: PostgreSQL vs. MySQL

Browse pgsql-performance by date

  From Date Subject
Next Message Grega Bremec 2003-07-05 16:39:37 Re: PostgreSQL vs. MySQL
Previous Message Tom Lane 2003-07-04 21:47:27 Re: Strange result: UNIX vs. TCP/IP sockets