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 1sXRwr-0046HH-4N for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Jul 2024 20:53:57 +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 1sXRwo-000CCY-Cb for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Jul 2024 20:53:54 +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 1sXRwo-000CCQ-16 for pgsql-hackers@lists.postgresql.org; Fri, 26 Jul 2024 20:53:54 +0000 Received: from mail-yb1-xb2f.google.com ([2607:f8b0:4864:20::b2f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sXRwl-001dd7-HT for pgsql-hackers@lists.postgresql.org; Fri, 26 Jul 2024 20:53:53 +0000 Received: by mail-yb1-xb2f.google.com with SMTP id 3f1490d57ef6-e02c4983bfaso89578276.2 for ; Fri, 26 Jul 2024 13:53:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1722027230; x=1722632030; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=SaYgUUA3Ip8HXvHiII2De0R5gLUA5hELGHZg/DVhlZE=; b=le6UyYlC5ptV4GB+CZITDzBgypscEp7k5gs9V78iCdhlcYqG8TT6WFqt9tlYPaKkmN PRz3K2tFFSJwoEpbNYhQGMELRyrzqz2vbSO+JdOagegdlaXQbuKOZjbPceX0He38MO0o GC5/ywfES4x0YSJR0yya6yHnY8FNDDulZx/wIGgn5YmVSxDteAAIM1qt/3wUSHh55+0z kNLlswxKtEEYN2yUnFLZvhexagI1aBGYKgCWwxSBJ/kUiPRAE5JzIgVvWhgvG0eCInmC 2NbYZaCfm6eUi1EIpa/arqGEtSGeAYJQAhPVpDI42S5mJBm9KG8pQU7uZmGjzPw3fj9i Dmdg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1722027230; x=1722632030; h=content-transfer-encoding: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=SaYgUUA3Ip8HXvHiII2De0R5gLUA5hELGHZg/DVhlZE=; b=seCjhf+sZDEBfB4WMmMhCPr7hJtazIklNyCu0ah7qs6Fl+FOfVvw3m7HbcaoIUcsFI f8hrRNFJkt1hvGWnvQOXvOFUei5QP+lgO65u0ZKyAbUnA+pvKIelBm/oAIHeSs2qKQfW qnfnZyvc+6oOoNaehTxastXbEk+bkYFXxsESbMFIKjDdnxCoCc70MmsqMqClsLwUOLUH YsOZgPAjRIZT3yRLLMznuOkY83LSt3eS87Sxp5MPuUq5flcU3iQWX34YSAZ0ocWRgIAD 23860iIBYEJMmvbW+qNTGc1eyTJAwYtPv30mkYQGN2T4VJ7aGJiXyFjxkYFjxNBjlGN/ s37w== X-Forwarded-Encrypted: i=1; AJvYcCUKksiqj7ARCbrfoqf+Jxj5XKGZkjM+8yJTIiYOpAIGq+uE5Se3dozWT6ODJVfwbFPrSoC53ccItlKfnvlnFDJGjM0zD85NTBWgKD49llqlXe3p X-Gm-Message-State: AOJu0Yy1wB2bQnUr8DtyFWFXiAOgWF5cx5ardcMMQ449aWMBI6N++rGx IiKgUKrN2SLfC48PIOXTwBTuv3x4uGocMDbG2arGMRigsrScxYrbE7C4U00LHqMZcWn9MbYxj+9 bNvTZnGrwx7unDzbyB9wdcEcD7Ro= X-Google-Smtp-Source: AGHT+IHxUyee0bWvbUSgK0PSRXb+uF3uwz0f3UDitpOOn+FlCssfzrNX0jEey1Usos62uaX+ElsJXf9k7GB4AJimcT0= X-Received: by 2002:a05:6902:1141:b0:e08:6e2c:69ee with SMTP id 3f1490d57ef6-e0b5440200bmr1280927276.10.1722027229890; Fri, 26 Jul 2024 13:53:49 -0700 (PDT) MIME-Version: 1.0 References: <20220922151328.lakwdytvwnyyif3b@awork3.anarazel.de> <8c74cc5e-4b97-4cd7-9aaf-67886822a78c@eisentraut.org> <20240501022412.85@rfd.leadboat.com> <1375614.1715301775@sss.pgh.pa.us> <8635D8B1-45B7-4D67-86C7-D6ECB4F10B11@enterprisedb.com> In-Reply-To: From: Alexander Korotkov Date: Fri, 26 Jul 2024 23:53:38 +0300 Message-ID: Subject: Re: [PATCH] Improve amcheck to also check UNIQUE constraint in btree index. To: Robert Haas Cc: Mark Dilger , Pavel Borisov , Tom Lane , Noah Misch , Peter Eisentraut , Aleksander Alekseev , Postgres hackers , Maxim Orlov , Andres Freund , Greg Stark , Julien Rouhaud , David Steele , Peter Geoghegan , Maxim Orlov , lubennikovaav@gmail.com Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Jul 26, 2024 at 5:38=E2=80=AFPM Robert Haas = wrote: > On Fri, Jul 26, 2024 at 8:10=E2=80=AFAM Alexander Korotkov wrote: > > The revised version of 0001 unique checking optimization is attached. > > I'm going to push this to v18 if no objections. > > I have no reason to specifically object to pushing this into 18, but I > would like to point out that you're posting here about this but failed > to reply to the "64-bit pg_notify page numbers truncated to 32-bit", > an open item that was assigned to you but which, since you didn't > respond, was eventually fixed by commits from Michael Paquier. > > I know it's easy to lose track of the open items list and I sometimes > forget to check it myself, but it's rather important to stay on top of > any open items that get assigned to you. Yes, it's a pity I miss this open item on me. Besides putting ashes on my head, I think I could pay more attention on other open items. ------ Regards, Alexander Korotkov Supabase