Hello all, we are a young enterprise and trying out Metabase with a select group of users. If it works well we would like to roll it out to our company. (<100 users)
Is there a benefit to using Postgres or is an H2 database fine? Architecture-wise we are running it on a docker container with a separate drive mounted that contains the H2 db file. Thus, versions can potentially be upgraded without losing saved questions and users.
Are there any pitfalls to this approach? Is a Postgres database slower or faster?
For production installations of Metabase we recommend that users replace the H2 database with a more robust option such as Postgres. This offers a greater degree of performance and reliability when Metabase is running with many users.