• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Resource Load Management
  5. Storage Space Management

Storage Space Management

Scenarios

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.

Storage Space Management

  • User space limit

Procedure

Assume that you need to set the maximum space of user user1 to 100 GB.

  1. Create user user1.

    CREATE USER user1 PASSWORD 'Bigdata@123' PERM SPACE '100G';
    CREATE ROLE

  2. Insert data as user user1.
NOTE:

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."