Request timeout when updating permissions

[0x62]

I've been using Hasura in production for a year or so now, and have started to hit limitations on the console. Updating permissions for a single role takes 20+ seconds for the request to complete, and almost always showing the below error:

Sometimes permissions update despite the error, other times it can take 5+ attempts for it to save successfully. As I'm writing this, I've been trying to add select permissions for two columns and on the 4th attempt. This issue has got progressively worse over the last couple months.

Below information might be useful:

• Version: v2-alpha7
• Tables: 84
• Rows: 84,614
• Roles: 5 (excluding admin)
• Server: Heroku 2X Production Dyno (1GB RAM), Heroku Postgres Standard 0

You can see requests timing out in the dashboard whenever I try to update permissions, due to Heroku killing the app for memory usage.

[galipmedia]

I am having the same issue on AWS ECS container. Everytime I change permissions since 2.7 it crashes the whole server with an out of memory warning.

[galipmedia]

It was running smoothly for over a year before the update.