|From:||Marek Lewczuk <newsy(at)lewczuk(dot)com>|
|To:||Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>|
|Subject:||Re: PostgreSQL is much faster than MySQL, only when...|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
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
|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?|
|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...|