How to fix vacuum failsafe triggered in PostgreSQL

SELECT
  schemaname,
  tablename,
  age(relfrozenxid) AS age,
  2147483647 - age(relfrozenxid) AS xids_remaining
FROM pg_class
JOIN pg_tables ON pg_class.relname = pg_tables.tablename
ORDER BY age(relfrozenxid) DESC
LIMIT 20;

-- Check global setting
SHOW autovacuum;

-- Check per-table setting and reloptions
SELECT schemaname, tablename, reloptions FROM pg_tables
WHERE tablename IN (SELECT tablename FROM pg_tables);

ALTER SYSTEM SET autovacuum = on;
SELECT pg_reload_conf();

SELECT
  pid,
  usename,
  state,
  xact_start,
  now() - xact_start AS transaction_duration,
  query
FROM pg_stat_activity
WHERE state IN ('idle in transaction', 'active')
  AND xact_start IS NOT NULL
ORDER BY xact_start;

SELECT pg_terminate_backend(pid) FROM pg_stat_activity
WHERE pid != pg_backend_pid()
  AND state = 'idle in transaction'
  AND xact_start < now() - interval '1 hour';

ALTER SYSTEM SET autovacuum_naptime = '10s';  -- Check for work every 10 seconds
ALTER SYSTEM SET autovacuum_vacuum_cost_delay = '1ms';  -- Process faster
ALTER SYSTEM SET autovacuum_vacuum_cost_limit = 5000;  -- More work per cycle
ALTER SYSTEM SET autovacuum_max_workers = 4;  -- More parallel workers
SELECT pg_reload_conf();

ALTER TABLE your_high_volume_table SET (
  autovacuum_vacuum_cost_delay = 0,
  autovacuum_vacuum_cost_limit = 10000
);

SELECT
  pid,
  usename,
  application_name,
  state,
  query_start,
  now() - query_start AS duration,
  query
FROM pg_stat_activity
WHERE query ILIKE '%vacuum%'
  OR state = 'in vacuum';

SELECT p.pid, p.datname, p.relid::regclass AS table_name,
       p.phase, p.heap_blks_total, p.heap_blks_scanned,
       round(100.0 * p.heap_blks_scanned / NULLIF(p.heap_blks_total, 0), 1) AS percent_complete
FROM pg_stat_progress_vacuum p
JOIN pg_stat_activity a ON p.pid = a.pid;

tail -f /var/log/postgresql/postgresql.log | grep -E 'vacuum|failsafe|freeze'

journalctl -u postgresql -f | grep -E 'vacuum|failsafe'

-- Increase from default 200M to a value your system can handle
-- E.g., if you have high transaction rate, try 300-500M
ALTER SYSTEM SET autovacuum_freeze_max_age = 300000000;
SELECT pg_reload_conf();