Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sBygP-002P7S-SF for pgsql-admin@arkaria.postgresql.org; Tue, 28 May 2024 15:24:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sBygP-00AD6g-Ew for pgsql-admin@arkaria.postgresql.org; Tue, 28 May 2024 15:24:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sBygP-00AD6X-3f for pgsql-admin@lists.postgresql.org; Tue, 28 May 2024 15:24:13 +0000 Received: from mailout.easymail.ca ([64.68.200.34]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sBygM-002NvB-7g for pgsql-admin@postgresql.org; Tue, 28 May 2024 15:24:11 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id 68C9EEF675; Tue, 28 May 2024 15:24:07 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1716909847; bh=WR6i+dQyFVZZ/GqAOuMuC9O6eS5knzDOmTIooe5mTeQ=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=jmbj9SKiq3cayPy6XQBAgoPnhF0kcwd1mZUHGJw0MyIwV2lx3c7BLMTmlgfTIsTyg Lc60lZfxzu5FsG5w8FewEAE0OS3A/z5QqYAoEeYniKQYmDl8QRoKeX4T0hY+ws5E0F UdTjeFaf9C6VH8vtJlEjq/T39T8sQdJnYeeRKz4Uo3+R7tKz1ZnJ72wF9853YXmopQ shAuxcrmN1C2qgpqKS44reMtYWhxc9ZOWhwBQ/ShPyXVI2vb2ND/uxlJpNXpouRHdf ob2a9e94pCR69UZUmfPB2AiIUl4BTlG3uE8UwGOMq/Yzx/1yx9P9vEk9B9DD3U2JPR bYR2bVvOAR40A== X-Virus-Scanned: Debian amavisd-new at emo08-pco.easydns.vpn Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (emo08-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id whVR_UgSnAJQ; Tue, 28 May 2024 15:24:07 +0000 (UTC) Received: from smtpclient.apple (unknown [165.140.184.195]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mailout.easymail.ca (Postfix) with ESMTPSA id CE294EF3A5; Tue, 28 May 2024 15:24:06 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1716909846; bh=WR6i+dQyFVZZ/GqAOuMuC9O6eS5knzDOmTIooe5mTeQ=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=F2Q5ZVPZzzGIRVZWDaac9w0JVbfJRPAoJiUtOgDbj5alEenOOqW1mXgCTosHJ3phI 32IfPnrzOMcgP3CIZvDXfFk7J6rVbKNyu9I2NhrGMoZsUj1bpMb2b59SRGZEuPDUnY NosPilp0iLTVbSPINRzX0LTJ7c7ft0ypm9IazWV4EAYu+fFKOUDQOp9dfy/2A+DpGL gA/wJTethyRAqew0SOsLH2xwi+GJEbmRnAloyXgIxwEb87RB9B/Ez33tPhmQSo0CfK imn57mgSDZjIvnf9qlfdbTVfw2HkrMf68ht5EdVBYjk46NcTkGqjWpUKKkowkE3dLf MlPmCoxDqlzyA== Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.600.62\)) Subject: Re: Postgresql streaming replication From: Scott Ribe In-Reply-To: Date: Tue, 28 May 2024 09:23:56 -0600 Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <0B15DA7E-E26C-4B2A-B389-2011C8216007@elevated-dev.com> References: <06ab2de0-86d6-426e-4a18-17e0b25553ef@pangburngroup.com> <566DFBB0-A057-4069-A1F0-1AEFB38281F5@elevated-dev.com> To: dbadmin@pangburngroup.com X-Mailer: Apple Mail (2.3774.600.62) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On May 28, 2024, at 9:00=E2=80=AFAM, Prasanth = wrote: >=20 > I ran few queries and the recent data seems to be there. Would this = cause differences in sorting or are there bigger issues with this = difference in glibc libraries? A "difference" in sorting will literally mean some queries not finding = the matching data--because indexes were created under one set of sorting = rules, then traversed under a different set of sorting rules.=