I used Drupal with PostgreSQL some times and my impressions were that it runs faster, but have problems with many contrib modules, because of the lack of testing, as the majority of Drupal projects use MySQL. With a recent project, with some thousands of orders, some screens get a little slow and this question came in my mind: Drupal Commerce would have a better performance running on PostgreSQL?

I'm thinking of doing some benchmarks, but maybe someone else made something like this before and could share a little tips on the topic.

Comments

rszrama’s picture

rszrama commented
Status: Active » Closed (fixed)

As far as I know, no one has done comparisons / benchmarks and published information about it. We do try to ensure that our core modules are compatible with Postgres, so feel free to open issues if you run into any incompatibilities. As for actually publishing your findings / engaging others who are interested in the topic, I think you'd have more success finding folks at http://www.drupalcommerce.org/discussions.