| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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 |