{"id":339,"date":"2016-02-24T13:47:04","date_gmt":"2016-02-24T04:47:04","guid":{"rendered":"https:\/\/www.manageengine.jp\/support\/kb\/ADAudit_Plus\/?p=339"},"modified":"2020-05-21T17:23:47","modified_gmt":"2020-05-21T08:23:47","slug":"%e3%82%a2%e3%83%bc%e3%82%ab%e3%82%a4%e3%83%96%e5%8c%96%e3%81%97%e3%81%a6%e3%81%84%e3%81%aa%e3%81%84%e3%81%ae%e3%81%abdb%e5%ae%b9%e9%87%8f%e3%81%8c%e6%b8%9b%e5%b0%91%e3%81%99%e3%82%8b%e5%8e%9f%e5%9b%a0","status":"publish","type":"post","link":"https:\/\/www.manageengine.jp\/support\/kb\/ADAudit_Plus\/?p=339","title":{"rendered":"\u30a2\u30fc\u30ab\u30a4\u30d6\u5316\u3057\u3066\u3044\u306a\u3044\u306e\u306bDB\u5bb9\u91cf\u304c\u6e1b\u5c11\u3059\u308b\u73fe\u8c61\u306b\u3064\u3044\u3066"},"content":{"rendered":"

\u30a2\u30fc\u30ab\u30a4\u30d6\u5316\u3057\u3066\u3044\u306a\u3044\u306e\u306b\u3082\u95a2\u308f\u3089\u305a\u3001DB\u306e\u5bb9\u91cf\u304c\u6e1b\u5c11\u3059\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u304c\u3001\u305d\u308c\u306fPostgreSQL\u306b\u5b9f\u88c5\u3055\u308c\u3066\u3044\u308b\"auto vacuum<\/strong>\"\u3068\u3044\u3046\u6a5f\u80fd\u304c\u5f71\u97ff\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n

\"auto vacuum<\/strong>\"\u3068\u306f\u3001\u300cVACUUM\u300d\u3068\u3044\u308f\u308c\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u6383\u9664\u4f5c\u696d\u3068\u300cANALYZE\u300d\u3068\u3044\u308f\u308c\u308b\u7d71\u8a08\u60c5\u5831\u306e\u53d6\u5f97\u4f5c\u696d\u3092\u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u306b\u3088\u308a\u3001PostgreSQL\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u6700\u9069\u5316\u3092\u884c\u3046\u6a5f\u80fd\u3067\u3059\u3002<\/p>\n

 <\/p>\n

\"auto vacuum\"\u306e\u8a2d\u5b9a\u5185\u5bb9\u306f\u4ee5\u4e0b\u306e\u5834\u6240\u304b\u3089\u78ba\u8a8d\u3067\u304d\u307e\u3059\uff1a<\/strong><\/p>\n

1. \"[ADAudit Plus \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30c7\u30a3\u30ec\u30af\u30c8\u30ea]\\pgsql\\data\"\u306b\u79fb\u52d5\u3057\u307e\u3059\u3002
\n2. \u30e1\u30e2\u5e33\u4ee5\u5916\u306e\u30c6\u30ad\u30b9\u30c8\u30a8\u30c7\u30a3\u30bf\u3092\u8d77\u52d5\u3057\u3001\"postgresql.conf\"\u3092\u958b\u304d\u307e\u3059\u3002
\n3. \"AUTOVACUUM PARAMETERS\"\u3068\u3044\u3046\u9805\u76ee\u304cautovacuum\u306e\u8a2d\u5b9a\u60c5\u5831\u3067\u3059\u3002<\/p>\n

#autovacuum = on # Enable autovacuum subprocess? 'on'
\n# requires track_counts to also be on.
\n#log_autovacuum_min_duration = -1 # -1 disables, 0 logs all actions and
\n# their durations, > 0 logs only
\n# actions running at least this number
\n# of milliseconds.
\n#autovacuum_max_workers = 3 # max number of autovacuum subprocesses
\n# (change requires restart)
\n#autovacuum_naptime = 1min # time between autovacuum runs
\n#autovacuum_vacuum_threshold = 50 # min number of row updates before
\n# vacuum
\n#autovacuum_analyze_threshold = 50 # min number of row updates before
\n# analyze
\n#autovacuum_vacuum_scale_factor = 0.2 # fraction of table size before vacuum
\n#autovacuum_analyze_scale_factor = 0.1 # fraction of table size before analyze
\n#autovacuum_freeze_max_age = 200000000 # maximum XID age before forced vacuum
\n# (change requires restart)
\n#autovacuum_vacuum_cost_delay = 20ms # default vacuum cost delay for
\n# autovacuum, in milliseconds;
\n# -1 means use vacuum_cost_delay
\n#autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for
\n# autovacuum, -1 means use
\n# vacuum_cost_limit<\/span><\/p><\/blockquote>\n\n\n\n\n\n\n\n\n\n\n
\u9805\u76ee\u540d<\/th>\n\u8a2d\u5b9a\u5185\u5bb9<\/th>\n<\/tr>\n<\/tbody>\n
autovacuum<\/td>\n\u81ea\u52d5VACUUM\u306e\u30d7\u30ed\u30bb\u30b9\u3092\u5b9f\u884c\u3059\u308b\u304b\u3069\u3046\u304b\u306e\u8a2d\u5b9a<\/td>\n<\/tr>\n
autovacuum_naptime<\/td>\nautovacuum\u3092\u8d77\u52d5\u3059\u308b\u9593\u9694<\/td>\n<\/tr>\n
autovacuum_vacuum_threshold<\/td>\nVACUUM\u3092\u8d77\u52d5\u3059\u308b\u30c8\u30ea\u30ac\u3068\u306a\u308b\u66f4\u65b0\u884c\u6570<\/td>\n<\/tr>\n
autovacuum_analyze_threshold<\/td>\nANALYZE\u3092\u8d77\u52d5\u3059\u308b\u30c8\u30ea\u30ac\u3068\u306a\u308b\u66f4\u65b0\u884c\u6570<\/td>\n<\/tr>\n
autovacuum_vacuum_scale_factor<\/td>\nVACUUM\u3092\u8d77\u52d5\u3059\u308b\u30c8\u30ea\u30ac\u3068\u306a\u308b\u66f4\u65b0\u884c\u6570\u306e\u5272\u5408<\/td>\n<\/tr>\n
autovacuum_analyze_scale_factor<\/td>\nANALYZE\u3092\u8d77\u52d5\u3059\u308b\u30c8\u30ea\u30ac\u3068\u306a\u308b\u66f4\u65b0\u884c\u6570\u306e\u5272\u5408<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

\u30a2\u30fc\u30ab\u30a4\u30d6\u5316\u3057\u3066\u3044\u306a\u3044\u306e\u306b\u3082\u95a2\u308f\u3089\u305a\u3001DB\u306e\u5bb9\u91cf\u304c\u6e1b\u5c11\u3059\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u304c\u3001\u305d\u308c\u306fPostgreSQL\u306b\u5b9f\u88c5\u3055\u308c\u3066\u3044\u308b\"auto vacuum\"\u3068\u3044\u3046\u2026 \uff3b\u7d9a\u304d\u3092\u8aad\u3080\uff3d<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[5,6],"tags":[126,45,46,47,44,10],"class_list":{"0":"post-339","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-design-adap","7":"category-config-adap","8":"tag-all","9":"tag-db","11":"tag-postgresql","12":"tag-vacuum","13":"tag-archive"},"modified_by":null,"_links":{"self":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADAudit_Plus\/index.php?rest_route=\/wp\/v2\/posts\/339","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADAudit_Plus\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADAudit_Plus\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADAudit_Plus\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADAudit_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=339"}],"version-history":[{"count":29,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADAudit_Plus\/index.php?rest_route=\/wp\/v2\/posts\/339\/revisions"}],"predecessor-version":[{"id":1597,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADAudit_Plus\/index.php?rest_route=\/wp\/v2\/posts\/339\/revisions\/1597"}],"wp:attachment":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADAudit_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=339"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADAudit_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=339"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADAudit_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=339"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}