Re: PostgreSQL is much faster than MySQL, only when...

From: Marek Lewczuk <newsy(at)lewczuk(dot)com>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL is much faster than MySQL, only when...
Date: 2003-11-26 08:21:25
Message-ID: 3FC46285.3030804@lewczuk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general

Użytkownik Robert Treat napisał:
> On Tue, 2003-11-25 at 08:07, Marek Lewczuk wrote:
>
>
> Yes. I think the gist of your post was "out of the box postgresql
> performed like garbage compared to mysql, but then i spent some time
> tweaking and tuning, taking advantage of indexes, and now it performs so
> quickly that i am unable to make any changes within mysql to match
> postgresql's performance"
Exactly. But as I wrote before - tweaking and tuning wasn't so
important... You cannot use the same db structure in both databases -
even if you think that all indexes, keys are well for MySQL it could be
not sufficient for PostgreSQL. Many people use the same structure and
they see that PostgreSQL is slower... so I just wanted to tell them,
that it is necessary to re-check structure which will be used with PG.

>
> I'm curious as to what type of application you run and what first
> prompted you to switch to postgresql?
It's analysis system for automotive market. There are many complicated
querys, with many joins... PostgreSQL is much more flexible, more
powerful and more stable than MySQL. There are also many other features
which are just not available in MySQL...

>
> Robert Treat

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Baldur Norddahl 2003-11-26 08:36:13 Re: duplicate primary key entries?
Previous Message Tom Lane 2003-11-26 07:53:14 Re: TIMEZONE not working?

Browse pgsql-advocacy by date

  From Date Subject
Next Message Barbara Lindsey 2003-11-26 13:53:57 Re: PostgreSQL is much faster than MySQL, only when...
Previous Message Shridhar Daithankar 2003-11-26 06:13:41 Re: PostgreSQL is much faster than MySQL, only when...