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.96) (envelope-from ) id 1vMCwt-003oi8-0q for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Nov 2025 22:16:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vMCwr-004dJg-2i for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Nov 2025 22:16: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.96) (envelope-from ) id 1vMCwr-004dJY-1m for pgsql-hackers@lists.postgresql.org; Thu, 20 Nov 2025 22:16:17 +0000 Received: from mail-il1-x12c.google.com ([2607:f8b0:4864:20::12c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vMCwp-000ay2-10 for pgsql-hackers@postgresql.org; Thu, 20 Nov 2025 22:16:16 +0000 Received: by mail-il1-x12c.google.com with SMTP id e9e14a558f8ab-4335726d0f2so5189685ab.1 for ; Thu, 20 Nov 2025 14:16:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1763676975; x=1764281775; 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=ERStffQZOg+jn4TZJkcv5viPfVtyo+C+Y2Zf38xkO+U=; b=kAynIpDSQpxexAqy0+h/pDtWmPfMapCCISufH0o9t5DPo0oh+1AB6DsGdHGRLIMXGI wvhZ3FARIn9aa+GzGot6oXWOc7dzAvJrOuzyn9i4l6bd5Rm8kKZBGWjTDwhO/ssFni5L 9R93T4QhBALAq2lOuiRMLL75ObJBRHuGhUluCMcruKpMaJ2IXxWsdhGt3ayItnv/0AIK Dp9htJse2GZCH/+4nyQRfRyxgIZawCXFhDvBkLIuFEoGb4WoN2TOXnNCTFO4gXBYnRYj psefOUHF4kOSwF4l2GPp1Ywxsb3AnLeErg//dKCgS72/9iHM626PlOVtJhOjOvt86LTZ 2ajA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1763676975; x=1764281775; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-gg:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=ERStffQZOg+jn4TZJkcv5viPfVtyo+C+Y2Zf38xkO+U=; b=cIak4ghP1HtcV03pCfzCy0rxpdtRKBsWBqcvKHXK3tM2VldUmGFGTZYRD1k/7sp30G f76y6VAgEeAohc0Yn/hw/7w+JC36hd729Bey/f8DLQrPEo+e3QM0pdN3wWcaXV/QKsOW Deo18/ayN8jJFIRvf5GJK2uSglv0PS6QQBfYnK1QV51kkXrsfekxd0Qprv7cYqdu0e5J QaeCosb7Xtein+9GdZ+V8rp0LF+JaSSBUI03kyAIbwAsLXSPyfD3F8KmID1KAi1yET6l X84itA4qefyQw8ElskZAekNTKZQqncbHQH2O4e2jB4EFWyNSQD4MHLllxYrBPTDkxqcO c/Ag== X-Forwarded-Encrypted: i=1; AJvYcCXS92IThH5nFtXyafSWqzI2+biSySSJwiPuniLwnL1cWcGcP9IxlLNnekgeKoYZKbfnbDLCsp1JzG4HJ+g2@postgresql.org X-Gm-Message-State: AOJu0YxoeEF7Ey3McT2PLzPGoXKH0qhEvxNG7ix2rEuqUfzdPjBSaz59 bHMnGRhwFKAFQp/BTbqi1LBLdQ1Zg/K2LiLsTRT6aDpgHpaY48jKTkOd X-Gm-Gg: ASbGncstCTZrKALX6/8XlwRiagZuXbdcECRB3ge9dQZeQhFTLoHcqbIOpnOhl0cCcxJ g6cyI/x3XVyB1MZ9P+SmI7hUIoTugGmI5n2XG/sMsjDsQQRkCvWL81jjM8T4fmSOJsoqWfOxYFs 3GLrm4iLoJye1W+3oyVgabdByTtdA0JMg2kPUiyzbrHsEfIxO/OFtsMg+zDyPFBL85m4wrow1+N GSQtpTT8N2n76pJTXZ5qel28NSFcJ6POL48SpN21ppjpa40A3mtJcfBem14IiQNwQVFRLIadoth K5iDFGjakwcj5o7CA190posPYnQn6PR78NvsZwdW/Nk9PyAmc9ubwnDlpZ56Q3gABMb+kOQp0Ju fp9lb83tQe63WkIS/9o/XTB4Uu2hxsTOco6Ri7ShXOrbt0iAi9pWx8MYsh/RbdbtQj9fyRVZyjP vW8an79Vnp6KM0FTO9j+LZfB3DnU8+UKDyPBoHifgXobca4gFvGs+MyI8HBXxWpVaDGLCQwEIq4 vZO X-Google-Smtp-Source: AGHT+IEwvLVkTZEg0poCjgGEOy7GM4/e2tyRrNPW+rpuOPco3ZgZO5Halwpkrob4OeGXc8KKVWBCLw== X-Received: by 2002:a05:6e02:3313:b0:435:a2a2:c07 with SMTP id e9e14a558f8ab-435b8e92334mr2576115ab.41.1763676975326; Thu, 20 Nov 2025 14:16:15 -0800 (PST) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id e9e14a558f8ab-435a90b6dedsm15499345ab.18.2025.11.20.14.16.14 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 20 Nov 2025 14:16:14 -0800 (PST) Date: Thu, 20 Nov 2025 16:16:13 -0600 From: Nathan Bossart To: Corey Huinker Cc: Chao Li , pgsql-hackers@postgresql.org Subject: Re: vacuumdb: add --dry-run Message-ID: References: <3DB353E5-944D-4E18-9DA2-4151F44AA59B@gmail.com> 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 Thu, Nov 20, 2025 at 05:09:54PM -0500, Corey Huinker wrote: > I have no objections to, but I am curious about the factors that went into > making dry_run an independent boolean rather than part of vacopts. My thinking was that it's closer to "echo" and "quiet" than anything in vacuumingOptions. Most of that stuff seems geared towards controlling the precise behavior of the commands rather than the behavior of the application. TBH I think it'd be fine either way. We could probably even move "echo" and "quiet" into vacuumingOptions if we really wanted to. -- nathan