Re: Table-level log_autovacuum_min_duration - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Table-level log_autovacuum_min_duration
Date
Msg-id 1392.1427124861@sss.pgh.pa.us
Whole thread Raw
In response to Re: Table-level log_autovacuum_min_duration  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
Jeff Janes <jeff.janes@gmail.com> writes:
> On Mon, Mar 23, 2015 at 7:07 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Yeah, checking for SIGHUP in the worker outer loop (ie once per table)
>> seems like a reasonable thing.

> Could it be done more often?  Maybe every time it is about to do a
> cost_delay sleep?

That sounds risky from here.  Normal backends don't check it more often
than once per command.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Zero-padding and zero-masking fixes for to_char(float)
Next
From: Robert Haas
Date:
Subject: Re: Superuser connect during smart shutdown