Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1prKEu-0004Cz-Bc for pgsql-hackers@arkaria.postgresql.org; Tue, 25 Apr 2023 15:05:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1prKEt-0003V0-8r for pgsql-hackers@arkaria.postgresql.org; Tue, 25 Apr 2023 15:05:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1prKCB-0007EV-EF for pgsql-hackers@lists.postgresql.org; Tue, 25 Apr 2023 15:03:07 +0000 Received: from mail-oo1-xc35.google.com ([2607:f8b0:4864:20::c35]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1prKC8-0050Ur-LY for pgsql-hackers@postgresql.org; Tue, 25 Apr 2023 15:03:06 +0000 Received: by mail-oo1-xc35.google.com with SMTP id 006d021491bc7-546dabe03e9so822371eaf.1 for ; Tue, 25 Apr 2023 08:03:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1682434983; x=1685026983; 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=qsd5b+HfQBLkYFcyAz5UTz50mB1/wI6MMOU8doCkRRc=; b=cs/wsG5p1DvKRxHraAiAUV9VmyDQLJTotpg7cvAf01+ibEwk/Sc7Xu0Z2/2CWQv7/Z wb4NiFU2iBh4bfsIoQbquXr2aDcteEMahySn/OSq8+Pllk2djXgKtVuUMWijY0Apsk+S /AnIszyHRwOemLtuApVfYvwud44vCJhc3hL59j353K3zj5IF4u2TLJgZO6lfuSI541KQ FhmyqGfKEA5gmG2ai9uo7nlXmtBBnqu6C/8vXws9wraN+9m2q90AuFR+ZbAbVkYk/wAl RRMI9yrXTrl/65jkNtRlOebUAalnf/d+i/zcBB83uET5nBtJnLvn1EWjsw0E57IaZnFT OlLA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1682434983; x=1685026983; h=content-transfer-encoding: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=qsd5b+HfQBLkYFcyAz5UTz50mB1/wI6MMOU8doCkRRc=; b=AdW/5rljdZO1YxbnTi/Zvv4DFXoYhCTHZaZwj2wMcYM6XfJiykHRE1ta7xIQlCcsfc 92GExnDK66466pO0hAU9NgieHgMoG2itQvcpr4MNaEmoXT+rO3zUYRvpkwHpGlRXhsD7 6SlWzfOFuuvturwR7vdAetJSGrDCtG/JyxdSm9mjhowRfP30JpjAhNXXpaO/RMyDWFdJ 6swY6IYCfrFEIRsyjZLOAlZbgXj6mirRndiQi1Z1BIiH/LARLnahRKVGvJEZ+d/o3zKF nlmBxJcCNPH889IkdsKSl394f6OaTTZZ5QeQJN8tuDdOPL0I75EDnvpSOMmNe22nOaFk mUWQ== X-Gm-Message-State: AAQBX9dCQFGi9oH2AJ4n4PKysH4LRuG90pqE3BugbRaMh8BpFrwp7GEY etwBLT9EGmjkIo2Z/WuuGyJ7u2ijcjuoUZNyya0= X-Google-Smtp-Source: AKy350Yb/SV0fkkNOsiELiykPla8UDT8qCYQA+keWQPhHb1q0tfhhIXiYyeRmwFBe259t7f+uGBSFK+4/kfr+d867SQ= X-Received: by 2002:a4a:b547:0:b0:546:4bca:b570 with SMTP id s7-20020a4ab547000000b005464bcab570mr1074522ooo.1.1682434982609; Tue, 25 Apr 2023 08:03:02 -0700 (PDT) MIME-Version: 1.0 References: <20230329.132155.629765142788133576.horikyota.ntt@gmail.com> <20230329.173456.1185961934810139447.horikyota.ntt@gmail.com> <935191FB-083B-4060-89FC-466F61FAA391@yesql.se> <1252075.1680547394@sss.pgh.pa.us> <20230403190837.qubpnwugfe2k2g46@awork3.anarazel.de> <7E06F879-7E20-4A6A-862F-CA72CDC9A323@yesql.se> <5028847C-937A-4CC2-B127-AFF5F9FB79C5@yesql.se> <2B703533-102A-47E5-A4F7-C6A68C09BB27@yesql.se> <23D2F3D0-90C2-428A-817F-1E16194DDC2D@yesql.se> <2DD2F71A-39F9-4E43-84BC-1720BBBFA11A@yesql.se> In-Reply-To: From: Masahiko Sawada Date: Wed, 26 Apr 2023 00:02:25 +0900 Message-ID: Subject: Re: Should vacuum process config file reload more often To: Daniel Gustafsson Cc: Melanie Plageman , Robert Haas , Andres Freund , Tom Lane , Kyotaro Horiguchi , PostgreSQL Hackers , Amit Kapila 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 Tue, Apr 25, 2023 at 10:35=E2=80=AFPM Daniel Gustafsson wrote: > > > On 25 Apr 2023, at 15:31, Masahiko Sawada wrote= : > > > > On Tue, Apr 25, 2023 at 9:39=E2=80=AFPM Daniel Gustafsson wrote: > >> > >>> On 17 Apr 2023, at 04:04, Masahiko Sawada wro= te: > >> > >>> I've attached an updated patch for fixing at_dobalance condition. > >> > >> I revisited this and pushed it to all supported branches after another= round of > >> testing and reading. > > > > Thanks! > > > > Can we mark the open item "Can't disable autovacuum cost delay through > > storage parameter" as resolved? > > Yes, I've gone ahead and done that now. Great, thank you! Regards, --=20 Masahiko Sawada Amazon Web Services: https://aws.amazon.com