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 1jHaFV-0001zF-2u for pgsql-admin@arkaria.postgresql.org; Thu, 26 Mar 2020 21:41:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jHaFT-00007D-RC for pgsql-admin@arkaria.postgresql.org; Thu, 26 Mar 2020 21:41:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jHaFT-000075-88 for pgsql-admin@lists.postgresql.org; Thu, 26 Mar 2020 21:41:11 +0000 Received: from sender4-op-o11.zoho.com ([136.143.188.11]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jHaFL-0003cW-NE for pgsql-admin@lists.postgresql.org; Thu, 26 Mar 2020 21:41:10 +0000 ARC-Seal: i=1; a=rsa-sha256; t=1585258856; cv=none; d=zohomail.com; s=zohoarc; b=SSTaLGYlcYKxrC+LvvqeJyIFni4RmWuTGpe59fu84kZJXozhC9GfC5pZMH+ON/tgIkLEmftnUfa5YbyplyttzhE6hPIe3ezbtrqTElnhWKjU5Ofb9FJQT4GADmNCHYLPuotDnRcSXapZeojxuotgtIgOarsgSdDtNnq3vXq6jMw= ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=zohomail.com; s=zohoarc; t=1585258856; h=Content-Type:Cc:Date:From:In-Reply-To:MIME-Version:Message-ID:References:Subject:To; bh=w5ubuwnXrOra8fc9C7/oB9GLFMVXy95y70ksZQUDHTQ=; b=bRnqg3A5p95uss9nPX5/KwxFT/oBUb3UCYHi4Sx/tHO3k26CmcYWtaVEz+IDWUgUVNJ9Lyl2TCPqq9BukmVGdzoxe1MGIClTIllR6ZxfwOlZivz7cnooD0ndBGAQK2ar0p3HK8wB757mffr6R2YHns5jfaHREAipMR23dXXS25Q= ARC-Authentication-Results: i=1; mx.zohomail.com; dkim=pass header.i=realtyserver.com; spf=pass smtp.mailfrom=darron@realtyserver.com; dmarc=pass header.from= header.from= DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; t=1585258856; s=zohoemail; d=realtyserver.com; i=darron@realtyserver.com; h=Date:From:To:Cc:Message-Id:In-Reply-To:References:Subject:MIME-Version:Content-Type; bh=w5ubuwnXrOra8fc9C7/oB9GLFMVXy95y70ksZQUDHTQ=; b=NdaY3S1g3t3br40s6wWNkLrKZWAKV8SzpNsmhJVnk/j4KR0QD4Gnre4phoqgytsZ CR160tFiyBwgAKoO3WevcpzCzwqqBNzT0eFhnx0QuD2kODVDiVRFjJXC4q2DWPuESJn 1IU+5sq/wGIsGgpJlpnIjh1dEMCuT8s74H/tvI/k= Received: from mail.zoho.com by mx.zohomail.com with SMTP id 1585258855405696.9859275360163; Thu, 26 Mar 2020 14:40:55 -0700 (PDT) Date: Thu, 26 Mar 2020 14:40:55 -0700 From: Darron Harrison To: "Rui DeSousa" Cc: "pgsql-admin" Message-Id: <17118ca7beb.bd8e3204216663.1608462906593065114@realtyserver.com> 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> <171187f1f11.e7c537f6208044.4379759561125142996@realtyserver.com> <30BC197F-1AC7-438E-BF72-AB29B5194C69@crazybean.net> Subject: Re: Vacuum Issues MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_716988_1670169421.1585258855403" Importance: Medium User-Agent: Zoho Mail X-Mailer: Zoho Mail List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_716988_1670169421.1585258855403 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit 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 wrote ---- On Mar 26, 2020, at 4:18 PM, Darron Harrison 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? ------=_Part_716988_1670169421.1585258855403 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable =
There is no current lag on the replicas. Replicati= on does traverse a firewall, but we have made no changes recently.

I will say that one of the hot standbys was only recen= tly attached, and it seems like the issues started when we began sending so= me 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 takin= g twice as long as normal.

Darron


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



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

I am not seeing anything suspicious o= n the master or slaves.
=

I would ask what replication timeout v= alues are but those where added in 9.3 (wal_reciver_timeout and wal_sender_= timeout).

Are all the replicas rece= iving updates and current or are they lagging? Does replication traverse an= y firewalls?



------=_Part_716988_1670169421.1585258855403--