Request timeout when updating permissions

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.


Reproduce updating permissions for a single role using the reported Hasura version, table and role counts, and Heroku Postgres setup; inspect the Heroku dashboard when the request times out or the app is killed for memory usage. Done means permission updates complete reliably without request timeouts or memory-related process termination.

Written by the indexing model from the issue text.