[Asterisk-Users] OT: Best DB

[Giudice, Salvatore]

I have had MySQL databases running in excess of 2 terrabytes handling up
to 700,000 inserts/hour on an 8 cpu machine. Try doing that with
PostgreSQL. 

If you are just running SER or Asterisk, etc - you simply do not need
the increased feature set or the need to optimize postgreSQL.

As for the "production recommendation" you refer to, I would
respectufully disagree. If you are an enterprise comapny looking to
deploy an open-source DB, you will pick the one that has an established
support company to contract with. So, 'NO': postgreSQL is not
recommended for production environments. MYSQL AB provides enterprise
class support. PostgreSQL support consists of contracting with mom and
pop support shops, mailing lists, and irc. That simply will not be
acceptable for the enterprise user.

In the end, pick whichever one works for you with the least problems.
Maybe postgreSQL is easier for your people to support. Green pill or
blue pill, it's your choice...  

-----Original Message-----
From: Mohit Muthanna [mailto:mohit.muthanna at gmail.com] 
Sent: Thursday, March 10, 2005 8:06 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] OT: Best DB

On Thu, 10 Mar 2005 19:14:36 -0500, Giudice, Salvatore
<Salvatore.Giudice at fmr.com> wrote:
> I vote for MySQL. PostgreSQL is fine, but MySQL handles much better
> under extreme load. MySQL is also usually touted as being generally

I'd have to (respectfully) disagree with that... MySQL just cannot
handle high load or large datasets... it's inherent design does not
allow it to scale too well...

I lost countless hours trying to optimize disk / filesystem
distribution, SQL queries, kernel parameters etc. etc. to get MySQL to
_not crawl_. After many failed attempts, I switched to Postgres and
haven't looked back.

I personally believe there is a "right tool for the right job". MySQL
works great for small datasets and (relatively) lighter load. Infact,
it shines there. But don't expect it to perform as your database grows
in orders of magnitude.

Postgres is certainly a database that is "recommended" (IMHO) for
production environments. If you're a VoIP provider, and are trying to
provide a near "carrier-grade" service, postgres shines.

Moht.

-- 
Mohit Muthanna [mohit (at) muthanna (uhuh) com]
"There are 10 types of people. Those who understand binary, and those
who don't."
_______________________________________________
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