public inbox for [email protected]  

help / color / mirror / Atom feed

From: Álvaro Herrera <[email protected]>
To: Heikki Linnakangas <[email protected]>
Cc: Fujii Masao <[email protected]>
Cc: Thom Brown <[email protected]>
Cc: [email protected]
Subject: Re: pgsql: Refactor how some aux processes advertise their ProcNumber
Date: Thu, 9 Jul 2026 14:36:04 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>

On 2026-Jul-09, Heikki Linnakangas wrote:

> Why is the autovacuum launcher not an aux process? I guess it's because it
> needs to acquire a heavy-weight lock in order to read the list of databases.

Because it scans pg_database.

commit 00e6a16d01683762c2f34eb4909fc739093ab3bf
Author:     Tom Lane <[email protected]> []
AuthorDate: Mon Aug 31 19:41:00 2009 +0000
CommitDate: Mon Aug 31 19:41:00 2009 +0000

    Change the autovacuum launcher to read pg_database directly, rather than
    via the "flat files" facility.  This requires making it enough like a backend
    to be able to run transactions; it's no longer an "auxiliary process" but
    more like the autovacuum worker processes.  Also, its signal handling has
    to be brought into line with backends/workers.  In particular, since it
    now has to handle procsignal.c processing, the special autovac-launcher-only
    signal conditions are moved to SIGUSR2.
    
    Alvaro, with some cleanup from Tom

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"If you want to have good ideas, you must have many ideas.  Most of them
will be wrong, and what you have to learn is which ones to throw away."
                                                         (Linus Pauling)

view thread (8+ messages)

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: pgsql: Refactor how some aux processes advertise their ProcNumber
  In-Reply-To: <[email protected]>

* 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