Re: Should we remove vacuum_defer_cleanup_age?

From: "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>
Cc: Justin Pryzby <pryzby(at)telsasoft(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Should we remove vacuum_defer_cleanup_age?
Date: 2023-04-13 16:16:38
Message-ID: 490f1ebd-03fc-d996-cc5e-7991569a9e45@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 PM Andres Freund <andres(at)anarazel(dot)de>

>> +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 not
>> a bad idea.
>>
>> Do others have any opinion/suggestion on this matter?
>
> I need a bit more time to study this before formulating an opinion on
> whether we should remove it for v16. In any case, I'm not against
> documentation.

(didn't need too much more time).

[RMT hat]

+1 for removing.

I looked at some data and it doesn't seem like vacuum_defer_cleanup_age
is used in any significant way, whereas hot_standby_feedback is much
more widely used. Given this, and all the problems + arguments made in
the thread, we should just get rid of it for v16.

There are cases where we should deprecate before removing, but I don't
think this one based upon usage and having a better alternative.

Per [1] it does sound like we can make some improvements to
hot_standby_feedback, but those can wait to v17.

We should probably set $DATE to finish this, too. I don't think it's a
rush, but we should give enough time before Beta 1.

Jonathan

[1]
https://www.postgresql.org/message-id/20230317230930.nhsgk3qfk7f4axls%40awork3.anarazel.de

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Kimura 2023-04-13 16:19:22 Re: Unexpected (wrong?) result querying boolean partitioned table with NULL partition
Previous Message Robert Haas 2023-04-13 16:15:16 Re: pg_init_privs corruption.