[Asterisk-Users] OT: Best DB

[David Filion]

Walt Reed wrote:

>On Thu, Mar 10, 2005 at 01:04:35AM -0700, Forrest W. Christian said:
>  
>
>>I understand that PostgreSql has also gotten faster than it used to be.
>>    
>>
>
>It's interesting. Just yesterday I was saying that we use both MySQL and
>Postgres here, and that we were probably going to move everything to
>postgres just to consolidate.
>
>Now one of our lead engineers has done some performance testing last
>night for our
>app and found MySQL to be 8 to 100 times faster for all but one of our
>operations (combination of ~80% reads, 20% writes on the InnoDB table
>type.) His testing basically increased the load until performance was
>unacceptable.
>
>This is with lots of optimizations on Postgres (the current DB for the
>app) and none on MySQL. Needless to say, we now need to re-evaluate our
>decision to move everything to Postgres.
>
>In the end, it all comes down to knowing exactly what features you need
>for your app, how your specific app performs on each DB, what you need
>for support, etc. As Forrest mentioned, write DB independant code and
>then you can easily choose the DB that is best for your app. 2 years for
>now, you may find a need to switch DB's.
>
>
>  
>

Out of curiosity, what version of PostgreSQL was used? 7.x, 8.x?  Also, 
was the test run on the same system?  I'm not looking to bash.  I'm just 
curious as we are in the same MySQL/PostgreSQL boat.

David