[postgres]大容é‡ãƒ¡ãƒ¢ãƒªã‹ã¤OSãŒRHEL(CentOS)6系をãŠä½¿ã„ã®æ–¹ã€THPã®defragã¯æ¢ã‚ãŸæ–¹ãŒè‰¯ã„ã§ã™ã‚ˆ - Qiitaâ– ç¾è¡Œè¨å®šç¢ºèª # cat /sys/kernel/mm/transparent_hugepage/defrag ⇒alwayã§ã‚ã‚Œã°å¯¾è±¡ â– ã‚れ？sys高ã„ãªã¨æ€ã£ãŸã¨ãã«æ‰“㤠# perf top ⇒以下ã®ã‚ˆã†ã«å‡ºãŸã‚‰ã™ãã«THPã®defragè¨å®šã‚’見直ã—ã¾ã—ょㆠ～～～ Samples: 2M of event 'cycles', Event count (approx.): 908733026153 42.59% [kernel] [k] compaction_alloc　　â†â˜…ã“ã‚Œ (圧縮_å†é…ç½®) 8.09% [kernel] [k] __reset_isolation_suitable 2.32% [kernel] [k] compact_zone ... ～～～ èµ·ããŸã“㨠CPU使用率ã®sysãŒå¼µã‚Šä»˜ã postgresã®å‡¦ç†ãŒæ¢ã¾ã‚‹ postgresã®ãƒ—ãƒã‚»ã‚¹ãŒå¤§é‡
![[postgres]大容é‡ãƒ¡ãƒ¢ãƒªã‹ã¤OSãŒRHEL(CentOS)6系をãŠä½¿ã„ã®æ–¹ã€THPã®defragã¯æ¢ã‚ãŸæ–¹ãŒè‰¯ã„ã§ã™ã‚ˆ - Qiita](https://cdn-ak-scissors.b.st-hatena.com/image/square/d99eedfe105353b4bd6d0d9383bac1265c65f3c1/height=288;version=1;width=512/https%3A%2F%2Fqiita-user-contents.imgix.net%2Fhttps%253A%252F%252Fqiita-user-contents.imgix.net%252Fhttps%25253A%25252F%25252Fcdn.qiita.com%25252Fassets%25252Fpublic%25252Farticle-ogp-background-afbab5eb44e0b055cce1258705637a91.png%253Fixlib%253Drb-4.0.0%2526w%253D1200%2526blend64%253DaHR0cHM6Ly9xaWl0YS11c2VyLXByb2ZpbGUtaW1hZ2VzLmltZ2l4Lm5ldC9odHRwcyUzQSUyRiUyRnFpaXRhLWltYWdlLXN0b3JlLnMzLmFtYXpvbmF3cy5jb20lMkYwJTJGMTIwNzA3JTJGcHJvZmlsZS1pbWFnZXMlMkYxNDczNzE0NjY5P2l4bGliPXJiLTQuMC4wJmFyPTElM0ExJmZpdD1jcm9wJm1hc2s9ZWxsaXBzZSZmbT1wbmczMiZzPWJkOWIyOTkxM2I4ZWU4NDBjNDIzZDc3MzBmNWI1ZDRi%2526blend-x%253D120%2526blend-y%253D467%2526blend-w%253D82%2526blend-h%253D82%2526blend-mode%253Dnormal%2526s%253D31e7577f4567f1c088521ced8e6b3a16%3Fixlib%3Drb-4.0.0%26w%3D1200%26fm%3Djpg%26mark64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTk2MCZoPTMyNCZ0eHQ9JTVCcG9zdGdyZXMlNUQlRTUlQTQlQTclRTUlQUUlQjklRTklODclOEYlRTMlODMlQTElRTMlODMlQTIlRTMlODMlQUElRTMlODElOEIlRTMlODElQTRPUyVFMyU4MSU4Q1JIRUwlMjhDZW50T1MlMjk2JUU3JUIzJUJCJUUzJTgyJTkyJUUzJTgxJThBJUU0JUJEJUJGJUUzJTgxJTg0JUUzJTgxJUFFJUU2JTk2JUI5JUUzJTgwJTgxVEhQJUUzJTgxJUFFZGVmcmFnJUUzJTgxJUFGJUU2JUFEJUEyJUUzJTgyJTgxJUUzJTgxJTlGJUU2JTk2JUI5JUUzJTgxJThDJUU4JTg5JUFGJUUzJTgxJTg0JUUzJTgxJUE3JUUyJTgwJUE2JnR4dC1hbGlnbj1sZWZ0JTJDdG9wJnR4dC1jb2xvcj0lMjMxRTIxMjEmdHh0LWZvbnQ9SGlyYWdpbm8lMjBTYW5zJTIwVzYmdHh0LXNpemU9NTYmdHh0LXBhZD0wJnM9MmEzMTJiYzUxNWU3ZjM5ODE3YmMyMzFmNzZkNTAxZmM%26mark-x%3D120%26mark-y%3D112%26blend64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTgzOCZoPTU4JnR4dD0lNDBNb3JpaGF5YSZ0eHQtY29sb3I9JTIzMUUyMTIxJnR4dC1mb250PUhpcmFnaW5vJTIwU2FucyUyMFc2JnR4dC1zaXplPTM2JnR4dC1wYWQ9MCZzPTE2MWRiNWM2YTc5MTM5YzQwM2NhN2Q4MjM2YzVkMzVk%26blend-x%3D242%26blend-y%3D454%26blend-w%3D838%26blend-h%3D46%26blend-fit%3Dcrop%26blend-crop%3Dleft%252Cbottom%26blend-mode%3Dnormal%26txt64%3DaW4gQUVPTg%26txt-x%3D242%26txt-y%3D539%26txt-width%3D838%26txt-clip%3Dend%252Cellipsis%26txt-color%3D%25231E2121%26txt-font%3DHiragino%2520Sans%2520W6%26txt-size%3D28%26s%3D0d73d5d075dd1795440e307bf0f2f45c)
ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨éšœå®³å¾©æ—§ã‹ã‚‰è€ƒãˆã‚‹Oracle Database, MySQL, PostgreSQLã®é•ã„
PostgreSQLアンãƒãƒã‚šã‚¿ãƒ¼ãƒ³
(JP) GPGPUãŒPostgreSQLã‚’åŠ é€Ÿã™ã‚‹
ã‚‚ã†ã²ã¨ã¤ã®ã€ŒPostgreSQL Internalsã€æŠ€è¡“文書ãŒå…¬é–‹ã•ã‚Œã¾ã—ãŸ
Pgpool-IIã®æŽ¥ç¶šæ€§èƒ½ã®æ”¹å–„ | Let's POSTGRES
Amazon Web Services – RDBMS in the Cloud: PostgreSQL on AWS
sqlmap: automatic SQL injection and database takeover tool
独り言v6 » PostgreSQL 7.3ã‹ã‚‰9.1ã¾ã§ãƒ™ãƒ³ãƒã‚’å–ã£ã¦ã¿ãŸã€‚
Let'sプãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
Ywcafe.net
ã€ãƒã‚¦ãƒ„ー】PostgreSQLã®é«˜é€ŸåŒ–ã¨é«˜ä¿¡é ¼åŒ–を実ç¾ã™ã‚‹ã€Œpgpool-IIã€ã‚’使ã£ã¦ã¿ã‚‹ (1) pgpool-IIã®æ¦‚è¦ | エンタープライズ | マイコミジャーナル
VACUUM FULLã¨REINDEXã¨ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚º — NPO法人 日本PostgreSQLユーザ会
ã€ã‚³ãƒ©ãƒ 】Yet Another 仕事ã®ãƒ„ール (27) pgpoolã®éšœå®³æ¤œå‡ºã¨ç¸®é€€é‹è»¢ | エンタープライズ | マイコミジャーナル
[ThinkIT] 第1回：PostgreSQL 㨠MySQL ã®ç´¹ä»‹ (1/4)
{{#tags}}- {{label}}
{{/tags}}