How to MariaDB quota exceeded in PostgreSQL

Why How to MariaDB quota exceeded in PostgreSQL is important

-- Archive old shipped orders to keep within quota
BEGIN;
INSERT INTO Orders_Archive
SELECT * FROM Orders WHERE order_date < CURRENT_DATE - INTERVAL '18 months';
DELETE FROM Orders WHERE order_date < CURRENT_DATE - INTERVAL '18 months';
COMMIT;

-- Verify freed space
SELECT pg_size_pretty(pg_total_relation_size('Orders')) AS orders_size;

-- 1. Inspect current disk usage per tablespace
SELECT spcname, pg_size_pretty(pg_tablespace_size(oid)) AS size
FROM pg_tablespace;

-- 2. Identify largest relations in the “Orders” workflow
SELECT relname, pg_size_pretty(pg_total_relation_size(relid)) AS total
FROM pg_catalog.pg_statio_user_tables
ORDER BY pg_total_relation_size(relid) DESC
LIMIT 5;

-- 3. Delete historic orders older than 2 years
DELETE FROM Orders WHERE order_date < CURRENT_DATE - INTERVAL '2 years';

-- 4. Vacuum to release space
VACUUM FULL Orders;

-- 5. Move big table to a roomier tablespace
ALTER TABLE OrderItems SET TABLESPACE fast_ssd_ts;

-- 6. Raise temp file limit for reporting role
ALTER ROLE analyst SET temp_file_limit = '10GB';