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 1prIlv-000714-UN for pgsql-hackers@arkaria.postgresql.org; Tue, 25 Apr 2023 13:31: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 1prIls-0002CE-VD for pgsql-hackers@arkaria.postgresql.org; Tue, 25 Apr 2023 13:31:52 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1prIls-0002Bv-Ju for pgsql-hackers@lists.postgresql.org; Tue, 25 Apr 2023 13:31:52 +0000 Received: from mail-oo1-xc30.google.com ([2607:f8b0:4864:20::c30]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1prIlp-001owA-G8 for pgsql-hackers@postgresql.org; Tue, 25 Apr 2023 13:31:51 +0000 Received: by mail-oo1-xc30.google.com with SMTP id 006d021491bc7-546dabe03e9so809532eaf.1 for ; Tue, 25 Apr 2023 06:31:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1682429508; x=1685021508; 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=fuwCmLzTkBC9uKcHwWFzmO5+d/r49Cdh9if9QE66mSY=; b=pwr6YPuthVOiy8shFMImC6D9QIdcs2VPK99y+wceq0L9l0ePuKoqOVgIMt+KrE0J+3 0KoCTspuPKRfLxDmDN9xSJ37SEkRIGJpJlpGHciQR2/sAzo1k1/5235Jr4S3q8gLuYH7 BWQL4oJZUuBAEvhmeNjIpSjwucCs6D6o4PCnSqRGVmjHyCTQCw9h5IObsDTH2SPB7b8t j9tqxs7C2k1XdqnNZMJt+mCDA4W6CjUVPQ5LAUWAxFQy6SOLg5ongBXSOt39QfOSmDAf MIxZ9oeG1w+6F9CTW7eiaRm9JVRtK78hKw8a8CnnxjGVJBPzB1iKzfuxHmh2qkAKtARY 3R+A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1682429508; x=1685021508; 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=fuwCmLzTkBC9uKcHwWFzmO5+d/r49Cdh9if9QE66mSY=; b=KEHF4Vrr6PkmQHu4/kzOn4tFe/kpgm879r4CqU4M3oi9X84IpOSxTfusonEmgh05zg 2z3sEC+Hwtge70iu150RyhsWbJ2m1TPaPGQezsYC7FFppIPbLSsplB5Bk7B8b5QCXvm0 G7H6grqB46mbOEBgaoxPHJaFlXzdIri/4//MjyW9lUFTMCJ9FO6GUytMe0EXCNni2beq He7pF/dMEzNPB5QyOSUiLW9NSm8EP+FdsW6JRV/Hk8ZQICUGC/OWTNLaKyxyL7CDwpXt jGQeUelXsMzKNEBuNDI8hETT1SwYid3cHPfQ0biX5LUNfdSSaEAxDHRjQxgW1XyC+aU5 7jVA== X-Gm-Message-State: AAQBX9fuNyqykJlc0+3BhcW1zH3uE1GLBisNPVITCMCYatbdbUiDvjpR F40wbmvD9Qw3sfnkWzRaV4v4rIObDC8zLe/iEms= X-Google-Smtp-Source: AKy350aBhwTVQL0MC3Nlmr1ymXaVDouBhTxcclk8vE7t7M0Ga9K32ieOgn7Uh+NSLDs8kgNKiF8YskKXqiVY/yWAo1E= X-Received: by 2002:a4a:b409:0:b0:546:dbb9:4318 with SMTP id y9-20020a4ab409000000b00546dbb94318mr1089472oon.0.1682429507570; Tue, 25 Apr 2023 06:31:47 -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: <2DD2F71A-39F9-4E43-84BC-1720BBBFA11A@yesql.se> From: Masahiko Sawada Date: Tue, 25 Apr 2023 22:31:11 +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 9:39=E2=80=AFPM Daniel Gustafsson = wrote: > > > On 17 Apr 2023, at 04:04, Masahiko Sawada wrote= : > > > I've attached an updated patch for fixing at_dobalance condition. > > I revisited this and pushed it to all supported branches after another ro= und of > testing and reading. Thanks! Can we mark the open item "Can't disable autovacuum cost delay through storage parameter" as resolved? Regards, --=20 Masahiko Sawada Amazon Web Services: https://aws.amazon.com