jake at vapourforge
Mar 11, 2009, 7:18 PM
Post #1 of 1
(265 views)
Permalink
|
|
Re: Performance Comparison WAS Forced upgrade from 2.0 to 2.2
|
|
Josh Marshall wrote:
> Hi,
>
>
>> Has anybody compared the performance of dbmail when running on the 3
>> backends?
>>
>
> A while back I compared performance of dbmail with MySQL 5.0 and
> Postgres 8.1 (my installation was going to be too large for sqlite) and
> the performance differences are minimal.
>
> A lot of people get hung up on which database has a higher performance.
> There are many more factors that should influence your decision on which
> to choose, such as ease of recovery, high-availability and backup
> solutions.
>
> What I suggest is that you go for the RDBMS that you are more
> comfortable with administering, as a 1 or 2 % performance gain is not
> worth working on a database system you're less experienced with.
> Somewhere down the line you will have to do some kind of recovery.
>
> The MySQL vs Postgres debate is long from over and I'm just glad that
> dbmail gives us the choice.
>
> For those interested, I ended up going for MySQL 5.0 with two masters
> (but only one being used at a time, using ucarp to arbitrate a virtual
> IP address) and one slave I can start and stop to do backups on. The
> reason I chose MySQL was that I am more confident with it when in a
> pressured situation or when I'm half awake, working on it in the middle
> of the night.
>
> Regards,
> Josh.
>
> P.S. I'm not going to tell you which RDBMS was the faster of the two ;)
>
I'm not about to jump ship for anything less than 15-20% performance ;->
mysql all the way lol
|
