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

How does the performance compare using models mimicked from Oracle? Is
there any information anywhere on that?

Marek Lewczuk wrote:
> 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
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html



--
Barbara E. Lindsey,
COG RDC
Phone: (352) 392-5198 ext. 314     Fax: (352) 392-8162

----
CONFIDENTIALITY NOTICE: The information contained in this electronic
message is legally privileged and confidential and intended only for the
use of the individual(s) or entity(ies) named above.  If the reader of
this message is not the intended recipient, you are hereby notified that
any dissemination, distribution, or copying of this email or any of it's
components is strictly prohibited.  If you have received this email in
error, please contact the sender.
----