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 1uVAyt-00EnsX-JG
	for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Jun 2025 15:27:11 +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 1uVAyr-002qLw-5m
	for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Jun 2025 15:27:09 +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 <zhong950419@gmail.com>)
	id 1uVAyq-002qLn-Si
	for pgsql-hackers@lists.postgresql.org; Fri, 27 Jun 2025 15:27:09 +0000
Received: from mail-ej1-x62d.google.com ([2a00:1450:4864:20::62d])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <zhong950419@gmail.com>)
	id 1uVAyp-004QcA-1x
	for pgsql-hackers@postgresql.org;
	Fri, 27 Jun 2025 15:27:09 +0000
Received: by mail-ej1-x62d.google.com with SMTP id
 a640c23a62f3a-ae0dd7ac1f5so319803466b.2
        for <pgsql-hackers@postgresql.org>;
 Fri, 27 Jun 2025 08:27:07 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1751038026; x=1751642826;
 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=uXJLr/0w/sUS02eRiXgnFvQXv7v5DS2fgA1bzFOvvU4=;
        b=mYv7axGyVeQtrtVA4Q3S18gJoIz4JSxOEKqjnh6cqzkyCjA8xz1adA0PHION7QiKtA
         LWIruviYH5ndGdKhK5WyTcNPWPM3Gky20lBAfFtn7PhlD2kv7RqsQ5Jq3MzAM6RF5Kdb
         JMPQodhrhhczfrTVHqQtpzGjeoMr6VUbeaBOZPc0Fhn39dP060fdL1ltpZjPnh8o5koY
         JKvXaEbXaGNPJqfQWc+El2hLq8gqWqJmv1VLQb1bnOPn532jKtwCQ77fHYzbr0krOsNX
         E6sL181MGIWdPneVGhtXJlMfKeKKDfI0meMAWMRQW74/kr/VmF0c3wKlnC/gk+573QDO
         aimQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1751038026; x=1751642826;
        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=uXJLr/0w/sUS02eRiXgnFvQXv7v5DS2fgA1bzFOvvU4=;
        b=lHZSa2ryo+Xl7G8bYElBtVLCFm9PkOAXrK3YiKe+TIyHoLA4P/TQMG6eRHr5QrJ/0Q
         UMOUEbnkIl0em/AkzryhYDxWlXFPONXIiQDVr1nvv6qZPRZzs6TFE4IawQ++QIEdPSZu
         yBBgr82TRvw0L2Nn4pl2xT5SuwiA84M4HxZ7VCufmjEEqXIlZXY9MJBZMzF9+HC3RUGl
         p1t1xfWlHxYPSHRc5XwZmK2QIGrFbs4KkSAy2Tie937pdjyfKfU1jSlsiJjyJ8Pn8/Da
         My+k2Cuu1rIbIhp3+1OVQ02/6lPFVHjIGDD/PoQFhcMP9Pls4FweBWXcebTuT0xpn5Bi
         EKGg==
X-Forwarded-Encrypted: i=1;
 AJvYcCVZH9+N+nNf7jC4HnG6ay1oLUU3hMHl2LkZV+nJoxFjl6fr/2GscDPodFEli5BmZos7fXWWKoxeQgfzXHhA@postgresql.org
X-Gm-Message-State: AOJu0YzeKLQ6FbmwTKM1Zk23w67QXImqdZHgBA9Wzf8fpeV9iC8DOmdn
	WmdU6TC7UK1W+yWXZJoL5ZA5tPAKvYt/PInZ6Pzf0eeMX0pShYXqZVYgQYOeClsKCAFrBQs1wBL
	w4QSimuNs/hJjgY8dEfmABLiQ8KeuKYySIQME
X-Gm-Gg: ASbGncsUv6enj5IH01HvSCqMXibWdIdvJJ45NadMqZyhgFeQeQxRcJV+IkZyBBxF2YM
	9G60APPU2/JHNkuB7s98Wgjv4myP8AOit2DBh+oh1DMVI/JRECKjkFStPeYMn8uFxiB5nWLDvhJ
	mPWc+gKrRNpIOB6UmGlist1vJJqFsQqIQZ1TFGYhmBTTcD+vgj7PEsNPUsrTxAYdqVj/Ge6E5kF
	Q==
X-Google-Smtp-Source: 
 AGHT+IHaybVsGQ7gdp8sIEJtwUDtmyp+rDh9CoAMhzsT4SO3Uvr/RTlw2UGdiDp/H/stAIu4xzDCLVEv7nsJ0io+c8o=
X-Received: by 2002:a17:907:2d88:b0:ae0:d4f2:dff3 with SMTP id
 a640c23a62f3a-ae350238d75mr385078066b.58.1751038026250; Fri, 27 Jun 2025
 08:27:06 -0700 (PDT)
MIME-Version: 1.0
References: <aFRzYhOTZcRgKPLu@nathan> <aFS6m1tNH2sGMQ61@paquier.xyz>
 <aFWznvZtYZ3VJxgi@nathan> <aFiWUzW8VChL-hGg@paquier.xyz>
 <aFl1AB9ofnQrrckV@nathan>
 <aFn82kXgvwKHncs-@paquier.xyz> <aFrSlSz9fi47j5Sr@nathan>
 <aFtRd1Q4QuCWcg5k@paquier.xyz>
 <aFwT31Rw-Oj-bgO9@nathan>
 <CAGRkXqStMeemxvmTKxKxb5eD+pWNnLLDYGe1qOEF9EwKh+Gp_A@mail.gmail.com>
 <aFx8emVq6osywHc-@paquier.xyz>
In-Reply-To: <aFx8emVq6osywHc-@paquier.xyz>
From: shihao zhong <zhong950419@gmail.com>
Date: Fri, 27 Jun 2025 11:26:54 -0400
X-Gm-Features: Ac12FXz10xcSsemSz1q_R-bjeI-Z_DY8XLIsFJHSSFZWwjoTPMQHD2-gDrNz-7E
Message-ID: 
 <CAGRkXqQGQXowEknn-fmVrUeU_jfT2-hrPD_hXpoKF5bXUApE0Q@mail.gmail.com>
Subject: Re: Fixes inconsistent behavior in vacuum when it processes multiple
 relations
To: Michael Paquier <michael@paquier.xyz>
Cc: Nathan Bossart <nathandbossart@gmail.com>,
	PostgreSQL-development <pgsql-hackers@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/CAGRkXqQGQXowEknn-fmVrUeU_jfT2-hrPD_hXpoKF5bXUApE0Q%40mail.gmail.com>
Precedence: bulk

>> Making the index cleanup stable takes a certain amount of cycles,,

Thanks for your explanation!