MIME-Version: 1.0
References: <AS8PR02MB7416A6B018735D5C73EF8EF8E8DB2@AS8PR02MB7416.eurprd02.prod.outlook.com>
In-Reply-To: <AS8PR02MB7416A6B018735D5C73EF8EF8E8DB2@AS8PR02MB7416.eurprd02.prod.outlook.com>
From: Muhammad Ikram <mmikram@gmail.com>
Date: Tue, 9 Jul 2024 18:42:11 +0500
Message-ID: <CAGeimVqLkSO-PQREPwCgfASz5ENXb9dzLcXNfypEx4J-SPO-DA@mail.gmail.com>
Subject: Re: autovacuum_vacuum_cost_delay
To: "Shenavai, Manuel" <manuel.shenavai@sap.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005b9d45061cd0b314"
Archived-At: <https://www.postgresql.org/message-id/CAGeimVqLkSO-PQREPwCgfASz5ENXb9dzLcXNfypEx4J-SPO-DA%40mail.gmail.com>
Precedence: bulk

--0000000000005b9d45061cd0b314
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi Shenvail,

Based on what I could understand,

Lower value will cause more frequent run of Autovacuum. Will have
less delay between processing data chunks but will put more load on the I/O
system. Autovacuum tasks will complete faster. Cleanup of dead tuples and
blots will be quicker thus increasing performance in the cases where tables
are heavily updated/deleted.

Higher values will result in longer delays between processing data chunks
thus slowing down the completion of autovacuum tasks. Autovacuum will have
less I/O load for its tasks. Database performance will be degraded if
operations are more update/delete intensive. Dead tuples and bloat will
take longer to be cleaned up.
It can be beneficial  for performance of other database operations,
especially if your system is I/O-bound. Can also be helpful when system
resources are less

Regards,
Muhammad Ikram
Bitnine Global.


On Tue, Jul 9, 2024 at 4:38=E2=80=AFPM Shenavai, Manuel <manuel.shenavai@sa=
p.com>
wrote:

> Hi everyone,
>
>
>
> We are doing some tests with different autovacuum settings.
>
>
>
> Looking at autovacuum_vacuum_cost_delay:
>
>
> https://www.postgresql.org/docs/current/runtime-config-autovacuum.html#GU=
C-AUTOVACUUM-VACUUM-COST-DELAY
>
>
>
> Can someone help to understand what a high or low value of this setting
> really means? Would it be OK to set this to 0? If not, why not?
>
>
>
> Thanks in advance &
> Best regards,
>
> Manuel
>


--=20
Muhammad Ikram

--0000000000005b9d45061cd0b314
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi Shenvail,<div><br></div><div>Based on what I could unde=
rstand,</div><div><br></div><div>Lower value will cause more frequent run o=
f Autovacuum. Will have less=C2=A0delay=C2=A0between processing data chunks=
 but will put more load on the I/O system. Autovacuum tasks will complete f=
aster. Cleanup of dead tuples and blots will be quicker thus increasing per=
formance in the cases where tables are heavily updated/deleted.</div><div><=
br></div><div>Higher values will result in longer delays between processing=
 data chunks thus slowing down the completion of autovacuum tasks. Autovacu=
um will have less I/O load for its tasks. Database performance will be degr=
aded if operations are more update/delete intensive. Dead tuples and bloat =
will take longer to be cleaned up.=C2=A0</div><div>It can be beneficial=C2=
=A0 for performance of other database operations, especially if your system=
 is I/O-bound. Can also be helpful when system resources are less</div><div=
><br></div><div>Regards,</div><div>Muhammad Ikram</div><div>Bitnine Global.=
</div><div><br></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" =
class=3D"gmail_attr">On Tue, Jul 9, 2024 at 4:38=E2=80=AFPM Shenavai, Manue=
l &lt;<a href=3D"mailto:manuel.shenavai@sap.com">manuel.shenavai@sap.com</a=
>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px=
 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><di=
v class=3D"msg-3059479460693395324">


<div lang=3D"en-DE" style=3D"overflow-wrap: break-word;">
<div class=3D"m_-3059479460693395324WordSection1">
<p class=3D"MsoNormal"><span lang=3D"EN-GB">Hi everyone,<u></u><u></u></spa=
n></p>
<p class=3D"MsoNormal"><span lang=3D"EN-GB"><u></u>=C2=A0<u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-GB">We are doing some tests with di=
fferent autovacuum settings.<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-GB"><u></u>=C2=A0<u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-GB">Looking at autovacuum_vacuum_co=
st_delay:<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-GB"><a href=3D"https://www.postgres=
ql.org/docs/current/runtime-config-autovacuum.html#GUC-AUTOVACUUM-VACUUM-CO=
ST-DELAY" target=3D"_blank">https://www.postgresql.org/docs/current/runtime=
-config-autovacuum.html#GUC-AUTOVACUUM-VACUUM-COST-DELAY</a><u></u><u></u><=
/span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-GB"><u></u>=C2=A0<u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-GB">Can someone help to understand =
what a high or low value of this setting really means? Would it be OK to se=
t this to 0? If not, why not?<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-GB"><u></u>=C2=A0<u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-GB">Thanks in advance &amp;<br>
Best regards,<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-GB">Manuel<u></u><u></u></span></p>
</div>
</div>

</div></blockquote></div><br clear=3D"all"><div><br></div><span class=3D"gm=
ail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signatu=
re"><div dir=3D"ltr"><div>Muhammad Ikram<br><br></div></div></div>

--0000000000005b9d45061cd0b314--