Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1q0zhW-0007dB-VD
	for pgsql-bugs@arkaria.postgresql.org; Mon, 22 May 2023 07:11:26 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1q0zhV-0003mr-Qm
	for pgsql-bugs@arkaria.postgresql.org; Mon, 22 May 2023 07:11:25 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <buschmann@nidsa.net>)
	id 1q0zhV-0003mE-IB
	for pgsql-bugs@lists.postgresql.org; Mon, 22 May 2023 07:11:25 +0000
Received: from ma04-relay.lansolnet.com ([176.95.46.38])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <buschmann@nidsa.net>)
	id 1q0zhS-001ADU-DB
	for pgsql-bugs@lists.postgresql.org; Mon, 22 May 2023 07:11:24 +0000
Received: from unknown ([192.168.8.231]) by ma04-relay.lansolnet.com;
 Mon, 22 May 2023 09:11:18 +0200
Received: from MBX200E.cloud4partner.com (192.168.8.234) by
 MBX200B.cloud4partner.com (192.168.8.231) with Microsoft SMTP Server
 (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id
 15.1.669.32; Mon, 22 May 2023 09:11:16 +0200
Received: from MBX200E.cloud4partner.com ([fe80::881b:2a52:f04f:d634]) by
 MBX200E.cloud4partner.com ([fe80::881b:2a52:f04f:d634%13]) with mapi id
 15.01.0669.032; Mon, 22 May 2023 09:11:16 +0200
From: Hans Buschmann <buschmann@nidsa.net>
To: Peter Eisentraut <peter.eisentraut@enterprisedb.com>,
	"pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: AW: AW: BUG #17923: Excessive warnings of collation version mismatch
 in logs
Thread-Topic: AW: BUG #17923: Excessive warnings of collation version mismatch
 in logs
Thread-Index: AQHZgMys4E+UGAM12kitXbk9IBlyr69S3f6AgAH1e7eACYMRAIAHoAFs
Date: Mon, 22 May 2023 07:11:16 +0000
Message-ID: <ade7b17bc1b0415b80a4e1de2a822440@nidsa.net>
References: <17923-c791d260d83aa587@postgresql.org>
 <6c53254e-3e03-aa73-6007-bc67397fd507@enterprisedb.com>
 <5d3fa6cf2dd7489dba0e087e7e6a164e@nidsa.net>,<e87a8b12-7564-cd3a-f3c1-90e2005bb4e8@enterprisedb.com>
In-Reply-To: <e87a8b12-7564-cd3a-f3c1-90e2005bb4e8@enterprisedb.com>
Accept-Language: de-DE, en-US
Content-Language: de-DE
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
x-originating-ip: [192.168.8.240]
Content-Type: multipart/alternative;
	boundary="_000_ade7b17bc1b0415b80a4e1de2a822440nidsanet_"
MIME-Version: 1.0
X-cloud-security-sender: buschmann@nidsa.net
X-cloud-security-recipient: pgsql-bugs@lists.postgresql.org
X-cloud-security-Virusscan: CLEAN
X-cloud-security-disclaimer: This E-Mail was scanned by E-Mailservice on
 ma04-relay.lansolnet.com with C9CC3B80A73
X-cloud-security-connect: unknown[192.168.8.231], TLS=1, IP=192.168.8.231
X-cloud-security: scantime:.3755
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/ade7b17bc1b0415b80a4e1de2a822440%40nidsa.net>
Precedence: bulk

--_000_ade7b17bc1b0415b80a4e1de2a822440nidsanet_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

+1 for disabling the warnings there!


But I wonder, why this test is necessary at every autovacuum call at all?

Woudn't it be sufficient to test it at server start time only once?


Are there perhaps other places with this test?


Hans Buschmann


________________________________

--_000_ade7b17bc1b0415b80a4e1de2a822440nidsanet_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"><!-- P {margin-top:0;margi=
n-bottom:0;} --></style>
</head>
<body dir=3D"ltr">
<div id=3D"divtagdefaultwrapper" style=3D"font-size:12pt;color:#000000;font=
-family:Calibri,Arial,Helvetica,sans-serif;">
<p>&#43;1 for disabling the warnings there!</p>
<p><br>
</p>
<p>But I wonder, why this test is necessary at every autovacuum call at all=
?</p>
<p>Woudn't it be sufficient to test it at server start time only once?</p>
<p><br>
</p>
<p>Are there perhaps other places with this test?</p>
<p><br>
</p>
<p>Hans Buschmann</p>
<br>
<br>
<div style=3D"color: rgb(0, 0, 0);">
<div>
<hr tabindex=3D"-1" style=3D"display:inline-block; width:98%">
</div>
</div>
</div>
</body>
</html>

--_000_ade7b17bc1b0415b80a4e1de2a822440nidsanet_--