H2 is a lightweight database. As so it does have limitations. I believe limit of 2^64 rows per table is a hard limit.
I would recommend you to check out H2 Database site for exact details and benchmark test result shared to get better insights.
For production instance, it is recommended to use PostgreSQL.
Thanks for the response. From the H2 performance comparison chart, the performance may not be the biggest concern, compared to PostgreSQL. I agreed that PostgreSQL may be a better option for the production environment for the model storage due to its scalability and high-availability feature, as the embedded H2 doesn't support the clustering, and use DSE for the data storage.