MySQL vs. PgSQL performance - has anyone benchmarked them?

Forum for things that doesn't really have anything to do with hMailServer. Such as php.ini, beer, etc etc.
User avatar
rjk
Normal user
Normal user
Posts: 248
Joined: 2010-03-30 19:30
Location: uʍop ǝpısdn

MySQL vs. PgSQL performance - has anyone benchmarked them?

Postby rjk » 2011-05-02 22:27

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.5.2-B2129 on Server 2008 R2 VM
MySQL 5.5.25, IIS 7.5, PHP 5.6.2 via FastCGI, RoundCube 1.0.3
XenServer 6.0 on HP DL380 G5 32GB RAM

^DooM^
Site Admin
Posts: 13853
Joined: 2005-07-29 16:18
Location: UK

Re: MySQL vs. PgSQL performance - has anyone benchmarked the

Postby ^DooM^ » 2011-05-02 22:41

http://mariadb.org/

Dropin replacement with a decent license.
If at first you don't succeed, bomb disposal probably isn't for you! ヅ

User avatar
rjk
Normal user
Normal user
Posts: 248
Joined: 2010-03-30 19:30
Location: uʍop ǝpısdn

Re: MySQL vs. PgSQL performance - has anyone benchmarked the

Postby rjk » 2011-05-03 16:37

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.5.2-B2129 on Server 2008 R2 VM
MySQL 5.5.25, IIS 7.5, PHP 5.6.2 via FastCGI, RoundCube 1.0.3
XenServer 6.0 on HP DL380 G5 32GB RAM

^DooM^
Site Admin
Posts: 13853
Joined: 2005-07-29 16:18
Location: UK

Re: MySQL vs. PgSQL performance - has anyone benchmarked the

Postby ^DooM^ » 2011-05-03 18:27

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! ヅ

acunningham
New user
New user
Posts: 5
Joined: 2011-05-30 14:32

Re: MySQL vs. PgSQL performance - has anyone benchmarked the

Postby acunningham » 2011-05-30 16:10

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.


Return to “Off-topic discussions”



Who is online

Users browsing this forum: No registered users and 3 guests