Postgres + lots of RAM. In memory database is fine until you have to recover a 20 gig AOF.

We use H2 in production for a non-critical small app. If it goes down we just launch it again and it fetches data from other internal webapps.

I'd not recommend it for heavy-use in Production.