However, on its own, template databases are not fast enough for our use case. The time it takes to create a new database from a template database is still too high for running thousands of tests:
postgres=# CREATE DATABASE foo TEMPLATE contra;
CREATE DATABASE
Time: 1999.758 ms (00:02.000)
So no. They say this adds ~33 minutes to running their tests.
This includes a full build of the application, postgres container startup and spring context startup.
Starting the postgres container seems be less than 2 seconds of those 8 seconds.
Is that fast enough?