PostgreSQLã®ã‚¢ãƒ¼ã‚テクãƒãƒ£ãƒ¼æ¦‚è¦ï½œPostgreSQLインサイドPostgreSQLã«ã¯ã€ç”¨é€”や環境ã«å¿œã˜ã¦æ§˜ã€…ãªæ§‹æˆã‚’組ã¿ã€æœ€é©ãªãƒ‘フォーマンスã§å‹•ä½œã•ã›ã‚‰ã‚Œã‚‹ã‚ˆã†ã€è¨å®šãƒ•ã‚¡ã‚¤ãƒ«postgresql.confã«å¤šãã®ãƒ‘ラメーターãŒå˜åœ¨ã—ã¾ã™ã€‚ãã®ãƒ‘ラメーターをæ£ã—ãè¨å®šã—調整を行ã†ãŸã‚ã«ã¯ã€PostgreSQLã®ã‚¢ãƒ¼ã‚テクãƒãƒ£ãƒ¼ã‚’ç†è§£ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã“ã§ã¯ã€æŠ¼ã•ãˆã¦ãŠããŸã„ã€PostgreSQLã®åŸºæœ¬çš„ãªã‚¢ãƒ¼ã‚テクãƒãƒ£ãƒ¼ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ãªãŠã€ã“ã®è¨˜äº‹ã§å¯¾è±¡ã«ã—ã¦ã„ã‚‹PostgreSQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯9.5以é™ã§ã™ã€‚ 1. PostgreSQLã®åŸºæœ¬æ§‹æˆ PostgreSQLã®åŸºæœ¬çš„ãªæ§‹æˆã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ã¯ã˜ã‚ã«ã€ä¸»ãªãƒ—ãƒã‚»ã‚¹ã€ãƒ¡ãƒ¢ãƒªãƒ¼ã€ãŠã‚ˆã³ã€ãƒ•ã‚¡ã‚¤ãƒ«ã«ã¤ã„ã¦ã®æ§‹æˆå›³ã‚’示ã—ã¾ã™ã€‚ 図1 PostgreSQLã®åŸºæœ¬æ§‹æˆ PostgreSQLを構æˆã™ã‚‹ä¸»ãªãƒ—ãƒã‚»ã‚¹ã€ãƒ¡ãƒ¢ãƒªãƒ¼ã€ãƒ•ã‚¡ã‚¤ãƒ«ã«ã¤ã„ã¦ã€ãã®ç”¨èªžã¨æ¦‚è¦ã‚’説明ã—ã¾ã™ã€‚ リスナープãƒã‚»ã‚¹
ã¯ã˜ã‚㫠· PostgreSQL Internals
GPUã¨SSDãŒPostgreSQLã‚’åŠ é€Ÿã™ã‚‹ï½žã‚¯ã‚¨ãƒªå‡¦ç†ã‚¹ãƒ«ãƒ¼ãƒ—ット10GB/sã¸ã®æŒ‘戦～ [DB Tech Showcase Tokyo/2017]![GPUã¨SSDãŒPostgreSQLã‚’åŠ é€Ÿã™ã‚‹ï½žã‚¯ã‚¨ãƒªå‡¦ç†ã‚¹ãƒ«ãƒ¼ãƒ—ット10GB/sã¸ã®æŒ‘戦～ [DB Tech Showcase Tokyo/2017]](https://cdn-ak-scissors.b.st-hatena.com/image/square/255658386c37b7f0c6de69ed4efa7023f74b1176/height=288;version=1;width=512/https%3A%2F%2Fcdn.slidesharecdn.com%2Fss_thumbnails%2F20170906dbtsgpussdacceleratespostgresqljp-170906073226-thumbnail.jpg%3Fwidth%3D640%26height%3D640%26fit%3Dbounds)
{{#tags}}- {{label}}
{{/tags}}