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 1vDkyn-00F9YE-F1 for pgsql-general@arkaria.postgresql.org; Tue, 28 Oct 2025 14:47:20 +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 1vDkyl-00DRcI-B9 for pgsql-general@arkaria.postgresql.org; Tue, 28 Oct 2025 14:47:18 +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.94.2) (envelope-from ) id 1vDkyk-00DRcA-VL for pgsql-general@lists.postgresql.org; Tue, 28 Oct 2025 14:47:17 +0000 Received: from mail-io1-xd36.google.com ([2607:f8b0:4864:20::d36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vDkyi-004DrV-1K for pgsql-general@lists.postgresql.org; Tue, 28 Oct 2025 14:47:17 +0000 Received: by mail-io1-xd36.google.com with SMTP id ca18e2360f4ac-9444425cedcso378923439f.1 for ; Tue, 28 Oct 2025 07:47:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761662835; x=1762267635; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=jupzQKtUPUSbW+jyeIpZ4la1wk8yN8C6pzrpMVXH6VQ=; b=XkqgmlZzvibHhq7KhFR/Kg43qw5n0J3Tyy38YOxAYyjd53bcLb+TtsV8Eo3hDOsqMh IHsWqA8fJRFkNK8+5HNmbGs22ygAxwGgAC2O5wu8q56oQfObLvKQpO+NB29OMNPKvFDV YP694jRmdwEBUHCMwot9yAUEIuthIjQzg6zSKUaQRewbID3UiFa+cVy68uPqZpWy7OyR pGOgjC2swzViLPyD2f11GH26jO/yK0TGzz8VMGp5XnZJoY6BCkAEwV03X11juQkJXXwV tCxZX4/bZa4vF0GHmLzlV1d5W32d/Fbsna2zPusSI6Rcxjp5egZRvrUs0vqG3jke/T/m kfYw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761662835; x=1762267635; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=jupzQKtUPUSbW+jyeIpZ4la1wk8yN8C6pzrpMVXH6VQ=; b=xOu3Tr6IIfYkqOZ+E9Pgti11UtLnXXCLkICYJAFJnt3cRtfrQYfx21uVAo8/SPUH2n KGeBVn+iyZafuzH4Xss60ThxW6Z6ZiTyQkDqztwukMYlkohaZ6bIhNpUFGMdmJtOb/Tx ulhdN6tfRuJgccBev4LQNScarr33npVXqgeTzyoU955fwMn7E1T0nCmIAQkOiO19BD3x ePMG2Z+CoUvQXIAP+o1cKe4aLSrgtEeBCEViOGjC1+vdvhZ2om356fKq7TbQgi2mqyKZ 2EAwGq75G8UAQwMbrrFr9SQsBOeJBTRONsjg6llYb6b4xEHjt13vSP1XiVOTv0NUM+MG pTyQ== X-Forwarded-Encrypted: i=1; AJvYcCUXJ67QTVPIfNZIf0xz1dWhgxJnT3TXbYY1tVVDsd9tIEGD16+qxjo7C1yiHImBE0u2GNVxG5BEwmx7IN8+@lists.postgresql.org X-Gm-Message-State: AOJu0Yy4nXvQYWvXtO1mTByi69bP1qpoGht/0knaeb8M6vMv1W+vBr7T r6Xcbdizi3HV1zrF+QfBGR0zGA3UZNGuHVUh8yMfXvP3TSb8PLHT0/vs1wlrMQrzjiZuHkeqFv2 yUSYT3cmWF0VB54Ir/jJX7WxQv45EiC1uu+qr X-Gm-Gg: ASbGnct3QsUqpC1aChobc+sqXzhFY1W1Nhyo86AxMV1QA0YbW3mifSQQ3QjLx62W/4O Kub/BhYuWinBN32pdBhYESjWNF7CAPJu5U9reG7OIgt6XZBCjdg63s4xBDmYjOkPsGEZnRYfoyf caxGXVFfBSamjyVUThS+oA0Dt0n9OniJalqqbci6XwdpOYz0Qw9aQRgG+5nS7DbMI2cvr8KSXxt BX1ejCfLUja3/H4S2G92E/NMquLvwnILmqJw0ym6/FeoFOmzVPKvqLA0xSjKIymOxEOWhgcK/Dz pUSXsjTEjgtE8E8Hvg== X-Google-Smtp-Source: AGHT+IHQNqPeu0zvNUpo9TwYjuZdeSakY2xJVQZZF7FaZH0IbI23pKBzJB6t8YuhIoq5RHZthNTmedipP+Lr49Nme5k= X-Received: by 2002:a05:6e02:1a03:b0:431:b1fe:147f with SMTP id e9e14a558f8ab-4320f771042mr63324155ab.18.1761662835319; Tue, 28 Oct 2025 07:47:15 -0700 (PDT) MIME-Version: 1.0 References: <1bfa0b6b-11a8-458f-a3f3-3f86574abc1d@aklaver.com> In-Reply-To: From: Greg Sabino Mullane Date: Tue, 28 Oct 2025 10:46:39 -0400 X-Gm-Features: AWmQ_bmdxMgbbDKYvffU_VtP9lPAiTk4Gcej2HouJeg2dVIdWgSlE-xffESGOWE Message-ID: Subject: Re: Index (primary key) corrupt? To: Wim Rouquart Cc: Adrian Klaver , "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000836a890642391710" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000836a890642391710 Content-Type: text/plain; charset="UTF-8" Could you run the SELECT on pg_index after the REINDEX to see if there is any difference? --000000000000836a890642391710 Content-Type: text/html; charset="UTF-8"
Could you run the SELECT on pg_index after the REINDEX to see if there is any difference?
--000000000000836a890642391710--