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 1uzzRQ-009IVj-EX for pgsql-general@arkaria.postgresql.org; Sat, 20 Sep 2025 15:24:00 +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 1uzzRP-00DL3F-3h for pgsql-general@arkaria.postgresql.org; Sat, 20 Sep 2025 15:23:59 +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 1uzzRO-00DL1Q-NW for pgsql-general@lists.postgresql.org; Sat, 20 Sep 2025 15:23:58 +0000 Received: from mail-ot1-x331.google.com ([2607:f8b0:4864:20::331]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uzzRM-001SXu-2D for pgsql-general@lists.postgresql.org; Sat, 20 Sep 2025 15:23:57 +0000 Received: by mail-ot1-x331.google.com with SMTP id 46e09a7af769-758a28587e5so3807079a34.1 for ; Sat, 20 Sep 2025 08:23:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1758381836; x=1758986636; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=iLVbUeKLNzF1L2y2OojF2U4MlEbeMhslN5l9muWHtWA=; b=GbqGtKUhBwahdv+kh9AJjL9Bj3t3aBXE0qtu7SWICdRhT+NmWZJoCBkHaOilVAFLmp xzGWwZx94DvzNk4F4HKWIA1wEo5j9MHXqJh45FBH/4rh3fbID5UT/is8C8KmPJ9Ix1/l uFKKy9yMiK1Nz7Kcqkwh7eQtsTaOh22/WzXMg8sOfykevPQbC1iD/6zGzPpneb2WFLYc rD4zTGA7x5RD501H6mg8JDENbDDcfG/o6R+9xq1NZdnudSIysRdOhyZuUslo7KfigvVR qG6q7o5O5AfkzS9MzGXEInhS/6fiomUoPG0Bbo4ufDwBwFhKD7owm9bN9vBiIqvwgeBm Gl0Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1758381836; x=1758986636; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=iLVbUeKLNzF1L2y2OojF2U4MlEbeMhslN5l9muWHtWA=; b=MyMqX5J80qJXI7q/qNaKIquvMBTVN2FQM57hVjRqIMvx5OIG6s2F9foTxMNzTtTfW/ hyu7rUh/ulX3w7+qKitoIgisqriQER/KCVORrMf2c63QG99lMECSyrxaU/W4+7wtKDXt eY7Co/+DLo3bzlVeMubNY5m7hAElkfeU3PDxS75EWPfsYIXrQnQNIAYG4FlZNOYVuzAj xpPMe1Dl7E/VruHcBvC0YGRRWDADeJ9BwwzriUK2KVlyD46ppqSGthvhlblarAzzCa8O Im8moATYkzs4dlWM+Nf/9xmfIx1GxY/7NTFIlrX+9m/a/nVC+wYme4qmfURm4/rrVKTs fD/Q== X-Forwarded-Encrypted: i=1; AJvYcCVCoNOJgW3l+PJy1aILEltelHFvq/7oIgpBBXMx4wJJvYdJzT4GYqCfmGi/HZvzfOXyVw9UuSwaQTnbwg7d@lists.postgresql.org X-Gm-Message-State: AOJu0YzCJHurtd0FgSGApHBMNE5VAC6Oxa7dvrxTdB8oUP+y/k+1gOkD OOZcsPpCsytg5iT3OqsJHTkSo2sCGhEoZoabu6LqunTNsH2jdZaFV4Kt/SWPTPzSra3OHjuXCD/ WKbTnpHXqo4d+sts5N6V3/Jjc7GIuMIA= X-Gm-Gg: ASbGnctbAttuwMCK04eDkcP/7QpLbPeU2YdYzPv9M3MR7BUEeXXRHf4PoWx3CE9GjRe EAeSWHgQEFy6iyIxPovYePYXDBVIPUG3A/2xRU/fYZMzWu5e1nABQHH0hZsc+fHtKkXtiWuvgrP IrUDGfev3/Qi0UACD3G16qGgnARUGhVFzncifEmG5SPSDqvCfZzTliVvx3Q2hIdPifeDOr7b7eU 8+mbg== X-Google-Smtp-Source: AGHT+IFJcMCPqfuMIKSvA0ebZMrEf4bhKjUAaInUVRChT1cyGfybTkuTB98fAbmbKXJhknGBehzD4xUwjCPds46X1QQ= X-Received: by 2002:a05:6808:67c9:b0:43d:28fd:610e with SMTP id 5614622812f47-43d6c12c1d0mr2856999b6e.9.1758381835714; Sat, 20 Sep 2025 08:23:55 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:6802:498f:20b0:5f3:5bf6:6b0b with HTTP; Sat, 20 Sep 2025 08:23:54 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Sat, 20 Sep 2025 08:23:54 -0700 X-Gm-Features: AS18NWAVgJa9VSwU-AqR33-HDUfTE1EonujhmoARJ3Fu0ItZikv2cnayZJtQVmY Message-ID: Subject: Re: Index (primary key) corrupt? To: Wim Rouquart Cc: Ron Johnson , "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000b28493063f3d2c63" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b28493063f3d2c63 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Friday, September 19, 2025, Wim Rouquart wrote: > > >> Does this problem keep happening, or has it only happened once? > > > > It is consistent on this database/index, haven=E2=80=99t noticed it anywh= ere else > yet luckily. Seems to be a one-off. > > 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? David J. --000000000000b28493063f3d2c63 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Friday, September 19, 2025, Wim Rouquart <wim.rouquart@kbc.be> wrote:

<= br>

>> Does this problem keep= happening, or has it only happened once?

<= /u>=C2=A0

It i= s consistent on this database/index, haven=E2=80=99t noticed it anywhere el= se yet luckily. Seems to be a one-off.


So the problem goes awa= y 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 reinde= x to make it work?

David J.

--000000000000b28493063f3d2c63--