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 1uURw0-003SMI-KD for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Jun 2025 15:21:12 +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 1uURvy-004juj-Lm for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Jun 2025 15:21:11 +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 1uURvy-004jub-Bt for pgsql-hackers@lists.postgresql.org; Wed, 25 Jun 2025 15:21:11 +0000 Received: from mail-il1-x133.google.com ([2607:f8b0:4864:20::133]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uURvv-003wkL-0R for pgsql-hackers@postgresql.org; Wed, 25 Jun 2025 15:21:10 +0000 Received: by mail-il1-x133.google.com with SMTP id e9e14a558f8ab-3df2ddd39c6so5837045ab.0 for ; Wed, 25 Jun 2025 08:21:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1750864865; x=1751469665; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=v2Gtb6hLceU7PpotZhJ0ji3J3xPFUBiDKJdkwAZBMJA=; b=Q+jGAqAWnELd5eyomVv2PAh6Ry2o9yid5zN0mRp7/xxW/32kqfentiG5tlu8vnNMyK cgYK3A9szu74EuNfFd8Ehrhrr9fmqwR2e7gK3MFCludPwOC0Gd8iJ65jLGaklUGlv+Rc aahOhej1gd3PCMtp5AF1bRxfW5lGo/CuaMWS0IPdD5nal/VbmpyHcFIRKbWnLZETU66M nGwKQxli4sg5WaPviOqj2S5Ft6wZiZBm6lLO3q9n3ptiWHXN9pmkhVXbnUpZycVq2mPF n5ulQD86NNl/LBJ4JPg/NcT6sZM2UgCMDPKbSY8c3IJhbxvY7gYejABX1CdDKJvNmMas y9vw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750864865; x=1751469665; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=v2Gtb6hLceU7PpotZhJ0ji3J3xPFUBiDKJdkwAZBMJA=; b=otJXEIo90MCZOfpBq5V+5vdjF32GG5euJCk1+k95W8Sc0QtxTuGUuZ5XwiwC12VBAq dd7+VBhCGjsgNsEdztEOwMPzT+SAaZaYtynOLQMSh7YIy4fMWObT8riMX4VTp9XPIuID YQQWZLu/ltMRtg9IXL1yCDBAN+svv9jYY9vGrsbMfMh6TXa/7cAOTrrzG4PhFc1I5l50 J/klMaVk6m8R+VMIebTAMhU5BKx+Cvl69DYAqLOB9yYFjte4Eu4ddbp4BDgrZ08u2qWh Q4DWjT6DKcy/wHbtsSxVBuQi9m9MkK2w0o820vbgsLfSp2CN2zVs/qSkveeDLLsukTHP vGHg== X-Forwarded-Encrypted: i=1; AJvYcCW44NCUn0kDb8DFCG1ZPUeUvEsV77KUfl47Ut0rFI5t6mihC9Tirc8AcxfxADxjBEihmyxTrXXFVAePDcGo@postgresql.org X-Gm-Message-State: AOJu0YzUylS0FHsdhdzsLf/2ZMRSvwSaRJ3+jq8mVpPnW8gWomteKrhR zBM3eZDp74BxmSDvgDuRbJjsz+/ioqJ2sKfIHANpq9Ha5Lp6VoFKhtip X-Gm-Gg: ASbGnctRS2QR00ubCG/Egg/oTsR81vpsXDm9JkNxgovyqf2jSjnKs/YcDvxHAvVyF4l febJ4HmeptOV9qMt0L+Vo4w1Fjkx0YAcrc7V3EkDAR3yLDsmZ9UzGZTPJF0yahpBFsBe95c8xHw 6VDJBGBEDW1okMZ6LOO000idHnMRW8BQiDDftACPDbbgokkYGCM09nnPZGtghjS/3T3xlppLzTU LL74rCgnh6+rnyAsyTPi9PytAOgXdiIB8a/T9HH2Zkazfhpfu++UAMkBm32i8fqix1p0enYoZDm PjvVZs2eth7Bx9i9CjlW4Ke/g+KMDZqbns3ZLEHYceGi0nELOWNqJvpQ9sZnxa6a1LgwT5JJPx0 ZRBS5t7hk1Yoxu/l6JRaA5qSiebCBM/Ui92iDObtPkn9/St+2GbtJaYKySg== X-Google-Smtp-Source: AGHT+IEKXj1rMjeEQSbLxalb/KsSqUzd47UsfekoAcndyxfR0H6qyJLVF2NXXqWmzJ92BOewzSaX+A== X-Received: by 2002:a05:6e02:218a:b0:3dd:b808:be59 with SMTP id e9e14a558f8ab-3df3297dea6mr48899395ab.21.1750864865266; Wed, 25 Jun 2025 08:21:05 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-5019df16bbcsm2826724173.61.2025.06.25.08.21.04 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 25 Jun 2025 08:21:04 -0700 (PDT) Date: Wed, 25 Jun 2025 10:21:03 -0500 From: Nathan Bossart To: Michael Paquier Cc: shihao zhong , PostgreSQL-development Subject: Re: Fixes inconsistent behavior in vacuum when it processes multiple relations Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Jun 25, 2025 at 10:31:35AM +0900, Michael Paquier wrote: > On Tue, Jun 24, 2025 at 11:30:13AM -0500, Nathan Bossart wrote: >> On Tue, Jun 24, 2025 at 10:18:18AM +0900, Michael Paquier wrote: >> > Knowing that I'm indirectly responsible for this mess, I would like to >> > take care of that myself. Would that be OK for you? >> >> I would be grateful if you took care of it. > > Okay, applied the main fix down to v13 then. Thanks! > Attached is the remaining patch for HEAD, planned once v19 opens, and > the tests I have used on the back-branches as a txt to not confuse the > CI, for reference. Looks reasonable to me. -- nathan