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 1qNGRK-004VRw-W4 for pgsql-general@arkaria.postgresql.org; Sat, 22 Jul 2023 17:30:46 +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 1qNGRI-00G0p4-RE for pgsql-general@arkaria.postgresql.org; Sat, 22 Jul 2023 17:30:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qNGRI-00G0ow-Fe for pgsql-general@lists.postgresql.org; Sat, 22 Jul 2023 17:30:44 +0000 Received: from aart.rice.edu ([168.7.56.48]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qNGRD-001AIN-MP for pgsql-general@lists.postgresql.org; Sat, 22 Jul 2023 17:30:43 +0000 Received: by aart.rice.edu (Postfix, from userid 18612) id 2E578C17A4AB; Sat, 22 Jul 2023 12:30:38 -0500 (CDT) Date: Sat, 22 Jul 2023 12:30:38 -0500 From: Ken Marshall To: De Lan Cc: pgsql-general@lists.postgresql.org, Amit Virmani , Terence Yim , Vitalii Tymchyshyn , Samik Gupta , Albert Shau Subject: Re: Duplicate Primary keys in postgresql tables Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > > *Our questions:* > > Any ideas on what might cause this behavior other than the collation? if it > is a well-known issue in the pgsql community or it really is the > coalition that's the root cause, do we have mitigation for this kind of > issue from happening in future? > > > > De, > > Thanks! Hi De, Unless you are having a hardware issue this sort of problem is almost always an unexpected change in the collation being used. You may be able to use the ICU collation that has been added to minimize the impacts of such a change. I would recommend monitoring your collation and if it changes alert. Also, you need to verify all of the collations if you are going to upgrade any OS or container OS. Containers are not magic in this regards. The fix is to reindex if you have a collation change. Regards, Ken