From: Darron Harrison <darron@realtyserver.com>
To: Rui DeSousa <rui@crazybean.net>
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Vacuum Issues
Date: Thu, 26 Mar 2020 14:40:55 -0700
Message-ID: <17118ca7beb.bd8e3204216663.1608462906593065114@realtyserver.com> (raw)
In-Reply-To: <30BC197F-1AC7-438E-BF72-AB29B5194C69@crazybean.net>
References: <171180a0730.f301716f192269.5929166075824764633@realtyserver.com>
<8612E7A0-95FE-45DD-92BF-99FF68757BCF@crazybean.net>
<1711838a1a0.b8776dce198656.4553889266632620330@realtyserver.com>
<EB0BC3D5-EE49-4863-963F-932A5D148A2B@crazybean.net>
<171187f1f11.e7c537f6208044.4379759561125142996@realtyserver.com>
<30BC197F-1AC7-438E-BF72-AB29B5194C69@crazybean.net>
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 <mailto: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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: darron@realtyserver.com, rui@crazybean.net, pgsql-admin@lists.postgresql.org
Subject: Re: Vacuum Issues
In-Reply-To: <17118ca7beb.bd8e3204216663.1608462906593065114@realtyserver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox