Re: [keycloak-dev] Events not deleted on realm deletion and missing indexes

Hi Sebastian! Not automatically deleting events when the realm is deleted makes sense to me, given it can be used as an audit log. But I think it would have been a nice feature to make it a checkable option, so you could delete it if you want to. Thanks for pointing out the lack of indexes. I proposed a PR for this some weeks ago, https://github.com/keycloak/keycloak/pull/6324. The conclusion from the Keycloak team, is that they don't want to add the index in an upgrade step because it might take a long time to generate the index. However, I think that conclusion is wrong because if you have a large event table, Keycloak is not operating normally anyways because the automatic event cleanup job, which runs every 15 minutes, impacts the normal operation. I also tried to add support for concurrently adding the index, but when I tested it for Postgres, which requires the SQL statement to be run outside and transaction, Keycloak would hang on startup due to a lock in the database. I haven't had time to look more into the details, but there seems to be some locking in Keycloak to ensure that the upgrade is complete before continuing the startup. Which makes sense to me. Stian or Hynek, please feel free to contact me if you would like to discuss these details. Honestly, I feel the lack of indexes should have been taken more seriously, because it currently doesn't scale. We ended up adding the indexes ourselves in a manual step, but I really think it is a bad idea and something Keycloak should handle as part of the product. - Johannes On Sun, Oct 13, 2019 at 11:16 AM Schuster Sebastian (INST-CSS/BSV-OS2) <Sebastian.Schuster(a)bosch-si.com&gt; wrote: