On Mon, Feb 8, 2021 at 9:49 AM Mead, Scott wrote:
> Initially, my goal was to determine feasibility for making this dynamic. I
> added debug code to vacuum.c:vacuum_delay_point(void) and found that changes
> to cost_delay and cost_limit are already processed by a running vacuum.
> There was
On Mon, Jan 23, 2023 at 12:33 PM Alvaro Herrera
wrote:
> On 2021-Feb-08, Mead, Scott wrote:
>
> > Hello,
> >I recently looked at what it would take to make a running autovacuum
> > pick-up a change to either cost_delay or cost_limit. Users frequently
> > will have a conservative value set, a
On 2021-Feb-08, Mead, Scott wrote:
> Hello,
>I recently looked at what it would take to make a running autovacuum
> pick-up a change to either cost_delay or cost_limit. Users frequently
> will have a conservative value set, and then wish to change it when
> autovacuum initiates a freeze on a
On Wed, May 26, 2021 at 4:01 AM Masahiko Sawada
wrote:
> On Wed, Apr 14, 2021 at 11:17 PM Mead, Scott wrote:
> >
> >
> >
> > > On Mar 1, 2021, at 8:43 PM, Masahiko Sawada
> wrote:
> > >
> > > CAUTION: This email originated from outside of the organization. Do
> not click links or open attachmen
On Wed, Apr 14, 2021 at 11:17 PM Mead, Scott wrote:
>
>
>
> > On Mar 1, 2021, at 8:43 PM, Masahiko Sawada wrote:
> >
> > CAUTION: This email originated from outside of the organization. Do not
> > click links or open attachments unless you can confirm the sender and know
> > the content is safe
> On Mar 1, 2021, at 8:43 PM, Masahiko Sawada wrote:
>
> CAUTION: This email originated from outside of the organization. Do not click
> links or open attachments unless you can confirm the sender and know the
> content is safe.
>
>
>
> On Mon, Feb 8, 2021 at 11:49 PM Mead, Scott wrote:
>
On Mon, Feb 8, 2021 at 11:49 PM Mead, Scott wrote:
>
> Hello,
>I recently looked at what it would take to make a running autovacuum
> pick-up a change to either cost_delay or cost_limit. Users frequently will
> have a conservative value set, and then wish to change it when autovacuum
> ini
Thanks for the patch, Mead.
For 'MAXVACUUMCOSTLIMIT", it would be nice to follow the current GUC
pattern to do define a constant.
For example, the constant "MAX_KILOBYTES" is defined in guc.h, with a
pattern like, "MAX_" to make it easy to read.
Best regards,
David
On 2021-02-08 6:48 a.m.
