Slow startup with a million records of Offline_user_session

We have a million users in our app and we use offline tokens. So our offline_user_session table has a million records

It takes Keycloak more than 30 minutes to start.
If I delete everything from offline_user_session, everything starts in 30 second.

Is there any configuration or maybe I’m doing something wrong

I use docker image from here: https://hub.docker.com/r/jboss/keycloak/

I change no configurations.

2 Likes

Any updates, please? I am facing the same issue with Keycloak 9.0.2 and PostgreSQL 9.6.6.