Re: Vacuum Issues - Mailing list pgsql-admin

From Darron Harrison
Subject Re: Vacuum Issues
Date
Msg-id 17118ca7beb.bd8e3204216663.1608462906593065114@realtyserver.com
Whole thread Raw
In response to Re: Vacuum Issues  (Rui DeSousa <rui@crazybean.net>)
Responses Re: Vacuum Issues  (Rui DeSousa <rui@crazybean.net>)
List pgsql-admin
There is no current lag on the replicas. Replication does traverse a firewall, but we have made no changes recently.

I will say that one of the hot standbys was only recently attached, and it seems like the issues started when we began sending some longer running queries it's way. We have since placed those queries back on the master, but the vacuum issues remain.

One side effect of whatever is happening, is that nightly backups are taking twice as long as normal.

Darron


---- On Thu, 26 Mar 2020 13:47:21 -0700 Rui DeSousa <rui@crazybean.net> wrote ----



On Mar 26, 2020, at 4:18 PM, Darron Harrison <darron@realtyserver.com> wrote:

I am not seeing anything suspicious on the master or slaves.

I would ask what replication timeout values are but those where added in 9.3 (wal_reciver_timeout and wal_sender_timeout).

Are all the replicas receiving updates and current or are they lagging? Does replication traverse any firewalls?



pgsql-admin by date:

Previous
From: Rui DeSousa
Date:
Subject: Re: Vacuum Issues
Next
From: Rui DeSousa
Date:
Subject: Re: Vacuum Issues