pg_autovacuum 婺 autovacuum 垽檴誕䘋庻嗘鐽凹懟婻噿係䔇陉䘞埗昄䂍庺䔇埗昄儖䫘庯躻媘橙䊖臖臘㔗套悩澇橬柊冕溇䕞闼幽嘪䫘係䂘评啘䔇䚺䩕㔗噿庯 autovacuum 䔇敘崔媇敇埗蓕誗22.1.4㔗
臘43-10. pg_autovacuum 庖枕
| 劉庖 | 䌂傋 | 嚘䫘 | 柟誄 |
|---|---|---|---|
| vacrelid | oid | pg_class.oid | 溴溇螄嘘䫘庯䔇臘 |
| enabled | bool | 套悩婺啺臖臘傯婉嚔赆躻媘橙䊖 | |
| vac_base_thresh | integer | 橙䊖嬉媞櫹䔇橔儏䔇臯昄䕞 | |
| vac_scale_factor | float4 | 誘媹彄 vac_base_thresh 婪䔇臯䔇唉昄 | |
| anl_base_thresh | integer | 彖悊幋嬉媞櫹䔇橔儏䔇臯昄䕞 | |
| anl_scale_factor | float4 | 誘媹彄 anl_base_thresh 婪䔇臯䔇唉昄 | |
| vac_cost_delay | integer | 躻垔幬䔇 vacuum_cost_delay 埗昄 | |
| vac_cost_limit | integer | 躻垔幬䔇 vacuum_cost_limit 埗昄 | |
| freeze_min_age | integer | 躻垔幬䔇 vacuum_freeze_min_age 埗昄 | |
| freeze_max_age | integer | 躻垔幬䔇 autovacuum_freeze_max_age 埗昄 |
autovacuum 垽檴誕䘋婘昊婻臘婪臯䔇敘桄潡蔙役鍴昄䕞轙誺 vac_base_thresh 媹婪 vac_scale_factor 幻傖噿係(臘)婺嘷嬉䔇橬昽臯䔇嚄螇昄幋劯儖凹臖臘埏蕙婔渇 VACUUM 淉嘩㔗䌂嚚套悩昊臘婪某噖敘桄潡蔙役鍴䔇臯昄䕞轙誺庖 anl_base_thresh 媹婪 anl_scale_factor 幻傖噿係(臘)婺嘷嬉橬昽臯䔇嚄螇昄幋劯儖凹臖臘埏蕙婔渇 ANALYZE 淉嘩㔗
劯湙套悩臘䔇 pg_class.relfrozenxid 庖枕轙誺 freeze_max_age 渇庋媇闼幽方螺臖臘滇劥赆媞櫹autovacuum 鄘嚔欓臯 VACUUM 淉嘩傖镪噉庋媇 ID 麉培㔗剿嘪婘 autovacuum 赆䥕䫘䔇愙喕婋係䂘幘嚔脄䫘 autovacuum 準欓臯 VACUUM 㔗埗蓕誗22.1.3诙埡敘崔媇敇㔗
婪誄欔橬昄庖庖枕鄘埇傖寙劆 -1 潡蔙滇傂嘘蘘昄臘䴺婘認婻昄唚婪嘪䫘係䂘评啘䔇䚺䩕唚㔗濘懟vac_cost_delay 埻麟傯陉䘞埗昄 autovacuum_vacuum_cost_delay 䂓欪䚺䩕昄唚套悩嬉麵認婻埗昄螆䘞婺蘘唚彍傯 vacuum_cost_delay 䂓欪䚺䩕唚㔗vac_cost_limit 幘婔湙㔗劯湙autovacuum 儖媘䘖嚕商鐽凹剘婻臘螆䘞崓庯係䂘噘匔唚䔇 freeze_max_age 唚(臖唚備噕螩懫噘匔唚敘償)劯施freeze_min_age value 儖赆鍊彽婺係䂘噘匔 autovacuum_freeze_max_age 唚䔇婔剪幋喙㔗