Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: MySQL vs. PgSQL performance - has anyone benchmarked them?
PostPosted: 2011-05-02 22:27 
Normal user
User avatar

Joined: 2010-03-30 19:30
Posts: 232
Location: uʍop ǝpısdn
I will be reinstalling hMailServer soon, which means I can have a go at a new database. Has anyone benchmarked hMailServer with MySQL vs. PgSQL? I know that Postgres certainly has a better license, and has been known for better performance in some situations, but I have not used it before, and its administrative tools are a little less polished. (phpPgAdmin vs. phpMyAdmin springs to mind.)

What do you guys say?

_________________
hMailServer 5.4-B1929 Alpha on Server 2008 R2 VM
MySQL 5.5.15, IIS 7.5, PHP 5.3.6 via FastCGI, RoundCube 0.5.4
XenServer 6.0 on 2x HP DL380 G5 16GB RAM each
VM data on Thecus 1U4200XXXR iSCSI SAN


Top
 Profile  
 
 Post subject: Re: MySQL vs. PgSQL performance - has anyone benchmarked the
PostPosted: 2011-05-02 22:41 
Site Admin
User avatar

Joined: 2005-07-29 16:18
Posts: 13792
Location: UK
http://mariadb.org/

Dropin replacement with a decent license.

_________________
If at first you don't succeed, bomb disposal probably isn't for you! ヅ


Top
 Profile  
 
 Post subject: Re: MySQL vs. PgSQL performance - has anyone benchmarked the
PostPosted: 2011-05-03 16:37 
Normal user
User avatar

Joined: 2010-03-30 19:30
Posts: 232
Location: uʍop ǝpısdn
Interesting, I assume that by "drop-in replacement" that means I can use the same installation of phpMyAdmin and other administrative tools to manage it? What about its performance vs. either MySQL or PostgreSQL?

_________________
hMailServer 5.4-B1929 Alpha on Server 2008 R2 VM
MySQL 5.5.15, IIS 7.5, PHP 5.3.6 via FastCGI, RoundCube 0.5.4
XenServer 6.0 on 2x HP DL380 G5 16GB RAM each
VM data on Thecus 1U4200XXXR iSCSI SAN


Top
 Profile  
 
 Post subject: Re: MySQL vs. PgSQL performance - has anyone benchmarked the
PostPosted: 2011-05-03 18:27 
Site Admin
User avatar

Joined: 2005-07-29 16:18
Posts: 13792
Location: UK
It's created by the same people that made MySQL. They created Maria when Oracle took over Sun and everyone jumped ship as they were being arses. It should work exactly the same what MySQL does now so MySQL tools should work on it too.

I haven't had chance to try it out myself I have been meaning to test it though.

_________________
If at first you don't succeed, bomb disposal probably isn't for you! ヅ


Top
 Profile  
 
 Post subject: Re: MySQL vs. PgSQL performance - has anyone benchmarked the
PostPosted: 2011-05-30 16:10 
New user
New user

Joined: 2011-05-30 14:32
Posts: 5
As a former database administrator, I would often get this question from friends and colleagues. And I would stay in the middle and say that both are excellent products boasting of unique sets of strength and it boils down to your preference.

In terms of progress though, Mysql has been a little more advance being able to present various table types that support transactions and foreign keys. However, some of the configurations are a little too complex for some to bear.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 


Who is online

Users browsing this forum: No registered users and 1 guest



Search for:
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group