public inbox for [email protected]  

help / color / mirror / Atom feed

From: Robert Haas <[email protected]>
To: Melanie Plageman <[email protected]>
Cc: Heikki Linnakangas <[email protected]>
Cc: Дарья Шанина <[email protected]>
Cc: [email protected]
Subject: Re: autoprewarm_dump_now
Date: Fri, 4 Apr 2025 12:36:33 -0400
Message-ID: <CA+TgmobRMXwFg4AUZ96FvXALFkN8H7KBqhCp-CtMS83RuKXG3A@mail.gmail.com> (raw)
In-Reply-To: <CAAKRu_YyuqbRaVO-zkoeRLFeNtF_jX-faGSGH4h3JB6ckORWMg@mail.gmail.com>
References: <CAMp4U1cDJzb96KJXT-hNuf7L4KaYUiXWs6KSe01so--mBoop8g@mail.gmail.com>
	<[email protected]>
	<CAAKRu_YyuqbRaVO-zkoeRLFeNtF_jX-faGSGH4h3JB6ckORWMg@mail.gmail.com>

On Fri, Apr 4, 2025 at 12:17 PM Melanie Plageman
<[email protected]> wrote:
> Unrelated to this problem, but I wondered why autoprewarm doesn''t
> launch background workers for each database simultaneously instead of
> waiting for each one to finish a db before moving onto the next one.
> Is it simply to limit the number of bgworkers taking up resources?

That's probably part of it, but also (1) a system that allowed for
multiple workers would be somewhat more complex to implement and (2)
I'm not sure how beneficial it would be. We go to some trouble to make
the I/O as sequential as possible, and this would detract from that. I
also don't know how long prewarming normally takes -- if it's fast
enough already, then maybe this doesn't matter. But if somebody is
having a problem with autoprewarm being slow and wants to implement a
multi-worker system to make it faster, cool.

-- 
Robert Haas
EDB: http://www.enterprisedb.com

view thread (14+ messages)  latest in thread

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: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: autoprewarm_dump_now
  In-Reply-To: <CA+TgmobRMXwFg4AUZ96FvXALFkN8H7KBqhCp-CtMS83RuKXG3A@mail.gmail.com>

* 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