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 1pn9m2-0005aU-HE for pgsql-hackers@arkaria.postgresql.org; Fri, 14 Apr 2023 03:06:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pn9m0-0002hK-RU for pgsql-hackers@arkaria.postgresql.org; Fri, 14 Apr 2023 03:06:52 +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 1pn9m0-0002hB-Ho for pgsql-hackers@lists.postgresql.org; Fri, 14 Apr 2023 03:06:52 +0000 Received: from mail-ej1-x62d.google.com ([2a00:1450:4864:20::62d]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pn9lw-0003hT-Qn for pgsql-hackers@postgresql.org; Fri, 14 Apr 2023 03:06:51 +0000 Received: by mail-ej1-x62d.google.com with SMTP id jg21so41940800ejc.2 for ; Thu, 13 Apr 2023 20:06:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20221208.gappssmtp.com; s=20221208; t=1681441607; x=1684033607; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=6oTsYrWg/XsMV1Oz8DvgJeFxwtC+oCb6300RgaXINM8=; b=FXXVrJTay9m7CO7tvc/Sp8nVUH2AYzENmndrkdYO0CiVLFSCSQnPxsLiE8kNe/8h82 5mFvvHeQ5VeM+kD7WwmW7tuHwYqDAZ4G9Nngj16y0e3/kD5LD25XxIym7P9Ch85McEmF yCtdHrtxZ7XvfIZ/a/aXkg4qmIFXTqvith+OG37mTbUhuO+QyBdATvxaY6aYYaeUwgA9 TcrsNDavJtCtRT10KmvozkjCpdrvoY2+fZc3bGWGhIU5gvCUQfkwq8zEA3mdGijGH09e 0zTcohDr9toORn6CbY/B5o3+fD4rj19c48EfnWRbaTAF4t7uZF96FV2W1li5hXJsYZLG GbEw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1681441607; x=1684033607; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=6oTsYrWg/XsMV1Oz8DvgJeFxwtC+oCb6300RgaXINM8=; b=R6rYDwblPZIV1YZPhShnDQf5Vjdiu5cFXQI85aoPMW8b1Hi5G8CYHGiC4x1iLbA8MB DUrHW4z/tYWtFUPf+ZbHiqzv8hhSq/c3LWTz4qMXbV1M58gA20Q67q9MzIj2pfAfrejA GCsMcTwV8ZOhmxWSHMFLNIYGkmSDBLEIC13u3/5M/hfa1//qlFIZAqISYQ1L8QfILnq/ N3QZXydfwXDgafHz4ZUZLJ9cPlNddb/4czcfyB0fJ+fTlRsU1Q/3L86mhplxzpkG6h9o 2XzQJ1MvTVguRt7SkzrjbEIqjar1SbhcNptIIXvnGyH+3w35rbwQQit8v7dfAQuaup7+ O30g== X-Gm-Message-State: AAQBX9ewr7nXfnG/f2P+MBvu4tC9HQXqiGcUcr7YV+soUYGv3eMchvq1 moo703fPQBNDTpQqRKw8WWZnLA== X-Google-Smtp-Source: AKy350YD0BI1mrjoreEpukGVUsGSjehmFSHntw9dLUM2cxVwB6EpmtxTkQDyZC7vUSrCJmiUwD0sqQ== X-Received: by 2002:a17:906:1508:b0:94a:582d:169f with SMTP id b8-20020a170906150800b0094a582d169fmr5042020ejd.5.1681441607294; Thu, 13 Apr 2023 20:06:47 -0700 (PDT) Received: from localhost.localdomain (178-190-180-97.adsl.highway.telekom.at. [178.190.180.97]) by smtp.gmail.com with ESMTPSA id o26-20020a1709061d5a00b0094e44899367sm1768846ejh.101.2023.04.13.20.06.46 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 13 Apr 2023 20:06:46 -0700 (PDT) Message-ID: Subject: Re: Should we remove vacuum_defer_cleanup_age? From: Laurenz Albe To: "Jonathan S. Katz" , Amit Kapila , Andres Freund Cc: Justin Pryzby , Alvaro Herrera , pgsql-hackers@postgresql.org Date: Fri, 14 Apr 2023 05:06:46 +0200 In-Reply-To: <490f1ebd-03fc-d996-cc5e-7991569a9e45@postgresql.org> References: <20230317230930.nhsgk3qfk7f4axls@awork3.anarazel.de> <20230318093357.g4e3eexqg6dxmuel@alvherre.pgsql> <20230322170048.ffbnfr5o2jrjgb2f@awork3.anarazel.de> <20230411182010.zsldtjrxe5m2bqzp@awork3.anarazel.de> <490f1ebd-03fc-d996-cc5e-7991569a9e45@postgresql.org> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.46.4 (3.46.4-1.fc37) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2023-04-13 at 12:16 -0400, Jonathan S. Katz wrote: > On 4/13/23 11:32 AM, Jonathan S. Katz wrote: > > On 4/12/23 11:34 PM, Amit Kapila wrote: > > > On Tue, Apr 11, 2023 at 11:50=E2=80=AFPM Andres Freund =20 >=20 > > > +1 to do one of the above. I think there is a good chance that > > > somebody might be doing more harm by using it so removing this > > > shouldn't be a problem. Personally, I have not heard of people using > > > it but OTOH it is difficult to predict so giving some time is also no= t > > > a bad idea. > > >=20 > > > Do others have any opinion/suggestion on this matter? > >=20 > > I need a bit more time to study this before formulating an opinion on= =20 > > whether we should remove it for v16. In any case, I'm not against=20 > > documentation. >=20 > [RMT hat] >=20 > +1 for removing. I am not against this in principle, but I know that there are people using this parameter; see the discussion linked in https://postgr.es/m/E1jkzxE-0006Dw-Dg@gemulon.postgresql.org I can't say if they have a good use case for that parameter or not. Yours, Laurenz Albe