Data volume quota on schema level
Details
| Detail name | Value |
|---|---|
| Changelog Number | 5749 |
| Type | New Feature |
| Status | Resolved |
| Fix Versions | Exasol 6.1.0 |
| Resolution Date | 2018-03-27 |
Enforce limits on the storage used at schema level
Synopsis
We have introduced the concept of raw_size limit at schema level. This enforces a hard limit on the (uncompressed) data volume used by a schema.
Set/unset raw size limit
- Set raw size limit
ALTER SCHEMA MY_SCHEMA_1 SET RAW_SIZE_LIMIT = 1000; -- limits the raw size for MY_SCHEMA_1 to 1000 bytes ALTER SCHEMA MY_SCHEMA_2 SET RAW_SIZE_LIMIT = 10 * 1024 * 1024 * 1024; -- limits the raw size for MY_SCHEMA_2 to 10 GB
- Unset raw size limit (infinite storage usage):
ALTER SCHEMA MY_SCHEMA_3 SET RAW_SIZE_LIMIT = NULL; -- unlimited raw size for MY_SCHEMA_3
- Default behavior
By default, schemas have no limits on the raw size.
Enforcement
The raw_size limit is checked and enforced in two cases: when the raw_size limit is set and when a transaction commits. If the uncompressed data volume used by a scheme exceeds its raw_size limit then the query fails with an exception in the first case and a transaction rollback in the latter.
