It seems that loading entities and associated tags really causes the troubles.
Maybe it makes sense to decouple loading entities from loading tags, i.e., first load the entities and then load the tags in a second request.
We should also check PG and evaluate query performance. Maybe it makes sense to compute some materialized views, which are updated nightly, in order to speed up querying of entity tags.
It seems that loading entities and associated tags really causes the troubles.
Maybe it makes sense to decouple loading entities from loading tags, i.e., first load the entities and then load the tags in a second request.
We should also check PG and evaluate query performance. Maybe it makes sense to compute some materialized views, which are updated nightly, in order to speed up querying of entity tags.