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 1v00Qd-009SyV-2i for pgsql-general@arkaria.postgresql.org; Sat, 20 Sep 2025 16:27:15 +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 1v00Qb-00DSpV-4O for pgsql-general@arkaria.postgresql.org; Sat, 20 Sep 2025 16:27:13 +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 1v00Qa-00DSpN-OE for pgsql-general@lists.postgresql.org; Sat, 20 Sep 2025 16:27:12 +0000 Received: from mail-io1-xd36.google.com ([2607:f8b0:4864:20::d36]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v00QW-001tMW-1S for pgsql-general@lists.postgresql.org; Sat, 20 Sep 2025 16:27:12 +0000 Received: by mail-io1-xd36.google.com with SMTP id ca18e2360f4ac-892db7eb552so400774239f.1 for ; Sat, 20 Sep 2025 09:27:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1758385628; x=1758990428; darn=lists.postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=ZOqbf0IPCs6yXwl2xdMye4ArgchzJM/dddBKz7VlwqY=; b=IIMCp84+0QI/SUsKiuAU+OCPBY15wnE40wasVbzj9+gDlIJg6Nb9bYryx22qF+BLYT dOUAR2WHxjhpAlFj4WzMSzb2ZszjpvVCMHBFaAOkLpyJOMpV2Kg552RtCWJn/J3chX2I 8l79x8LxrdB20W28Fwbnc7ILd0NCUak5K+TXOLiOUQa3S1B9xc0EAlDa4Rs2GomS2SvW XlYL/pYoc8mR7g9Lf9F2yY/MM/ETsAWuY+iWTA88D+h3L/EE7ab6bYa/AQqANboovsxz 1avCs4c5dY97Pc2N41CfUGKVnUE6swnEXcQ1nzpSO7Eco4adeaFQ10rJx1vorpUNIU8P fRnQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1758385628; x=1758990428; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=ZOqbf0IPCs6yXwl2xdMye4ArgchzJM/dddBKz7VlwqY=; b=Vah4u0zVfCSx+h58Dqf7DpKYOwBHecgMoiehhazwSpJMk2F/fJ5k4EoR34ndT/pdmL lnDwkxU81/Ed3GvYxJoj0uuCI20UjWabGRSbtXJKxuN+vSV7DT+IG2QtyyRz7+tSDagx rQDfaV6ejGPkqZ5UisSPEHPX00ktW/48+g0YOz+BMeo/Tkrr6uWK1pxH97KFVPZbVGe0 NZYq+ie5RN1r+jko7dDCXCfE6mQB9E0S80mQKwBclF1rQT44W0r7JDU8tYc1pSyPx+xk 2SMZ8KZW0O6KU0xg6a+bozoKwWhghB9LnPTQ4bY+4eV9gCeVZs54+bZL/NGdYDPW6vc9 J5Dw== X-Forwarded-Encrypted: i=1; AJvYcCX33mmDlpb02XvApSo4fICBkJN+AnYISFIZQbDT4pbA4Bom938uEZTbRwSbog5e5Ze8NJawTyiTgjHEJZRk@lists.postgresql.org X-Gm-Message-State: AOJu0YwFAL5hkOOMhKGhdew2tiKXhakmSfJdup6t4mYuRr7lt3o3f2YH EukukTWZWJj0Dx8qf2C/75Lpi0Vcd97vTgzVLQP9ZSTg5PiQFMe7xOOgKXoQ8xOz X-Gm-Gg: ASbGncs5uA1Q3gG20ibdSCqS9Dzn86GQJxIuww2rOv4LhiphGVTJVV8pSPv6S1BOk+s a6QZHbrNHfGUOU8P9Dh1loUGRT2c92ugcbPUfgeonKiKAND4vi9c4xGrZerBFwRAb6i66elo7c/ kjO400kZ6UWt61WYCCb01MFYM0dEIFfFzg9eOsr8Of8cyZi+KU6Q28SjkaZyCS8UsoE3BtG7lEa 49ZlXctT5X8gmpH4qxh/VX6pvF+YpgqEL4lxRFebh+TnXQM4vt8GWiKkx0XRrgukG4tKbdVhypD Dx/adMF3MSC0hPuaC9HswECmzeDmi6uIFCbL/afplEoZfiSeajIrfxH5Ismmgu0X2HG99WOT/PP aNglUV67fqx2MtahIPh5AlygwME7kUHygr88Ymta4eY3aYAt8qt14phymTimwZuwviHbXpDIiHv DinIXExDc= X-Google-Smtp-Source: AGHT+IGQB8DN3UF71uMx/v33KdxaS/UBdcSsVwCs8TFRDCnj26rXLjA/bsjZ/Z24wPO0vGJAQAXttQ== X-Received: by 2002:a05:6e02:2167:b0:424:7f5a:9423 with SMTP id e9e14a558f8ab-4248199c66cmr108331805ab.19.1758385627750; Sat, 20 Sep 2025 09:27:07 -0700 (PDT) Received: from smtpclient.apple ([172.58.164.189]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-53d3a591048sm3556789173.14.2025.09.20.09.27.06 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 20 Sep 2025 09:27:07 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: Rob Sargent Mime-Version: 1.0 (1.0) Subject: Re: Index (primary key) corrupt? Date: Sat, 20 Sep 2025 09:26:55 -0700 Message-Id: <8BCB3E64-990E-44A9-A0BB-079CC4C43820@gmail.com> References: Cc: Wim Rouquart , Ron Johnson , pgsql-general@lists.postgresql.org In-Reply-To: To: "David G. Johnston" X-Mailer: iPhone Mail (22G100) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > So the problem goes away once you=E2=80=99ve reindexed yet you claim it=E2= =80=99s consistent? What are you doing to get the problem to recur after you= =E2=80=99ve done reindex to make it work? >=20 > David=20 I was assuming the OP has a dump of the affected condition and is restoring= (and perhaps re-fixing). No? >=20