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 1uU6XL-00FeXs-FS for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Jun 2025 16:30:19 +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 1uU6XJ-00DXMo-Fo for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Jun 2025 16:30:18 +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 1uU6XJ-00DXMg-6R for pgsql-hackers@lists.postgresql.org; Tue, 24 Jun 2025 16:30:17 +0000 Received: from mail-io1-xd30.google.com ([2607:f8b0:4864:20::d30]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uU6XI-003l6R-0i for pgsql-hackers@postgresql.org; Tue, 24 Jun 2025 16:30:16 +0000 Received: by mail-io1-xd30.google.com with SMTP id ca18e2360f4ac-876231b81d5so47444339f.2 for ; Tue, 24 Jun 2025 09:30:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1750782615; x=1751387415; 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=iT8hTHZcVVUHpS/hGPfGEARd19HF048KqZuTQoJ6zQs=; b=RSQKAk/BQNWFCkbeNmD/dULi1yQX6dyzwCieJW4qT31MLR+dMkDfcAfirsZqb6oVMz G/meND2AYfzpm0p0vyuJ67id/5aQSDiN3VodYGJn8kVt4dBYjM7XeZppAIJfIYwElxxr UnhpdHoaAu56tOGU3ZO2O7Ad+Cy7Ci24/VJAV3Kot6WsEVqB7+9HS4L1j3q5zkFYOGr4 67s7tIYmw+92w2+OBT29CHvONzONXy0JK9/FyWb1ub/FrMwqpPbECtE+fwazsKvPJafW Z2tyno6Bbyl7dMOJnDN/gIK7JD3hulFSdXO1qfDvlo0XHbn6bwfn8IFAg4sIOhTi7z9E C0LA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750782615; x=1751387415; 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=iT8hTHZcVVUHpS/hGPfGEARd19HF048KqZuTQoJ6zQs=; b=R+I1BychSSXuaByf1vKvveaK3DoswIptKrZ9+iL/wOnwdU9Jcr22EfFbBYYKGbUSZf TUJc/Km2k08JKgnnbBPjJVc9mKQsx9oGSpGCaakQPjPBUQ2vemB8eD6/Jwj091j0a1pu u6qqKPAkyCvaISgu2xEheiQgxu70+FkrjFuj9GMRrVMOm3c6+Kkof/eD1xJAj61w+N/Y Do0cpYx26muP5lrWeNJnO6IxaLx5zqOPtikqKvq4Zx6YmanBq+d0/zOgNhv1BdemHpCT er7+kW8I4TjHWpIXnw33x7g8uVL0wIUzbs+WMng0DwLbunaqRsuYhLqOeAAxmDWMNb/W 8faA== X-Forwarded-Encrypted: i=1; AJvYcCVFrXwT+r6aSHQzI6Lh0QvDrJEh5MVVts6MGoTa89S0NpyMa2JBksxMR1soDaYC+o+nz7BQKM6zYJag0lJc@postgresql.org X-Gm-Message-State: AOJu0YwvwIHYof1F6jW3Jhnz5hyJBoxCm+YhwkzENehoIZrrhJLccM+q OMCFeFHI+Wgizmj1EwEL19UrgaRLpMfnu6s7QJMC1+6VOW5WihswwkHM X-Gm-Gg: ASbGncvo/8BHnTSzf/KFUrwqkBB9bhBZMP0zOA2DXAV/bvUzjl6sl1J0waDLNKWyJX6 e7UDTXFO/Pr4OBAAE/SkOCBfIihj8hY6WpkMJBYa6j8PcWiaKL4n/y7oGcJzgr0pqO2qt34RXih kweyGKogfbN/CLXOscbF1Z+U1c2M2fxVB3a82Yv+xjNUDXFqTXOj8HB7A/rYINTlAsOxKH4U8Zx mVkfIpIj3cQRppMOT/gfZnxtEg7xt2otnPOwFOmBNL/WGrnyiSJNCfcmiHtWdSXuEUHTQX0SZ2I JcRjnccCPFYk0ZP5eh/hrowNGq07Xh9j1XbxWwH61YUiufasndFRc6Et3HIx9mcjKXubktsyo5r pMFZYHAwvfByZzW8VGdXnSdR+adQgUrj6UghP48uMLJ/lLWyecq8y8OAKBaZqPgM= X-Google-Smtp-Source: AGHT+IGMuXjWnyoLWTeQB+DyP4sFddXDDpXVXZ8OtB5e3MXYzE8DHcKw84qQMOFgnQL9eVpRxQQyEg== X-Received: by 2002:a05:6602:14ca:b0:867:8ef:69e8 with SMTP id ca18e2360f4ac-8766aa8d5b3mr33136439f.3.1750782615344; Tue, 24 Jun 2025 09:30:15 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id ca18e2360f4ac-8762b7c4127sm323855739f.42.2025.06.24.09.30.14 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 24 Jun 2025 09:30:14 -0700 (PDT) Date: Tue, 24 Jun 2025 11:30:13 -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 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. > Another approach that we could use is an injection point with some > LOGs that show some information based on what VacuumParams holds. > That would be the cheapest method (no need for any data), and entirely > stable as we would look at the stack. Perhaps going down to that is > not really necessary for the sake of this thread. +1 for this. I did something similar to verify the other bugs I reported, and this seems far easier to maintain than potentially-unstable tests that require lots of setup and that depend on secondary effects. -- nathan