Project

General

Profile

Forums » Help »

Is redmine better under postgresql or MySQL

Added by Craig Efrein over 13 years ago

Hello all,

Does Redmine perform better under MySQL or PostgreSQL (8,9)? Will migrating to Postgresql make upgrading to newer versions of Redmine more complex?

We are currently using Redmine 1.2.0.stable.6081

I have seen various articles on migrating Redmine to Postgresql. Does anyone have a sure fire method?

Thank you in advance,
Craig


Replies (1)

RE: Is redmine better under postgresql or MySQL - Added by Etienne Massip over 13 years ago

Craig Efrein wrote:

Does Redmine perform better under MySQL or PostgreSQL (8,9)?

I don't know if it's relevant or not but the test suite ran in these times (r7467) on CI server:

  • mysql 5 : about 646.28 seconds (10.77 minutes)
  • sqlite3 : about 601.49 seconds (10.02 minutes)
  • postgresql 8 : about 690.86 seconds (11.51 minutes)

These builds have run sequentially (see start times) but I don't know if there was some external cause of performance slump.

Will migrating to Postgresql make upgrading to newer versions of Redmine more complex?

No (I use PostgreSQL).

    (1-1/1)