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