GRANT ALL ON SCHEMA takes some time when having many tables
Open
performance
schema-based-sharding
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
Even when granting permissions on a pretty small schema it takes serious amount of time. This schema only contains 10 distributed tables, but the total number of distributed tables is 87689
```
citus=> GRANT SELECT ON ALL TABLES IN SCHEMA schema_bench_2 to citus;
GRANT
Time: 230.573 ms
```
This is almost certainly because of its usage of `CitusTableTypeIdList(ANY_CITUS_TABLE_TYPE)`.
Contributor guide
Assessment
This issue has not been assessed yet.