Help Center > > Developer Guide> Resource Load Management> Storage Space Management

Storage Space Management

Updated at: Mar 13, 2020 GMT+08:00

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.

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

  2. Insert data as user user1.

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel