Users using too much storage space may result in service blocking. To prevent this problem, you need to enhance the control over the storage space.
Assume that you need to set the maximum space of user user1 to 100 GB.
CREATE USER user1 PASSWORD 'Bigdata@123' PERM SPACE '100G'; CREATE ROLE
1. The CN periodically obtains and checks space information from a DN. The interval is 10s.
2. When detecting that the required space exceeds the current available space, the CN cancels all data inserting jobs and records the following information in the log file in the pg_log directory: "cancel thread <threadid> for space limit exceed."