Re: PostgreSQL vs. MySQL: fight

Alvaro Herrera wrote:
> Lukas Kahwe Smith wrote:
>> Greg Smith wrote:
>>
>>> I tried to keep the text punchy by hitting the important points and
>>> leaning heavily on references in lieu of trying to include all the details
>>> in the document. I feel like the "Join Complexity" section is still a
>>> little lightweight and could use more input. I'm happy with the rest, but
>>> they could certainly benefit from some review by others. Josh in
>>> particular should take a look at how I covered the recent Sun benchmark
>>> results to make sure I'm fairly characterizing those.
>> One major difference of MySQL is that it provides SQL hints. This
>> alleviates the issues with slow complex joins, but is obviously a dangerous
>> tool if not used wisely. That being said, it can often be a very quick fix,
>> whereas in PostgreSQL you do not have such tools if you ever need them.
>
> Which probably partly explains our optimizer is so much better (the
> other part being that Tom is so damn smart).

Heh .. oh btw .. MySQL does not provide any access to the stats tables
like PostgreSQL does.

regards,
Lukas