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 ) id 1q1UjB-0003za-FH for pgsql-bugs@arkaria.postgresql.org; Tue, 23 May 2023 16:19:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q1UjA-0004QZ-68 for pgsql-bugs@arkaria.postgresql.org; Tue, 23 May 2023 16:19:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q1Uj9-0004QP-BI for pgsql-bugs@lists.postgresql.org; Tue, 23 May 2023 16:19:11 +0000 Received: from wnew3-smtp.messagingengine.com ([64.147.123.17]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q1Uj4-001gT6-2u for pgsql-bugs@lists.postgresql.org; Tue, 23 May 2023 16:19:10 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailnew.west.internal (Postfix) with ESMTP id ACEE22B06975; Tue, 23 May 2023 12:19:00 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute5.internal (MEProxy); Tue, 23 May 2023 12:19:00 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1684858740; x= 1684865940; bh=8Szcyxnmsl5yLOWLsoo4TKn14RTZ7Z7ti3dlK0/WJw4=; b=J VUJ9NQplbgLk/Tll0wvgUCNzF2q4QPh7FwIENK3Mi+SMJpo1cwLJ0V5BOkfk+xFQ pMg3T2JPTT9JJ/zRHscn6URoQq05+z9bREH2FwzijBftAyu7sx8KS+7bKi7rgVHC auvswikUDk3O6Kc6fVFWBqtZ8X6WvYw4QH+FwjPL0oWKMPbVmEX0zM07pZRxn97N Hr2Mnb5gO+/m6glZMXibtnbOC8lelqfbiVUTgBosfrngbiEMKfXl9R1iocVISghu qJC4+P3H7ELAPXz09jA4XqnJS5suzCdt1ogqBkiwuvKZdTQPOqP/pp7B6K/+4JLa CkZ/LS7NxF+c5JQhLzqEA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrfeejfedgleejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvfhfhjggtgfesthejredttdefjeenucfhrhhomheprfgvthgv rhcugfhishgvnhhtrhgruhhtuceophgvthgvrhdrvghishgvnhhtrhgruhhtsegvnhhtvg hrphhrihhsvggusgdrtghomheqnecuggftrfgrthhtvghrnhepfeejgeehteeuhfevvedu leeufedtjeetiefftedvudfhtdeifefgueettdevgefgnecuvehluhhsthgvrhfuihiivg eptdenucfrrghrrghmpehmrghilhhfrhhomhepphgvthgvrhdrvghishgvnhhtrhgruhht segvnhhtvghrphhrihhsvggusgdrtghomh X-ME-Proxy: Feedback-ID: i131946ab:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 23 May 2023 12:18:59 -0400 (EDT) Message-ID: Date: Tue, 23 May 2023 18:18:55 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 Subject: Re: AW: AW: BUG #17923: Excessive warnings of collation version mismatch in logs Content-Language: en-US To: Hans Buschmann , "pgsql-bugs@lists.postgresql.org" References: <17923-c791d260d83aa587@postgresql.org> <6c53254e-3e03-aa73-6007-bc67397fd507@enterprisedb.com> <5d3fa6cf2dd7489dba0e087e7e6a164e@nidsa.net> From: Peter Eisentraut In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 22.05.23 09:11, Hans Buschmann wrote: > 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? The main server process (postmaster) cannot access the database contents. So we can only do it when we start a session process.