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 1ts0gE-00DCmV-Sw for pgsql-general@arkaria.postgresql.org; Tue, 11 Mar 2025 14:34:02 +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 1ts0gD-00HKrF-Kh for pgsql-general@arkaria.postgresql.org; Tue, 11 Mar 2025 14:34:01 +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 1ts0gD-00HKqg-9n for pgsql-general@lists.postgresql.org; Tue, 11 Mar 2025 14:34:01 +0000 Received: from mail-io1-xd32.google.com ([2607:f8b0:4864:20::d32]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ts0gA-002F0S-35 for pgsql-general@postgresql.org; Tue, 11 Mar 2025 14:34:00 +0000 Received: by mail-io1-xd32.google.com with SMTP id ca18e2360f4ac-85b41c4fa20so210514739f.2 for ; Tue, 11 Mar 2025 07:33:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1741703638; x=1742308438; darn=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=drgTzjnek9wf7MN4bKy1I5yvVKndbYjAyo4YQIbnzAA=; b=eRHnSkU/g9K04Kb1UEPcsR7hnnFLV34MoDiSh6dbxW9gzU8u2tR05gSxrLJN5m82Q7 FV/FxusmM3VOoRwkfJTfQcYu7WvoFV6KwagB1/651/7rFZ6lvULrqxkihdMX0jfEwAOJ nNbnid1r8YtAZOvDySzRRVvotnqlW4zBcdCLxXAZhxAaJMHT+foYpOCMh6RQmMOaK4TE 6CvH91uX/bUB8SQtHtZo8ycRCcLlGvVWqE6dbi9nLyA5/xi3qfQQnmiXlMufpRrvTrNM 2P+8B/cE2sfWAYSzQxNx9PjB9eYhzAlZzaQdrLoQQ0qCFGM/r4KFKGq/nWU8Zw3h3bJy rRjA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741703638; x=1742308438; 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=drgTzjnek9wf7MN4bKy1I5yvVKndbYjAyo4YQIbnzAA=; b=rvzD2Yx79Xq4D60WrgrPiRHpfDk/ikvl5I+YgZWRyz7JvC+mLX2v+v31x5sDKQ+TvV kvlqsaklQ5qlNH/pbYdgOjV/reNbzstt3bnr4Vs/JtYdLl30wPYM81QU3YRi/UaH99pR QcaSBn0p8nGBC7RbbLH7ZAovsfXjRAjCdRaAGLoHuE/gqw/a78EX51bSYWHuklGcnNIT WwAKcki9VWHR+qn2xzm6dE5JXUmE+LDXx76R/MDLywO66uPk5tgdjSBla2FbWfQ6tJbA QP1YuyrDgiBN9zjD8E2//d4dR9JO1D3ogBg09/YD3R+VJf3uHgl9WXaaozAd3LJQFMao M11A== X-Forwarded-Encrypted: i=1; AJvYcCWUJUaI8XfobpyAryV17wfDkAzvRRhNmIXghqpcNkRmWRmQYNQcikoI8BrZHsCTrDbWYwyq6qZXTlwl8z8Q@postgresql.org X-Gm-Message-State: AOJu0YzJefjcW0wstTle1iWAwGhyvcJUi/KlVMbk4a6lFSY3IuZM6Wq0 Ek9AD90436+78h4WABj7qC9hs0Ln46lx/fIvZwL1u9h9jCZ+jkAfmWiIbYrNIqN0unKrpHzmUs7 yqPSN+vlQZ+LDrdgQIjWaGdgeci6c1A== X-Gm-Gg: ASbGncscNRvzCuv441KdnyKLUfSe2SrQ3cQHrRkvsk6VIPX4Se5+NUX0B9DvP4elgp3 CPs5mfaAv8EM3FdRmkXSOfTivXQPeyLe54lm+4NNNNdbRq7dS7weW6BjKCn58RgrnhRNFFHD3R8 Fki2p73ntjnT+efhOWfsaa9o9JE9+0BAoZL3VZItmDNPVEj9U01sdb2fP5bvxk X-Google-Smtp-Source: AGHT+IFJ84ZHhst5w/uRi2BTvkHOhm2fzox+7EEuWFzeFIwz5RSzlyr+7elCEEc43pGMZdWnilOYk2LBvSBAWmoGEqI= X-Received: by 2002:a05:6e02:1c2b:b0:3d4:3aba:954a with SMTP id e9e14a558f8ab-3d468992865mr41704575ab.15.1741703638325; Tue, 11 Mar 2025 07:33:58 -0700 (PDT) MIME-Version: 1.0 References: <36356aa1-1a5c-44af-a1c0-f190249812ca@aklaver.com> <6aee94f9-d421-4622-bccc-bdac37969be0@aklaver.com> <75b33741-ee99-4524-b63a-edad21c1266d@aklaver.com> <9d919848-3fe1-46fd-b343-c5f2931864f7@aklaver.com> <513ddbee-135c-4af2-b6f6-acca667b8d09@aklaver.com> In-Reply-To: From: Greg Sabino Mullane Date: Tue, 11 Mar 2025 10:33:22 -0400 X-Gm-Features: AQ5f1JoTv2-Hs8oAHZ2IB5tvSZ-EmEXlQ7Fdgk07JiI8EOizrHwdOfm0VgY4ca0 Message-ID: Subject: Re: Duplicate Key Values To: mark bradley Cc: Adrian Klaver , pgsql-general Content-Type: multipart/alternative; boundary="000000000000aaa584063011fa18" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000aaa584063011fa18 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Mar 11, 2025 at 10:29=E2=80=AFAM mark bradley wrote: > An "interesting" effect of reindexing is that all the records that were > dups in the nodes table were deleted, both copies. > Er...that's not just interesting, but alarming - if true. Can you show the steps you took? Cheers, Greg -- Crunchy Data - https://www.crunchydata.com Enterprise Postgres Software Products & Tech Support --000000000000aaa584063011fa18 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, Mar 11, 2025 at 10:29=E2=80=AFAM = mark bradley <markbradyju@out= look.com> wrote:
An "interesting" effect of reindexing is that all the records tha= t were dups in the nodes table were deleted, both copies.
=

Er...that's not just interesting, but = alarming - if true. Can you show the steps you took?

Cheers= ,
Greg

--
Enterprise Postgres Software Products & Tech Suppor= t

--000000000000aaa584063011fa18--