[Asterisk-Users] OT: Best DB

[Linterra]

On Wed, 9 Mar 2005 15:43:46 -0500, list at ipmotel.net <list at ipmotel.net> wrote:
> For some reason I didn't think PostgreSQL was for mission critical apps.  I
> don't think I have any reasoning behind it, just didn't think it was
> "hardcore"...sounds like i might be wrong...i'll have to look into it more.
> 
> Open source advantages are obvious, but aside from licensing and cost
> factors, I believe speed, security, and stability are going to be the key
> factors for us, whether open source or not.
> 
> Thanks,
> 
> Jon
> 
> 
> ----- Original Message -----
> From: "Tzafrir Cohen" <tzafrir at cohens.org.il>
> To: <asterisk-users at lists.digium.com>
> Sent: Wednesday, March 09, 2005 3:18 PM
> Subject: Re: [Asterisk-Users] OT: Best DB
> 
> > On Wed, Mar 09, 2005 at 02:50:47PM -0500, list at ipmotel.net wrote:
> >> I know this is a bit off topic but we are using Asterisk  :)
> >>
> >> Since this list is full of tech gurus w/ all different sorts of
> >> backgrounds, I thought I would get the best opinions here.
> >>
> >> We have several different switches and other telecom equipment at our
> >> facilities which all have their own proprietary cdr platforms, which are
> >> rather limited. The company I work for is looking to develop their own
> >> in-house billing system that would combine cdr from all platforms and
> >> bring
> >> it into one big db, so we can do whatever we like w/ the data...billing,
> >> invoices, reports, asr...etc...
> >>
> >> So my question is this....
> >>
> >> What's the most stable, fastest & reliable database for this project?
> >> Call
> >> volume is about 8 to 10 million minutes per month, and we want to have 12
> >> months of cdr available at any given time, anything older can be archived
> >> on tape.
> >> So what's the best db...oracle, ms sql, informix, mysql or something
> >> else?
> >
> > I'm not saying that it is the best or anything, I'm just wondering why
> > it is ommited:
> >
> >  PostgreSQL
> >
> > Comes well-integrated with your linux distro of choice, just like MySQL.
> > Well-supoprted by Asterisk.
> >
> > I don't know exactly what type of application you'll have but generally
> > it performs better than MySQL with more complex logic.
> >
> > Both MySQL and PostgreSQL have the obvious atvantage of being free of
> > licensing headaches. E.g.: you'll never loose a week of development
> > because the server licenses are delayed and you'll never have to change
> > your design because client licenses are expensive.
> >
> > --
> > Tzafrir Cohen         | New signature for new address and  |  VIM is
> > http://tzafrir.org.il | new homepage                       | a Mutt's
> > tzafrir at cohens.org.il |                                    |  best
> > ICQ# 16849755         | Space reserved for other protocols | friend
> > _______________________________________________
> > 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
> > ---
> > [This E-mail scanned for viruses by Declude Virus]
> >
> >
> 
> ---
> [This E-mail scanned for viruses by Declude Virus]
> 
> _______________________________________________
> 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
> 

PostgreSQL 8.0 would be my recommendation.  The new features that were
put into production with this latest release are impressive. 
Replication, point-in-time recovery, transactions and many other
features make this database outshine mySQL (even with innoDB)

I have several database applications which each average over two
million queries a day.  mySQL works just fine except it degrades to
full-tablespace scans too quickly, whereas postgreSQL does a much
better job of optimizing more complicated queries.  Even when
postgreSQL resorts to a full table scan, it still seems to return the
results quite a bit faster than mySQL.  Everything else is the same
(same OS, computer, processor, RAM, hard-drive, etc).

Anything new that my team produces will definately be running on postgreSQL.

Just my $.02.