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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1uqZz3-008ucs-Po
	for pgsql-hackers@arkaria.postgresql.org; Mon, 25 Aug 2025 16:23:51 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1uqZz3-00BHNw-8U
	for pgsql-hackers@arkaria.postgresql.org; Mon, 25 Aug 2025 16:23:49 +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 <mihailnikalayeu@gmail.com>)
	id 1uqZz2-00BHNo-VG
	for pgsql-hackers@lists.postgresql.org; Mon, 25 Aug 2025 16:23:49 +0000
Received: from mail-vk1-xa35.google.com ([2607:f8b0:4864:20::a35])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <mihailnikalayeu@gmail.com>)
	id 1uqZz1-001ghB-0j
	for pgsql-hackers@lists.postgresql.org;
	Mon, 25 Aug 2025 16:23:48 +0000
Received: by mail-vk1-xa35.google.com with SMTP id
 71dfb90a1353d-541f5f6385cso295929e0c.1
        for <pgsql-hackers@lists.postgresql.org>;
 Mon, 25 Aug 2025 09:23:47 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1756139027; x=1756743827;
 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=s55wd1zInv1r4JWAMTDSj+FMGfqeXX29y6lnd9j0y9w=;
        b=lSr2H2ipVN/OU0dsHeVyMNGw2Qw3tIL+ugCwP9SbayvoYSIJnRotzRjHqyehp84vup
         W8yTjPSOdFBHY94+fa/SqJJd/MWIet+h4j/QB9K/UixMLEvzlaiV19WRT4LMjqZliVN5
         6QDmbWtqlKRG4ADerwlRth1ct1PEYMoqJDvZ3l7mdi+pimC+9KyRMqNgQZCEjbuuVkkt
         fdOKUY4p4TJixZYefJk4/urE+P+QGebMjKcJuHKieavbUKyZj6j6sjCZrYUfc7mj16NU
         CMc6HeXLCyKVuFeN9n77TyJVDmP3Cloq46Jb60BxkEkSxwTjqdekgEWY1Gcx0JjhVhnw
         ZjFw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1756139027; x=1756743827;
        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=s55wd1zInv1r4JWAMTDSj+FMGfqeXX29y6lnd9j0y9w=;
        b=rywXURM3CaFbjh4G23Im/qk1iMirPQ4hLejPnnWPIkLD9YTQEfdAuvJz5qn74xJT4S
         qLM6RKy90HaqkpyK/JS4WWkLBELp/mxod2y5HmH3012D4BhbK2sn/Hu2upv7gv8ariOB
         KT5rWyHmjzbmI90XSxYhCnvrftfAsO8BmDeOMW1F4OTc7RvlFXzBaPcsc2KmmMZn1G5y
         UnmseWnxc3a79c1E6XvlelvosaJagPwgQn6mUpooQv8h+HPdyNy7mR734OSPF//JpjRO
         zcyB6CG2whsduMKP6NnkesZF7uy2d5nQvRPIL7/b1EBiLM1LlyCNKXe7GpOlCdK6/76Q
         LDvg==
X-Forwarded-Encrypted: i=1;
 AJvYcCXrcMiKtaTwhSHFUa9hj2CCoSt4apguch8VIA8DaPkKcVCRAKDpwdIh0exhVWeiZ0tU4eoFCKepAP7lVmwl@lists.postgresql.org
X-Gm-Message-State: AOJu0YwTqLWuaZx3zERwJ7M4ibpqMYTX6r8hgFB+gUeIZIwWUDza9OE8
	QpJVaf3nVvkuNqzFgv7xDM6EOrTLkzUDQl8IVe2dhW2Z1a6wH15SGoBToYIC5oUJ6WZ728kOVDj
	gWbtDXSLo29mKEppB2mZ2pyfWEANB9pg=
X-Gm-Gg: ASbGncu6yfFOzcxdAt+exLtWxHd5f3zPpchB7dzXRjsm6S5l2uy0CkJDea5aHec4hCb
	Uu8aXUrSGGoo4oMk3pxCbFAVQUac6fFQCR1rVQwLDwkoLmMhD0O+YJpgUm478yoHA2fQrMnzjZ3
	tRxexrWz8N16H3jMuAph619SBj1YFaEROaNojbMAizCCqGMntW8Fn6DZbxHn/etqZyXUI3P6j4K
	OMDM8kX/bn7dcNS8oT5J7uhIKXsmpSZcBpFVKvOThzmOIMNv09c
X-Google-Smtp-Source: 
 AGHT+IHO4pF3pojf2lcCXHhLvq33CNkQdclGLyZLwpKqXBKyGyJmgQM7XrvRhDSQUwSHrXgrxCK674r/WZ+Z0P/a4CU=
X-Received: by 2002:a05:6122:d98:b0:53c:6d68:1cd0 with SMTP id
 71dfb90a1353d-53c8a3feb15mr3884854e0c.14.1756139026594; Mon, 25 Aug 2025
 09:23:46 -0700 (PDT)
MIME-Version: 1.0
References: 
 <CADzfLwXx46j8KwQjjM1ZcqNBsx-k6GxHOzDJkm4SHjh+cv31Rw@mail.gmail.com>
 <202508091333.qvgvo7ikuezm@alvherre.pgsql>
 <CADzfLwW=b=U3e6aasi=XorN8hZSiCKZErKs9qhyK7m=w=wokAg@mail.gmail.com>
 <40729.1755799624@localhost>
 <CADzfLwXpyzGGVB+nbSAMBWDBhzTyn6F2hRrAqcyJd3c6gT2EOQ@mail.gmail.com>
 <9536.1756127358@localhost>
 <CADzfLwWdw=5KhXE5Fr3khytp4mW2girFVJHHb4jSgEncc6237Q@mail.gmail.com>
 <21931.1756136535@localhost>
In-Reply-To: <21931.1756136535@localhost>
From: Mihail Nikalayeu <mihailnikalayeu@gmail.com>
Date: Mon, 25 Aug 2025 18:23:09 +0200
X-Gm-Features: Ac12FXxj1f08vbR6fW5Nqz4TIxcJWw8Uu3XINFt9Xw5VkepDZRpLrs26V0uL9WI
Message-ID: 
 <CADzfLwWPihwPM=e=EJ_U5niqDdVyq9pS30ZNxwZ8f_yXyikooQ@mail.gmail.com>
Subject: Re: Adding REPACK [concurrently]
To: Antonin Houska <ah@cybertec.at>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>,
 Fujii Masao <masao.fujii@gmail.com>,
	Robert Treat <rob@xzilla.net>,
 Pg Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/CADzfLwWPihwPM%3De%3DEJ_U5niqDdVyq9pS30ZNxwZ8f_yXyikooQ%40mail.gmail.com>
Precedence: bulk

Hi, Antonin

> How does HeapTupleSatisfiesSelf() recognize the status of any XID w/o using a
> snapshot? Do you mean by checking the commit log (TransactionIdDidCommit) ?

Yes, TransactionIdDidCommit. Another option is just invent a new
snapshot type - SnapshotBelieveEverythingCommitted - for that
particular case it should work - because all xmin/xmax written into
the new table are committed by design.