I am not sure if it's an expected behavior, but with mariadb, calling repository.deleteAll() was also resetting the auto incrementation to 1.
http://stackoverflow.com/questions/5342440/reset-auto-increment-counter-in-postgres
This can be achieved manually, would be nice to implement it in deleteAll()