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.96) (envelope-from ) id 1wAIcZ-002FRt-26 for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Apr 2026 02:26:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wAIcY-0048nb-0J for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Apr 2026 02:26:22 +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.96) (envelope-from ) id 1wAIbr-0046FD-07 for pgsql-hackers@lists.postgresql.org; Wed, 08 Apr 2026 02:25:39 +0000 Received: from mail-dy1-x1333.google.com ([2607:f8b0:4864:20::1333]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wAIbo-00000001DvO-40ON for pgsql-hackers@lists.postgresql.org; Wed, 08 Apr 2026 02:25:39 +0000 Received: by mail-dy1-x1333.google.com with SMTP id 5a478bee46e88-2d1180e769fso57624eec.3 for ; Tue, 07 Apr 2026 19:25:36 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775615134; cv=none; d=google.com; s=arc-20240605; b=EyXcExpNBgekDDzrMRlosWYP9IP9GqnE008DW167JLlTydeQiDZqdjeJeHTwD5OLk+ J0XCAjVNCfnlVGa/HvJHJpJDEwT0xtvIuEnwbQ+kyOBACR0KrLIQyU1jx6NcRlGKx43O oFba7EIKa00TejPmDbVB5clijmjoT+mADSpiJarJpJliqo9b9GtYfitBA80qu+VM1dAg bQoQEkjKyeBtPeBdWd5jNxmyBKI2jRQ+LTJVxF3GZpCVlMJh6cm925GCOHr329vJ4Rm5 jyVnljZslKy1AvdVvUe1pxI2ZkKb5mbrki5ntSUAQCg0p7EpAVohgdBfZVsSsP3DQMM/ /sCA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=Na80woG5TE2uJHQYv2zhB0NL0oqxAjV2XTthG2LyXqs=; fh=2jr/XjKs7bJOaJgnFzTqPdzFeW7HhzfhAVyBCji/UCI=; b=Yx0Mwmx45Ct5TzVcbMoLUHwF87AtgnmJt+XYsQ2zwjKlfEOyVht6TV07KIZReXx0n2 5Pc6KchLcyKhgqVVdVdUQ8yVqN4OSh5mZSGhRJ/kr1TvIkUGhxWOkwWsZtGDSBqr/6bW RETvr3FA7MMXLNVHgljpO77DXXby7KgpwrZV+UQKMTXBt4Wz6soQw/w6kqAUHiAkDW05 JECJCkYZoUT1ycEOmfs1aP70x2Vxuxun154ocmX8C1HobqYjHJId+2iA+LElZ3+vIqoG YwLdGef2zqOVfXpk2cOxe3mI2cpWpnrrqylF4TTybdwUW4QxleNUebDPwcHilPntR8lw iEQQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775615134; x=1776219934; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=Na80woG5TE2uJHQYv2zhB0NL0oqxAjV2XTthG2LyXqs=; b=QucqI3aGdN6sB6n3jt2xnVBamfXelQWzsHh1WuLcYXz5tBnk0cQRZbIDX3h4zQZYqq rN2dzhHUZX+zzXCWSJ+Ss/ptNte/3S8ucBWifWMKcvI+g6Em9SwEsLIEuJGrBtNj+v7p if2njQIvbze6t1+nuWyKbKqWbCTuHr/DUdMx5KA4tHBV4+3+Rv/772TteGDUEsSDv36h 87pKQ+cXUNW647BDRypwpZirtYQKvUFDfP8zGsSiRfAceg+rM1dzxnsjN473s3OuOgew +eKQnPwb0zLRvNg5PJqMV9UjvsmTdk50WRPDT8x9CG0Ec3/Dv7Ca7l3rZLy5tcTyKWC5 jHCQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775615134; x=1776219934; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=Na80woG5TE2uJHQYv2zhB0NL0oqxAjV2XTthG2LyXqs=; b=cUqlt+RCmKmjP2zh3wym1Fu2FknEX8Dh3powOAVfpKY+Zn26ejzqqRy8kil2dy3pXx 4/KJaCPXN78oHEevBtJTHdfoZ6wweSiYLyBwCH48LQFmmb1L4OaOYRq3+i+96NYJmKN/ 7hkijN0sTxJjcUOqPwLQkLAPFkePtpceiXoxHm5WTuIBvMBZ3FlVos/+i+ay/U/HOBoy ZBIUye/pWSje1k6kCqrEnDhOBOsS+n5fVRJjCfQvaE5/vUUQ+2cxhgDy63TBdrJOD5t+ KvYD0KyyHTuQmOgZFu5/U7Qm94MD0iAbYIzKEWb91GSlgzTFV/cPZWqiSHNdMOi5AocK gJgw== X-Forwarded-Encrypted: i=1; AJvYcCVsUgE8UZjZfqtAGrDCsuoQKteEtUv6db7k1vq0jyf9HG3vp0QgRzyv8tLB84O8BUwFwrvxk0iIhQusd9Gr@lists.postgresql.org X-Gm-Message-State: AOJu0YywXo03adqSwphw/GCwfJKIm7QYvQleX9wStdzRvShbo20NhUnZ lTdB3c0mosDoC5hTBBkM6AVZQBFP6sDzZ5e4aG/66axbOqOUqIbtOzIEbvlmMUsPY2O5J4U1OVP Z/YsgG7Z4NTfxTkFS3yy/0eX17yHy0Sk= X-Gm-Gg: AeBDieuxTvIKNW0X37PErQC/CNSDh6ZtjKjZ2qqsFkztgzL5LfJmpogs8ZVt+7IcuK5 dDtVx786Qw4AkKe34hdnViyyNdxE+TFmxizxSi+o97HbNfCp40k7ZBdr0EGrul8bKOZggNzPPMf 6K/pKrTdyhnZnCVU/+NwoJmXLPboa+xDsMU5opATq+maPFt4RN0gGavmaoAXIAiGuxrb5tyU3iB YKT8uFtXhRJM3pHsJ4u06UvBVTpUK/+cCrP0qpeUuU5iv5qQ+uaI/SaDr9f6M3uScLT1j5cdppv gRikainW1APjVvLVbuzSzbvCQ+mT89MrRk8K1+aANVTVKqIIRypS/7VqN0Rj+33ZdjHO+rdh6RM = X-Received: by 2002:a05:7300:8623:b0:2c9:ee15:a0d2 with SMTP id 5a478bee46e88-2cbfc45b519mr4587226eec.6.1775615134055; Tue, 07 Apr 2026 19:25:34 -0700 (PDT) MIME-Version: 1.0 References: <20260328095204.5tsq5bldugeumrtf@erthalion> <4vhrgxmx5w4cjr7vgegur3hbkuojt2iz23v4dqfypsgvl5bszi@xrxefkkcxdja> In-Reply-To: From: Thomas Munro Date: Wed, 8 Apr 2026 14:24:57 +1200 X-Gm-Features: AQROBzDjkkMbWNJcDeX8TO-0gNYOeR0_VirsT8vlUDb4CjxUF_TLp1ogi1wFuoA Message-ID: Subject: Re: Automatically sizing the IO worker pool To: Andres Freund Cc: Dmitry Dolgov <9erthalion6@gmail.com>, PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Apr 8, 2026 at 2:09=E2=80=AFPM Thomas Munro wrote: > > Seems like there should be two fields. One saying "notify postmaster ag= ain" > > and one "postmaster start a worker". The former would only be cleared = by > > postmaster after the timeout. > > Good idea. V7 has two tweaks: > > * separate grow and grow_signal_sent flags, as you suggested > * it also applies the io_worker_launch_delay to cancelled grow requests Oh, but that logic should of course be moved below the "time in the past" check. Will do...