Is redmine better under postgresql or MySQL
Added by Craig Efrein almost 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 almost 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).