On 10-07-29 08:54 PM, Greg Smith wrote:
> Brad Nicholson wrote:
>> Postgres also had a reputation of being slow compared to MySQL.
>> This was due to a lot of really poor MySQL vs Postgres benchmarks
>> floating around in the early 2000's.
>
> I think more of those were fair than you're giving them credit for.
> For many common loads, up until PG 8.1 came out--November 8.1--MySQL
> really was faster. That was the release with the killer read
> scalability improvements, then 8.3 piled on again with all the
> write-heavy stuff too. MySQL 4 vs. PG 8.0? MySQL won that fair and
> square sometimes.
>
oh, btw - I'm talking about MySQL 3.x w/MyISAM vs Postgres 7.1/7.2 days.
By the time MySQL 4.0/PG 8.0 was around, I was long off MySQL.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.