diskquota
diskquota copied to clipboard
greenplum-db
PostgreSQL disk quota extension
This PR adds a DiskquotaStatus struct to maintain the shared memory usage caused by TableSizeMap and QuotaInfoMap. Let's use TableSizeEntry as the example: - totale_table_size_entries: the TableSizeEntry count in all...
Diskquota did not control the size of its hash tables in shared memory and could have consumed shared memory not intended for it, potentially impacting the other database subsystems. Hash...
After refreshing table size map, center worker behavior: - updates quota info map by table size changing - loads quota config and updates quota limit in QuotaInfoEntry - sends QuotaInfoEntryKey...
hi, when i test the dump/restore of diskquota with pg_dump/pg_restore, i found that what we saved in diskquota.quota_config and diskquota.target (called user configurations for short) is oids but not object...
During diskquota worker's first run the initial set of active tables with their sizes is being loaded from `diskquota.table_size` table in order to warm up diskquota rejectmap and other shared...
This PR adds error reports to diskquota.status(). Users can check whether some errors happen in the bgworker by diskquota.status() UDF. This PR may replace #359
1) set minimum cache size ```sh gpconfig -c diskquota.max_table_segments -v 6400 ``` 2) run sql ```sql CREATE EXTENSION diskquota; CREATE EXTENSION SELECT diskquota.set_schema_quota(current_schema, '1MB'); set_schema_quota ------------------ (1 row) SET client_min_messages...
Refactor RejectMapEntry to make it more understandable. - change targetoid to namespaceoid/owneroid. To avoid modifying SQL, some UDFs still show targetoid. - change relfilenode's type from RelfileNode to Oid. -...