autovacuum freeze recommendations at table level

Поиск
Список
Период
Сортировка
От Durgamahesh Manne
Тема autovacuum freeze recommendations at table level
Дата
Msg-id CAJCZko+yQzSRaHa_U2cQ3aeHtMKcyrgOSnVjoZkJsH2LH3f69g@mail.gmail.com
обсуждение исходный текст
Ответы Re: autovacuum freeze recommendations at table level
Список pgsql-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 

В списке pgsql-general по дате отправления: