Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pf1Zc-000167-HF for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Mar 2023 16:44:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pf1Za-0003Xy-5Y for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Mar 2023 16:44:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pf1ZZ-0003Xm-PQ for pgsql-hackers@lists.postgresql.org; Wed, 22 Mar 2023 16:44:25 +0000 Received: from mail-io1-xd2f.google.com ([2607:f8b0:4864:20::d2f]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pf1ZW-0004lB-TG for pgsql-hackers@postgresql.org; Wed, 22 Mar 2023 16:44:24 +0000 Received: by mail-io1-xd2f.google.com with SMTP id o12so8739208iow.6 for ; Wed, 22 Mar 2023 09:44:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; t=1679503462; 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=/dLJBpR7r1S54Nub/xiXImSH5w1nHus0xmH9bf7s63M=; b=ry+klymANhiOOhzcMeQOjno1yzZsaIwhogv/nXiWqtNw9EoZ6hbg/BdOeXjEmGlXGf q2D8YsW3sF5UOQice7ORLrHzxzNog8U/iEnMOPPPU6HWRHA655JCsZ+Yf27DHT2PHQqE soyHlRMnEKEnF68b3AusUpewN/684y/7vGH70RiJLjMX9x6vRTlWv1qs6WWsa6r72D4w gDVYk1147PCcxx3z2y6ebeDtWCNZ3cTTFoVs8i2GAkl7KX03NyMkfnUN4oVAUMWhFvk8 i88FQNFaDSrMPwNHmLH/KwVP13y7QIeHZlfBbddZyCMBwtEPqyCoK0uKSZZCsSSRaHUC LC4A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1679503462; 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=/dLJBpR7r1S54Nub/xiXImSH5w1nHus0xmH9bf7s63M=; b=Wiz6J6+KYxrc4e/gtpWwlbpRVYp12n/rgzXZQJ3hWDRrV3PmvoKHBZedXTPMRIMJXD SkFWydgaNtd6uWA1OpHEDbIx0lvlECPAB/LMoen21imASJ3CFJ4jdzJmwcICIwQPYjYN KbicJtdX5LOh+A/oDyoWfH4/YQCaCvK4FAB/rKTu4y1VP9KcDqXOUShPWdnXHo2JUaVI sXbh10YKBidmGT0cDwdjrYwFigRIaE0KV5BuHhj51/uYXZMyyl1Fhu6/kRZ8o2ZKfumG zWnnnIku+D5CYMRsliuVQypLBqYP+c36oabj/X8nk/bPYAjXnMqMtMvknRNs35xChty4 Snqw== X-Gm-Message-State: AO0yUKVeUOg5N16zglmpWtxFCK0bWuQZpHKdOxr8y5Yo+WI913zkxYse NUhMJ+p6iDx2C6LOqbQt7VkshQ== X-Google-Smtp-Source: AK7set8rmnyt49JtEd79cZXYVboJ1ZUsTHxutnM+L7C3ZnXYIArjPSMBgy6gwhVYAHKiUih5CR7fkA== X-Received: by 2002:a5e:a702:0:b0:751:dcc3:3279 with SMTP id b2-20020a5ea702000000b00751dcc33279mr5072878iod.14.1679503461788; Wed, 22 Mar 2023 09:44:21 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id p3-20020a5d8d03000000b0074ca38eb11fsm4566542ioj.8.2023.03.22.09.44.21 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 22 Mar 2023 09:44:21 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 3AE1580055C; Wed, 22 Mar 2023 11:44:20 -0500 (CDT) Date: Wed, 22 Mar 2023 11:44:20 -0500 From: Justin Pryzby To: Alvaro Herrera Cc: Andres Freund , pgsql-hackers@postgresql.org Subject: Re: Should we remove vacuum_defer_cleanup_age? Message-ID: References: <20230317230930.nhsgk3qfk7f4axls@awork3.anarazel.de> <20230318093357.g4e3eexqg6dxmuel@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20230318093357.g4e3eexqg6dxmuel@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, Mar 18, 2023 at 10:33:57AM +0100, Alvaro Herrera wrote: > On 2023-Mar-17, Andres Freund wrote: > > > I started writing a test for vacuum_defer_cleanup_age while working on the fix > > referenced above, but now I am wondering if said energy would be better spent > > removing vacuum_defer_cleanup_age alltogether. > > +1 I agree it's not useful anymore. > > > I don't think I have the cycles to push this through in the next weeks, but if > > we agree removing vacuum_defer_cleanup_age is a good idea, it seems like a > > good idea to mark it as deprecated in 16? > > Hmm, for the time being, can we just "disable" it by disallowing to set > the GUC to a value different from 0? Then we can remove the code later > in the cycle at leisure. It can be useful to do a "rolling transition", and it's something I do often. But I can't see why that would be useful here? It seems like something that could be done after the feature freeze. It's removing a feature, not adding one. -- Justin