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 1vl8S7-007b79-0X for pgsql-general@arkaria.postgresql.org; Wed, 28 Jan 2026 16:31:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vl8S6-002Quo-0B for pgsql-general@arkaria.postgresql.org; Wed, 28 Jan 2026 16:31:34 +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.96) (envelope-from ) id 1vl8S5-002Qug-2J for pgsql-general@lists.postgresql.org; Wed, 28 Jan 2026 16:31:34 +0000 Received: from fout-a5-smtp.messagingengine.com ([103.168.172.148]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vl8S3-002lNQ-1a for pgsql-general@lists.postgresql.org; Wed, 28 Jan 2026 16:31:33 +0000 Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44]) by mailfout.phl.internal (Postfix) with ESMTP id B8623EC009E; Wed, 28 Jan 2026 11:31:31 -0500 (EST) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-04.internal (MEProxy); Wed, 28 Jan 2026 11:31:31 -0500 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=fm2; t=1769617891; x=1769704291; bh=maA9LxHHQioIj/dM2RixAh7/Eo33lgzYmrsoYQWpovU=; b= OZZ5mHBdzf/OlPSbt3JCO8U4E2Ark2ZHDYWwIdf8XLowrrRbTZTOs9H7t8nbOYaw OuqrueqQk3jsQqF3e3rZ4+6wGoiVGhnJHrIie8Htdq4vPsYPLDzUGwWofuHrNr4G jD7Yl8vrY84HyJqoHjkeyYo1jaMES2wGdspPnr+RC3SHiqAmlj24M6h9LyGjjWcV jrFwFwFvcUyKCEeaKyKCS+Br+sER9DOhJM6ovTcoO1q0pLxTtAURzgS/YzYeW12i ERZLb9O/39wPKlZrKZydrNSRxKhkGMnHGzaAQELqDhiNLYYySFxCCenz3DGqG7Lc W212bviCSDqcs6829A89aw== 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=fm3; t=1769617891; x= 1769704291; bh=maA9LxHHQioIj/dM2RixAh7/Eo33lgzYmrsoYQWpovU=; b=p XdhVkFlSL4bT80w5jabckeYPkIN8WJ/hGz0CfkxEfRsoTcLbmNw9T5nEpf9pDy4l hMNwYVH2AcN3p7QRmnMAHoiuyCbEkzhRwcaf7/iz8CvV47Yjli2mjzLKtRDreCbG KPapEnXutRrQNfFy3Q10zN87lOlIgqvAZuW2ugmnkl3ckHbURnPbA2eEJotm+DbM NqMeEeBnC7AbkXwUJ3NT8iHZ9lkXlyPUiwGAifvmC3DgBgRkKA35j7WrSoCNeki6 B4a/Nr4JPGRnrEgdt707wTmgZosi7S8ze/7roue/FJ3O1TNo1+g9GX9dGUy8yaGW ohiOc0YZBqZ5xs9p5aYWg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgdduieefkeduucetufdoteggodetrf 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; Wed, 28 Jan 2026 11:31:31 -0500 (EST) Message-ID: <24e41f94-83f9-42d7-b9a8-dfba713d7ab1@aklaver.com> Date: Wed, 28 Jan 2026 08:31:30 -0800 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: <1bfa0b6b-11a8-458f-a3f3-3f86574abc1d@aklaver.com> <5043ff13-2f39-4a80-a8f8-6765746b6a89@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 1/28/26 03:02, Wim Rouquart wrote: > Internal > Define 'corrupt'. > > -> Well, it's not behaving as it should, let's keep it at that. I don't we can, the heart of the issue is something happens to the index that causes it not to transfer properly. What causes the initial corruption is relevant. -- Adrian Klaver adrian.klaver@aklaver.com