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
_______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
