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
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,
autovacuum_freeze_max_age = 20000000,(2 crores)
autovacuum_multixact_freeze_max_age = 20000000,(2 crores)
autovacuum_freeze_min_age = 0
);
Regards,
Durga Mahesh
