[Asterisk-Users] OT: Best DB

[joachim]

 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:apollon at planewalk.net]
>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
>Asterisk-Users at lists.digium.com
>http://lists.digium.com/mailman/listinfo/asterisk-users
>To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 254 bytes
Desc: OpenPGP digital signature
Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20050315/ed0d2c08/signature.pgp