Vacuum Issues

From: Darron Harrison <darron(at)realtyserver(dot)com>
To: "pgsql-admin" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Vacuum Issues
Date: 2020-03-26 18:10:42
Message-ID: 171180a0730.f301716f192269.5929166075824764633@realtyserver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rui DeSousa 2020-03-26 18:50:10 Re: Vacuum Issues
Previous Message Justin King 2020-03-26 14:46:47 Re: PG12 autovac issues