ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 数据库比较 PostgreSQL vs MongoDB

数据库比较 PostgreSQL vs MongoDB

原创 Linux操作系统 作者:jieforest 时间:2012-05-28 12:54:17 0 删除 编辑
[i=s] 本帖最后由 jieforest 于 2012-5-21 09:34 编辑

As you may know I have spent some time recently working on the hyperkitty program. The idea being to offer a newinterface to the archives in mailman 3 (which has never been closer to arelease).


Hyperkitty aims at implementing a numbers of the ideas developed by MáirínDuffy in her blog posts. The main one being to try to unify mailing lists andforum (ie: providing a web-interface to mailing lists).


In this quest, I have started to look some time ago to MongoDB. It is a NoSQL database which is becoming quitepopular (probably helped with its integration into openshift). The results were satisfying but then a bigquestion came up:


·             Do we really want to impose the burden of 2 different database systems toour sysadmin for a mailman archives interface ?


Of course, if we can avoid it, we wouldprefer to do it.


But MongoDB was performing reallynicely with regards to searching the archives. So testing was needed.


[size=15.5pt]Hardware

[size=11.5pt]The machine on which I ran the test has:

[size=10.0pt]·    [size=11.5pt]16G of ram

[size=10.0pt]·    [size=11.5pt]4 cores

[size=10.0pt]·    [size=11.5pt]2x1To in RAID1[size=11.5pt]All this operated by RHEL 6.2 (Santiago).

[size=15.5pt]

[size=15.5pt]The databases

[size=10.0pt]·    [size=11.5pt]PostgreSQL version 8.4.9

[size=10.0pt]·    [size=11.5pt]MongoDB version 1.8.2

[size=15.5pt]

[size=15.5pt]The data

[size=11.5pt]I used the archives from the[size=11.5pt] [size=11.5pt]devel[size=11.5pt] [size=11.5pt]mailing list, since its creation in 2002.

[size=10.0pt]·    [size=11.5pt]PostgreSQL loaded 166672 emails

[size=10.0pt]·    [size=11.5pt]MongoDB loaded 166642 emails

[size=11.5pt]

[size=11.5pt]So there is a difference of 30 emails which I considered to be negligible for the tests.


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/301743/viewspace-731259/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-04-23

  • 博文量
    443
  • 访问量
    509984