From my personal experience, pgsql outperforms mysql when using tables
with over 30.000.000 records.
For small tables mysql is faster, but also locks up more when 1 thread
takes a long time.
We used mysql for years, then had to move on to pgsql and never turned
back. (we still have some 300 queries / second databases running on
mysql for historic reasons.)
It all depends on what features you need, most of the time both will do
fine, you just need to learn how to optimize your queries and your
database config.
Oh and SER can also use pgsql so its not needed to stick to mysql, thats
not a good reason and pgsql has no problems with 700.000 inserts an hour.
Zoa.
Giudice, Salvatore wrote:
I vote for MySQL. PostgreSQL is fine, but MySQL handles much better
under extreme load. MySQL is also usually touted as being generally
faster for the average application. However on the flip side, PostgreSQL
supports more features than MySQL, such as subqueries, more
functionality in stored procedures, cursors, and views. In terms of
support, you can get support from MySQL directly, while PostgreSQL means
you have to turn to mailing lists. It's really your preference depending
on the size of your organization and how skilled your staff is in
supporting open source in house. Lastly, be aware that MySQL is
distributed under the GNU license with a commercial rider for derivative
works and PostgreSQl is a BSD license.
Also if you are looking at SER as part of your infrastructure, I would
recommend you stick with MySQL.
Cheers... SG
-----Original Message-----
From: Apollon Koutlides [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 10, 2005 2:41 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] OT: Best DB
Richard Cook wrote:
We use PostgreSQL in house. It performs wonderfully and cross-platform
drivers (ODBC, .NET) are way further along than MySQL. We switched
from
MySQL a couple of months ago and have never been happier.
We use Postgres exclusively too (12 databses, several of them with
several millions of records, both OLAP and OLTP roles). We switched from
informix 4 years ago and we also subscribe to the "never been happier"
point of view.
_______________________________________________
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
signature.asc
Description: OpenPGP digital signature
_______________________________________________
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
