How to fix WARNING: database must be vacuumed within N transactions in PostgreSQL

SELECT datname, age(datfrozenxid) AS xid_age,
       2147483647 - age(datfrozenxid) AS txids_remaining,
       CASE
         WHEN 2147483647 - age(datfrozenxid) < 3000000 THEN 'CRITICAL - VACUUM NOW'
         WHEN 2147483647 - age(datfrozenxid) < 10000000 THEN 'DANGER - VACUUM SOON'
         WHEN 2147483647 - age(datfrozenxid) < 40000000 THEN 'WARNING - VACUUM TODAY'
         ELSE 'MONITOR'
       END AS status
FROM pg_database
WHERE datname = current_database();

SELECT pid, usename, state, query, now() - xact_start AS duration
FROM pg_stat_activity
WHERE state IS NOT NULL
  AND xact_start IS NOT NULL
ORDER BY xact_start ASC
LIMIT 10;

-- Gentle termination
SELECT pg_cancel_backend(pid) FROM pg_stat_activity
WHERE pid != pg_backend_pid()
  AND now() - xact_start > interval '30 minutes'
  AND state = 'idle in transaction';

-- Force termination if needed
SELECT pg_terminate_backend(pid) FROM pg_stat_activity
WHERE pid != pg_backend_pid()
  AND now() - xact_start > interval '2 hours';

VACUUM ANALYZE;

VACUUM (INDEX_CLEANUP OFF, TRUNCATE OFF);

# Vacuum all databases with parallel workers
vacuumdb --all --jobs 4 --verbose

# Or specific database
vacuumdb --dbname yourdb --jobs 4 --analyze

SELECT p.pid, p.datname, p.relid::regclass AS table_name,
       p.phase, p.heap_blks_scanned, p.heap_blks_total,
       round(100.0 * p.heap_blks_scanned / NULLIF(p.heap_blks_total, 0), 1) AS percent_done
FROM pg_stat_progress_vacuum p;

SELECT datname, age(datfrozenxid) AS xid_age,
       2147483647 - age(datfrozenxid) AS txids_remaining
FROM pg_database
WHERE datname = current_database();

-- Lower freeze_max_age to trigger freezing more frequently
ALTER SYSTEM SET autovacuum_freeze_max_age = 100000000;  -- Default is 200 million

-- Increase autovacuum workers for parallel vacuuming
ALTER SYSTEM SET autovacuum_max_workers = 4;  -- Default is 3

-- Reduce vacuum cost delays if autovacuum is throttled
ALTER SYSTEM SET autovacuum_vacuum_cost_delay = 5;  -- Default is 20ms

-- Increase available vacuum cost
ALTER SYSTEM SET autovacuum_vacuum_cost_limit = 1000;  -- Default is -1 (unlimited)

-- Reload configuration
SELECT pg_reload_conf();

ALTER TABLE high_volume_table
SET (autovacuum_freeze_min_age = 5000000,
     autovacuum_freeze_table_age = 50000000);

-- Create a monitoring view
CREATE OR REPLACE VIEW wraparound_status AS
SELECT datname, age(datfrozenxid) AS xid_age,
       2147483647 - age(datfrozenxid) AS txids_remaining,
       CASE
         WHEN 2147483647 - age(datfrozenxid) < 3000000 THEN 'CRITICAL'
         WHEN 2147483647 - age(datfrozenxid) < 10000000 THEN 'DANGER'
         WHEN 2147483647 - age(datfrozenxid) < 40000000 THEN 'WARNING'
         ELSE 'OK'
       END AS status
FROM pg_database
ORDER BY xid_age DESC;

-- Query it regularly
SELECT * FROM wraparound_status;