Re: allow changing autovacuum_max_workers without restarting

agora inbox for pgsql-hackers@postgresql.org  
help / color / mirror / Atom feed

From: Nathan Bossart <nathandbossart@gmail.com>
To: Imseih (AWS), Sami <simseih@amazon.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Re: allow changing autovacuum_max_workers without restarting
Date: Thu, 11 Apr 2024 09:42:40 -0500
Message-ID: <20240411144240.GD1882158@nathanxps13> (raw)
In-Reply-To: <D04DFE2E-290F-43BA-9368-952F2B85E0C2@amazon.com>
References: <20240410212344.GA1824549@nathanxps13>
	<D04DFE2E-290F-43BA-9368-952F2B85E0C2@amazon.com>

On Thu, Apr 11, 2024 at 02:24:18PM +0000, Imseih (AWS), Sami wrote:
> max_worker_processes defines a pool of max # of background workers allowed.
> parallel workers and extensions that spin  up background workers all utilize from 
> this pool. 
> 
> Should autovacuum_max_workers be able to utilize from max_worker_processes also?
> 
> This will allow autovacuum_max_workers to be dynamic while the user only has
> to deal with an already existing GUC. We may want to increase the default value
> for max_worker_processes as part of this.

My concern with this approach is that other background workers could use up
all the slots and prevent autovacuum workers from starting, unless of
course we reserve autovacuum_max_workers slots for _only_ autovacuum
workers.  I'm not sure if we want to get these parameters tangled up like
this, though...

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com

view thread (71+ messages)  latest in thread

Message-ID: <20240411144240.GD1882158@nathanxps13>
Permalink:  ../20240411144240.GD1882158@nathanxps13/
Also on:    postgresql.org/message-id/20240411144240.GD1882158@nathanxps13

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: nathandbossart@gmail.com, simseih@amazon.com
  Subject: Re: allow changing autovacuum_max_workers without restarting
  In-Reply-To: <20240411144240.GD1882158@nathanxps13>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox