Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uJgik-004Hk0-LT for pgsql-hackers@arkaria.postgresql.org; Mon, 26 May 2025 22:55:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uJgij-004eBG-4M for pgsql-hackers@arkaria.postgresql.org; Mon, 26 May 2025 22:55:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uJgii-004eB8-PS for pgsql-hackers@lists.postgresql.org; Mon, 26 May 2025 22:55:01 +0000 Received: from mail-ot1-x32c.google.com ([2607:f8b0:4864:20::32c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uJgig-000GZA-0x for pgsql-hackers@lists.postgresql.org; Mon, 26 May 2025 22:55:00 +0000 Received: by mail-ot1-x32c.google.com with SMTP id 46e09a7af769-72c02e22d96so346517a34.2 for ; Mon, 26 May 2025 15:54:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1748300096; x=1748904896; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=KzZGJcEXnFFn5/HvjFLmTGbt1MJvR7g/RZisIKzsCFk=; b=M5UuwjqRvWgKjtOeS1585M0j+h7d3UKgx0xecYviNmM6/iinK/HgjxRgMRNeBWID3V t/K+JvtgDS2zk+zKMC6haBepqX/CIqoIvdKWAkgSbs2ttV6o5hM+AToIYh/wA6tjSGgj YpWxoXQDiHXGt2sGTb/6CwDH5w7htrjC/UtIp/bmsu5NQqo8/HzZX+Gl0zWT2NY0kokF 5m2qo9VH3h8E1QBolqqzpgRVl1W30GyQOkeotWr3x6nBYM0q3QqxX8qylptEcLL9naqd wIyMT9ySMM/Gz1cJpIWRbMCPmNqfo6D0mmPBCPZnEuZihHs3pAWxlnj99fRvhhCekpFd l9MQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1748300096; x=1748904896; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=KzZGJcEXnFFn5/HvjFLmTGbt1MJvR7g/RZisIKzsCFk=; b=n2uwUxVluofmeXLsttsFKjNbKODk5bxMM1jA6WYNj+BBCaBqiv2Xqe6mICm4gOyW9A JhMTAk9XGLm/Lk6sPfF5cizCyx5HVbie7BnQ2T+Kq/hbeJDZ71vhdoaBLaR91figMHJi J9+gJ2QwI4RnFUKEfrm0FVh6beNvMZFlEPwNsf3DGK8W7hgJO1z2HpuC5Ocfu37KiZNi BjZOCssZUFdvth3pwydzFxJsk/cw9MjkHj9s9L0amNbTSDIChlXohREOhjBc5ZknlSlu 5b5FAhfwGN35M82X7257ZaQ3piJ6WjmDH024TO0XYvCdRs+1W8234U8dFMyhSnFpqt0k Y90A== X-Gm-Message-State: AOJu0YxM1aSKQ5Iz/Ah4G51A554olHNtzmso8PAfnpDDWtHejs2ZRnyg bvTJFog5NV0tYw1cbEMKBE62eYAhdBoS/yKx+6lyDY8YZlIT65H/Ha01wyJOByEn94tPFDCj1xs A5BpkgXk9lhySt5s1/GVSsdPKCw6SXdc= X-Gm-Gg: ASbGnctld27IRqLt2OpK5OmzyENV15a2rNdgOaqXoftajZqmvTOaME88wtWWb35ydVt kjyozX+mz8ZWa7vnQLYxMnnZxmkbrZmQhWdYCpwehKQDNJxVLQpfc0+RaI2sA9XR2CTk1B1+LCh 9VJdt6vgDAxuGDC3jQNEBoAaVRwKnw9pqZD4RU8b4waewgyLE0jAXAkFQ5yvutmX4MVr4sCqqbi U4/CA== X-Google-Smtp-Source: AGHT+IHJ3pQfNY/kBpBq6tlalka1Kn9QpoMk95Jyy3De8Y00m5PmIpvggQlHSWtEwFJUXIjSr0SR72JgUwnxde8Mc/M= X-Received: by 2002:a05:6870:b9cc:b0:2b7:fc4b:8408 with SMTP id 586e51a60fabf-2e861dbb51fmr2060619fac.2.1748300096375; Mon, 26 May 2025 15:54:56 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Thomas Munro Date: Tue, 27 May 2025 10:54:20 +1200 X-Gm-Features: AX0GCFs3u2UXhIkpoFyOuRFrkfIaVkz8EbozsD1h-OEj_0CBIW20d7U9qtFa8ZI Message-ID: Subject: Re: Automatically sizing the IO worker pool To: Dmitry Dolgov <9erthalion6@gmail.com> Cc: PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk BTW I would like to push 0001 and 0002 to master/18. They are are not behaviour changes, they just fix up a bunch of inconsistent (0001) and misleading (0002) variable naming and comments to reflect reality (in AIO v1 the postmaster used to assign those I/O worker numbers, now the postmaster has its own array of slots to track them that is *not* aligned with the ID numbers/slots in shared memory ie those numbers you see in the ps status, so that's bound to confuse people maintaining this code). I just happened to notice that when working on this dynamic worker pool stuff. If there are no objections I will go ahead and do that soon.