autovacuum freeze recommendations at table level

From: Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org, pgsql-in-general(at)postgresql(dot)org, Christoph Berg <myon(at)debian(dot)org>
Subject: autovacuum freeze recommendations at table level
Date: 2024-08-11 06:13:58
Message-ID: CAJCZko+yQzSRaHa_U2cQ3aeHtMKcyrgOSnVjoZkJsH2LH3f69g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-in-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2024-08-11 10:09:44 Re: Insert works but fails for merge
Previous Message yudhi s 2024-08-10 21:40:52 Re: Insert works but fails for merge

Browse pgsql-in-general by date

  From Date Subject
Next Message semab tariq 2024-08-12 16:37:17 Re: autovacuum freeze recommendations at table level
Previous Message Christophe Pettus 2024-08-10 17:15:46 Re: Soluton on Lock:extend issue