MIME-Version: 1.0
From: Durgamahesh Manne <maheshpostgres9@gmail.com>
Date: Sun, 11 Aug 2024 11:43:58 +0530
Message-ID: <CAJCZko+yQzSRaHa_U2cQ3aeHtMKcyrgOSnVjoZkJsH2LH3f69g@mail.gmail.com>
Subject: autovacuum freeze recommendations at table level
To: pgsql-general@lists.postgresql.org, pgsql-in-general@postgresql.org, 
	Christoph Berg <myon@debian.org>
Content-Type: multipart/alternative; boundary="000000000000103dcd061f624231"
Archived-At: <https://www.postgresql.org/message-id/CAJCZko%2ByQzSRaHa_U2cQ3aeHtMKcyrgOSnVjoZkJsH2LH3f69g%40mail.gmail.com>
Precedence: bulk

--000000000000103dcd061f624231
Content-Type: text/plain; charset="UTF-8"

Hi  Respected Team,

Could you please let me know that how this freeze parameters work
Update query runs on table  through which data being modified daily in this
case
Total records in table is about 20lakhs
current setting for this table is
Access method: heap
if it reaches > 0.1*2000000+1000 = 2,10,000 as per the formula autovacuum
triggers
Options: fillfactor=85, autovacuum_vacuum_cost_delay=0,
autovacuum_vacuum_cost_limit=3000, parallel_workers=6,
autovacuum_vacuum_scale_factor=0.1, autovacuum_vacuum_threshold=1000,
autovacuum_freeze_max_age=20000000,
autovacuum_multixact_freeze_max_age=20000000, autovacuum_freeze_min_age=0

How autovacuum freeze parameters work.Give me some recommendations to
improve the performance better than now
Ex :ALTER TABLE table SET (
   autovacuum_freeze_max_age = 20000000,(2 crores)
   autovacuum_multixact_freeze_max_age = 20000000,(2 crores)
   autovacuum_freeze_min_age = 0
);
Regards,
Durga Mahesh

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

<div dir=3D"ltr">Hi=C2=A0 Respected Team,<div><br></div><div>Could you plea=
se=C2=A0let me know that how this freeze parameters work</div><div>Update q=
uery runs on table=C2=A0 through which data being modified daily in this ca=
se</div><div>Total records in table is about 20lakhs</div><div>current sett=
ing for this=C2=A0table is=C2=A0</div><div>Access method: heap</div><div>if=
 it reaches &gt; 0.1*2000000+1000 =3D 2,10,000 as per the formula autovacuu=
m triggers<br>Options: fillfactor=3D85, autovacuum_vacuum_cost_delay=3D0, a=
utovacuum_vacuum_cost_limit=3D3000, parallel_workers=3D6, autovacuum_vacuum=
_scale_factor=3D0.1, autovacuum_vacuum_threshold=3D1000, autovacuum_freeze_=
max_age=3D20000000, autovacuum_multixact_freeze_max_age=3D20000000, autovac=
uum_freeze_min_age=3D0<br></div><div><br></div><div>How autovacuum freeze p=
arameters work.Give me some recommendations to improve the performance bett=
er than now=C2=A0</div><div>Ex :ALTER TABLE table SET (<br>=C2=A0 =C2=A0aut=
ovacuum_freeze_max_age =3D 20000000,(2 crores)<br>=C2=A0 =C2=A0autovacuum_m=
ultixact_freeze_max_age =3D 20000000,(2 crores)<br>=C2=A0 =C2=A0autovacuum_=
freeze_min_age =3D 0<br>);<br>Regards,</div><div>Durga Mahesh=C2=A0</div></=
div>

--000000000000103dcd061f624231--