Considering the access patterns of the clients are well known, would it make sense to populate new tables as materialized views before Sending it to the client or you think is not worth it perf wise?
The materialized view isn’t a huge perf problem for now, and I expect we’d switch to using triggers or similar without too much difficulty.