Hi All,
Having an issue where vacuum has been unable to clear dead rows since March 12. We are running an older version 9.2.4 with three hot standby servers.
We have standby feedback enabled, but according to pg_stat_activity there are no long running queries on the master or standby servers.
Also, we have no hung transactions on the master server:
SELECT * FROM pg_stat_activity where xact_start < (now() - interval '5 mins') ORDER BY xact_start NULLS LAST LIMIT 1;
Produces no results.
Anyone have any thoughts on what we should be checking next?
Thanks,
Darron Harrison