Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jHZPU-0000dc-DG for pgsql-admin@arkaria.postgresql.org; Thu, 26 Mar 2020 20:47:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jHZPT-0007X2-3A for pgsql-admin@arkaria.postgresql.org; Thu, 26 Mar 2020 20:47:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jHZPS-0007Wt-Gd for pgsql-admin@lists.postgresql.org; Thu, 26 Mar 2020 20:47:26 +0000 Received: from impout004aa.msg.chrl.nc.charter.net ([47.43.20.28] helo=impout004.msg.chrl.nc.charter.net) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jHZPQ-0006Ig-4y for pgsql-admin@lists.postgresql.org; Thu, 26 Mar 2020 20:47:25 +0000 Received: from cerberus.crazybean.net ([24.151.69.73]) by cmsmtp with ESMTP id HZPOjQ5GswzF8HZPOjeqTp; Thu, 26 Mar 2020 20:47:23 +0000 Authentication-Results: crazybean.net; none X-Authority-Analysis: v=2.3 cv=SdVDicZu c=1 sm=1 tr=0 a=YXTuGtgWN9YX+aIhe8tYuA==:117 a=YXTuGtgWN9YX+aIhe8tYuA==:17 a=jpOVt7BSZ2e4Z31A5e1TngXxSK0=:19 a=xqWC_Br6kY4A:10 a=SS2py6AdgQ4A:10 a=0jFAOcL7AAAA:8 a=JZhchkmpN-isdlc6olYA:9 a=CjuIK1q_8ugA:10 a=ia-IsSeLKEyEpghO87wA:9 a=VCCHqraMaC116Lp2:21 a=_W_S_7VecoQA:10 a=K48GPUIhKHzPTnLCTHz5:22 Received: from [IPv6:2001:470:e117:4:154:e85e:7412:3762] ( [2001:470:e117:4:154:e85e:7412:3762]) by cerberus.crazybean.net (OpenSMTPD) with ESMTPSA id fc2873d2 (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256:NO); Thu, 26 Mar 2020 16:47:22 -0400 (EDT) From: Rui DeSousa Message-Id: <30BC197F-1AC7-438E-BF72-AB29B5194C69@crazybean.net> Content-Type: multipart/alternative; boundary="Apple-Mail=_CF9C49A1-A06D-4F71-AEB0-3F9892EC6E83" Mime-Version: 1.0 (Mac OS X Mail 13.0 \(3608.60.0.2.5\)) Subject: Re: Vacuum Issues Date: Thu, 26 Mar 2020 16:47:21 -0400 In-Reply-To: <171187f1f11.e7c537f6208044.4379759561125142996@realtyserver.com> Cc: pgsql-admin To: Darron Harrison References: <171180a0730.f301716f192269.5929166075824764633@realtyserver.com> <8612E7A0-95FE-45DD-92BF-99FF68757BCF@crazybean.net> <1711838a1a0.b8776dce198656.4553889266632620330@realtyserver.com> <171187f1f11.e7c537f6208044.4379759561125142996@realtyserver.com> X-Mailer: Apple Mail (2.3608.60.0.2.5) X-CMAE-Envelope: MS4wfBe2uFoU3DJqsAsgLSKbV1uS1S1cFH302drQB3yT47M4jKaqbcHTQXqM+ia88v5NfOxHijgV3XffxachNoRIrjiSl+BCcC7N0MiB1tUpFknkzeQ7HjNn e3i/03vmsSiu8gHjbL4ToDsvpuDZIqLKNbklObZlhamHsERi8RAlUIZslQ+jqW95EYSOZ4eGCWrbhNfbWUd116guLbsIFUw3pN0wrdamMO2x7U/7Kd/SaxUt List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail=_CF9C49A1-A06D-4F71-AEB0-3F9892EC6E83 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii > On Mar 26, 2020, at 4:18 PM, Darron Harrison = wrote: >=20 > 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? --Apple-Mail=_CF9C49A1-A06D-4F71-AEB0-3F9892EC6E83 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii

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?

= --Apple-Mail=_CF9C49A1-A06D-4F71-AEB0-3F9892EC6E83--