Re: [BUG] Autovacuum not dynamically decreasing cost_limit and cost_delay

2023-02-23 Thread Melanie Plageman
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

Re: [BUG] Autovacuum not dynamically decreasing cost_limit and cost_delay

2023-01-31 Thread Scott Mead
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,

Re: [BUG] Autovacuum not dynamically decreasing cost_limit and cost_delay

2023-01-23 Thread Alvaro Herrera
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

Re: [BUG] Autovacuum not dynamically decreasing cost_limit and cost_delay

2021-10-26 Thread Scott Mead
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

Re: [BUG] Autovacuum not dynamically decreasing cost_limit and cost_delay

2021-05-26 Thread Masahiko Sawada
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

Re: [BUG] Autovacuum not dynamically decreasing cost_limit and cost_delay

2021-04-14 Thread Mead, Scott
> 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:

Re: [BUG] Autovacuum not dynamically decreasing cost_limit and cost_delay

2021-03-01 Thread Masahiko Sawada
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 >

Re: [BUG] Autovacuum not dynamically decreasing cost_limit and cost_delay

2021-02-12 Thread David Zhang
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