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.96) (envelope-from ) id 1vzbyi-001A5V-0U for pgsql-general@arkaria.postgresql.org; Mon, 09 Mar 2026 14:53:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vzbyg-00GtwP-1x for pgsql-general@arkaria.postgresql.org; Mon, 09 Mar 2026 14:53:03 +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.96) (envelope-from ) id 1vzbyf-00GtwH-2Y for pgsql-general@lists.postgresql.org; Mon, 09 Mar 2026 14:53:02 +0000 Received: from fout-b5-smtp.messagingengine.com ([202.12.124.148]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vzbyd-00000001oVU-0ncJ for pgsql-general@lists.postgresql.org; Mon, 09 Mar 2026 14:53:01 +0000 Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44]) by mailfout.stl.internal (Postfix) with ESMTP id 6D38D1D00124; Mon, 9 Mar 2026 10:52:56 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-04.internal (MEProxy); Mon, 09 Mar 2026 10:52:56 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1773067976; x=1773154376; bh=Gt43wk0+epKFCvS2/jJJxSXsMyjdA9fuC7OZBad3ofk=; b= P4J3uI42ESRWs2LrvHfTdVY5IoR16hwmTRSRmlKbGtIGMTyaPaXVIPueyEnNf++d XqbZLqVwDTX+U6O0yys3MVQ5GCuClAjDWAVPqhwJLZLDomgjoZ8MsB78U9S6cvgf D1qBtMrlkDz+n1az/9nZ1AVNtT07ASRDDe6Nu1XhUBmkipqYdsP6jbUGbdQEnSOl UOhgN1CCoQL+ZHMTs6CmT6IA6JvbBEe/NHD1pqi2RSbqmxJAk2XGnOjjV1Qbx5GG zuzt/j375+HkrsSo6ii3LvTxVEt83NTe4EOp6qcb5x/qCs9ZKMS5fEQLOhkmFkQ6 lcMYHyNhukElAYZ2CetcCA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc: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:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1773067976; x= 1773154376; bh=Gt43wk0+epKFCvS2/jJJxSXsMyjdA9fuC7OZBad3ofk=; b=y n+Q1iwXr6pigcNgkfaVujcnR/ZU+aZz2TKfHBPlIXX4o4KpJzmhiQLUpz42dIBvC dhgLltn0YQfpRXBLgwFDto2PBHiLKGuBnUUuyp3NJgygGW5LCld7DAAwZKnYDN+V cLj8RQgd8fxgnvGWdfmPhTeCuPpP+yv7uQy+EzUN6BKaOoBcmT8F9cA0i0qtIhkl ExgH3QJHMzpDiCf6KC5TBByO3GHXRORG1DH+byiGbD83F7DuhGaOEhFgJ1uGFVwm d33fp6XPj6wwacxa6nhzeJWT8qlgTZMsCyLzzCjaa0C5OdrHLqEK4Qvnv3l7QS0y W+LXd7uhYmxQSzyQvuh5w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgddvjeekgeduucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpeetughrihgr nhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomh eqnecuggftrfgrthhtvghrnhephfeviefhveelffeftdehudekveefhfeftdegieefveet fffgfeehtdfftedutedtnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrg hilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomhdpnhgs pghrtghpthhtohepfedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepfihimhdrrh houhhquhgrrhhtsehksggtrdgsvgdprhgtphhtthhopehhthgrmhhfihgushesghhmrghi lhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhgvghnvghrrghlsehlihhsthhsrdhpoh hsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 9 Mar 2026 10:52:55 -0400 (EDT) Message-ID: <3c4bb1e3-529e-4fbf-8fb9-608e670d45b5@aklaver.com> Date: Mon, 9 Mar 2026 07:52:54 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Index (primary key) corrupt? To: Wim Rouquart , Greg Sabino Mullane Cc: "pgsql-general@lists.postgresql.org" References: <58221272-d684-4799-a113-d5a5031a0b05@aklaver.com> <25b5291f-a3d3-4655-a3d3-57f28b70ec5a@aklaver.com> <78328b08-249e-4251-8a10-b5dac183442a@aklaver.com> <0868c260-9812-4629-b32d-026c1fe6089f@aklaver.com> Content-Language: en-US From: Adrian Klaver 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 3/9/26 7:12 AM, Wim Rouquart wrote: > Internal > > I already saw finding the actual cause as a 'lost cause' as these things tend to happen, however what bothers me most is that a tool like amcheck which is supposed to find corruption also shows up with no result. That assumes the corruption is something that amcheck checks for. -- Adrian Klaver adrian.klaver@aklaver.com