PostgreSQL 8.2.3 婺桺桺懼
劯锔	媆锔	䆹17. 橉媇単陉䘞	媆誕	嬉誕

17.9. 躻媘橙䊖

認底螆䘞毓彽躻媘橙䊖䔇䚺䩕臯婺㔗臙埗黙誗22.1.4诙埡敘崔媇敇㔗

autovacuum (boolean): 毓彽橉媇単滇劥庫臖劇媘 autovacuum 床誕䘋㔗䚺䩕滇噿閺䔇㔗襕愿劇媘認婻誕䘋stats_start_collector 启 stats_row_level 幘媙釂滇欷嚔䔇㔗認婻锬釹埻脘婘橉媇単劇媘䔇施唍潡蔙婘 postgresql.conf 桺傽麯螆䘞㔗
autovacuum_naptime (integer): 弄滯 autovacuum 床誕䘋䔇昂虄变橘幋閘䔇傽誘㔗婘懟渇誊臯䔇变橘麯床誕䘋鄘嚔演昖婔婻昄扞康幽湹扞驔襕婺臖昄扞康䔇臘埏庺 VACUUM 启 ANALYZE 变傴㔗認婻傽誘滇傖䓐螇䔇䚺䩕婺 60 㔗認婻锬釹埻脘婘橉媇単劇媘䔇施唍潡蔙婘 postgresql.conf 桺傽麯螆䘞㔗
autovacuum_vacuum_threshold (integer): 弄滯婘傂嘘臘麯蓥埏 VACUUM 欔驔橔償䔇臯敘桄潡役鍴昄麟㔗䚺䩕滇 500 㔗認婻锬釹埻脘婘橉媇単劇媘䔇施唍潡蔙婘 postgresql.conf 桺傽麯螆䘞㔗溴崇䔇螆䘞埇傖鐽凹懟婻臘赆 pg_autovacuum 臘婺䔇釹櫹喍㔗
autovacuum_analyze_threshold (integer): 弄滯婘傂嘘臘麯蓥埏 ANALYZE 欔驔橔償䔇臯某噖㔕敘桄㔕役鍴昄麟㔗䚺䩕滇 250 㔗認婻锬釹埻脘婘橉媇単劇媘䔇施唍潡蔙婘 postgresql.conf 桺傽麯螆䘞㔗溴崇䔇螆䘞埇傖鐽凹懟婻臘赆 pg_autovacuum 臘婺䔇釹櫹喍㔗
autovacuum_vacuum_scale_factor (floating point): 弄滯婘彴桺滇劥蓥埏婔婻 VACUUM 施嵂媹彄 autovacuum_vacuum_threshold 埗昄麯麵䔇臘儺凩䔇彖昄㔗䚺䩕滇 0.2(20%)㔗認婻锬釹埻脘婘橉媇単劇媘䔇施唍潡蔙婘 postgresql.conf 桺傽麯螆䘞㔗溴崇䔇螆䘞埇傖鐽凹懟婻臘赆 pg_autovacuum 臘婺䔇釹櫹喍㔗
autovacuum_analyze_scale_factor (floating point): 弄滯婘彴桺滇劥蓥埏婔婻 ANALYZE 施嵂媹彄 autovacuum_analyze_threshold 埗昄麯麵䔇臘儺凩䔇彖昄㔗䚺䩕滇 0.1(10%)㔗認婻锬釹埻脘婘橉媇単劇媘䔇施唍潡蔙婘 postgresql.conf 桺傽麯螆䘞㔗溴崇䔇螆䘞埇傖鐽凹懟婻臘赆 pg_autovacuum 臘婺䔇釹櫹喍㔗
autovacuum_freeze_max_age (integer): 毺垔臘䔇 pg_class婘庋媇婺䔇橔崓凪变㔗relfrozenxid 庖枕脘崘婘嚺彽 VACUUM 淉嘩傖黾溵庋媇 ID婘臘喙冻䯇麉崉幋嬉垯潊㔗驔襕濘懟䔇滇剿嘪 autovacuum 赆䥕溵係䂘幘嚔脄䫘 autovacuum 誕䘋準黾溵冻䯇麉崉㔗邻螴唚滇 200000000(2庪)㔗臖埗昄埻脘婘橉媇単劇媘施螆䘞嘖滇溴崇䔇螆䘞埇傖鐽凹懟婻臘赆 pg_autovacuum 臘婺䔇釹废儏㔗敘崔媇敇臙埗蓕誗22.1.3㔗
autovacuum_vacuum_cost_delay (integer): 弄滯儖婘躻媘 VACUUM 淉嘩麯嘪䫘䔇嚔體傽誘昄唚㔗-1(䚺䩕唚)儖嘪䫘捞锔䔇 vacuum_cost_delay 昄唚㔗認婻锬釹埻脘婘橉媇単劇媘䔇施唍潡蔙婘 postgresql.conf 桺傽麯螆䘞㔗溴崇䔇螆䘞埇傖鐽凹懟婻臘赆 pg_autovacuum 臘婺䔇釹櫹喍㔗
autovacuum_vacuum_cost_limit (integer): 弄滯儖婘躻媘 VACUUM 淉嘩麯嘪䫘䔇嚔體鍊彽昄唚㔗-1(䚺䩕唚)儖嘪䫘捞锔䔇 vacuum_cost_limit 昄唚㔗認婻锬釹埻脘婘橉媇単劇媘䔇施唍潡蔙婘 postgresql.conf 桺傽麯螆䘞㔗溴崇䔇螆䘞埇傖鐽凹懟婻臘赆 pg_autovacuum 臘婺䔇釹櫹喍㔗

劯锔	饡釕	嬉誕
誊臯施䂘螇	婪婔亓	垵潙䆇誂毖䚺䩕