{"id":952,"date":"2020-12-14T14:19:31","date_gmt":"2020-12-14T05:19:31","guid":{"rendered":"https:\/\/azbase-azbase-dev2.azurewebsites.net\/ja-jp\/events\/azurebase\/?p=952"},"modified":"2022-09-19T18:28:39","modified_gmt":"2022-09-19T09:28:39","slug":"analyzing-the-limits-of-connection-scalability-in-postgres","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/blog\/analyzing-the-limits-of-connection-scalability-in-postgres\/","title":{"rendered":"Postgres \u306b\u304a\u3051\u308b\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u9650\u754c\u306e\u5206\u6790"},"content":{"rendered":"<p>\u203b\u672c\u30d6\u30ed\u30b0\u306f\u3001Microsoft Tech Community Blog \u2018\u2019<a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266\" aria-label=\"Analyzing the Limits of Connection Scalability in Postgres - Microsoft Tech Community: \u30af\u30ea\u30c3\u30af\u3057\u3066\u30d6\u30ed\u30b0\u8a18\u4e8b\u5168\u6587\u3092\u8aad\u3080\">Analyzing the Limits of Connection Scalability in Postgres &#8211; Microsoft Tech Community<\/a>\u2018\u2019\u306e\u6284\u8a33\u3067\u3059\u3002<\/p>\n<p>\u9ad8\u8ca0\u8377\u306ePostgres\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u7ba1\u7406\u3059\u308b\u4eba\u3084\u3001\u305d\u306e\u72b6\u6cc1\u3092\u4e88\u60f3\u3059\u308b\u4eba\u306b\u3068\u3063\u3066\u306ePostgres\u306e\u5171\u901a\u306e\u8ab2\u984c\u306e1\u3064\u306f\u3001Postgres\u304c\u975e\u5e38\u306b\u5927\u91cf\u306e\u63a5\u7d9a\u3092\u3046\u307e\u304f\u51e6\u7406\u3057\u3066\u3044\u306a\u3044\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u3002<\/p>\n<p>\u6570\u5343\u306e\u63a5\u7d9a\u3092\u554f\u984c\u306a\u304f\u78ba\u7acb\u3059\u308b\u3053\u3068\u306f\u53ef\u80fd\u3067\u3059\u304c\u3001\u73fe\u5b9f\u7684\u3067\u56de\u907f\u304c\u96e3\u3057\u3044\u554f\u984c\u304c\u3044\u304f\u3064\u304b\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u6628\u5e74<a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/microsoft-azure-welcomes-postgresql-committers\/ba-p\/1207612\" aria-label=\"\u30de\u30a4\u30af\u30ed\u30bd\u30d5\u30c8 Azure \u306f PostgreSQL \u30b3\u30df\u30c3\u30bf\u30fc\u3092\u6b53\u8fce\u3057\u307e\u3059: \u30d6\u30ed\u30b0\u8a18\u4e8b\u3092\u8aad\u3080\">\u30de\u30a4\u30af\u30ed\u30bd\u30d5\u30c8<\/a><u>\u306b\u5165\u793e<\/u>\u3057\u3066\u3001\u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u306e Postgres \u306b\u53d6\u308a\u7d44\u3093\u3067\u3044\u308b <a class=\"c-hyperlink\" href=\"https:\/\/azure.microsoft.com\/services\/postgresql\/\" aria-label=\"Azure Database for PostgreSQL \u30db\u30fc\u30e0\u30da\u30fc\u30b8\">Azure Database for PostgreSQL<\/a> \u306e\u30c1\u30fc\u30e0\u306b\u53c2\u52a0\u3057\u3066\u4ee5\u6765\u3001Postgres \u306e\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306b\u95a2\u3059\u308b\u3044\u304f\u3064\u304b\u306e\u554f\u984c\u3092\u5206\u6790\u3057\u5bfe\u51e6\u3059\u308b\u306e\u306b\u591a\u304f\u306e\u6642\u9593\u3092\u8cbb\u3084\u3057\u3066\u304d\u307e\u3057\u305f\u3002<\/p>\n<p>&lt;p&#8221;&gt;\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001Postgres \u306e\u5927\u91cf\u306e\u63a5\u7d9a\u306e\u53d6\u308a\u6271\u3044\u3092\u6539\u5584\u3059\u308b\u3053\u3068\u304c\u91cd\u8981\u3060\u3068\u601d\u3046\u7406\u7531\u3092\u8aac\u660e\u3057\u307e\u3059\u3002\u7d9a\u3044\u3066\u3001Postgres \u306e\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306b\u5bfe\u3059\u308b\u3055\u307e\u3056\u307e\u306a\u5236\u9650\u9762\u306e\u5206\u6790\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n<p>\u4eca\u5f8c\u306e\u6295\u7a3f\u3067\u306f\u3001Postgres \u3067\u306e\u63a5\u7d9a\u51e6\u7406\u3068\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u3092\u5411\u4e0a\u3055\u305b\u308b\u305f\u3081\u306b\u884c\u3063\u305f\u4f5c\u696d\u306e\u7d50\u679c\u3092\u793a\u3057\u3001\u7279\u5b9a\u3055\u308c\u305f\u554f\u984c\u3068 Postgres 14 \u3067\u306e\u5bfe\u51e6\u65b9\u6cd5\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n<hr class=\"c-divider f-pad-vertical-3x\" \/>\n<ol class=\"c-list\" style=\"letter-spacing: .05em; line-height: 2em;\">\n<li><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#why-connection-scalability-in-postgres-is-important\" aria-label=\"\u306a\u305cPostgres\u306e\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u304c\u91cd\u8981\u306a\u306e\u304b: \n\u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u306a\u305cPostgres\u306e\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u304c\u91cd\u8981\u306a\u306e\u304b<\/a><\/li>\n<li><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#surveying-connection-scalability-issues\" aria-label=\"\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u554f\u984c\u3092\u8abf\u67fb\u3059\u308b:\u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u554f\u984c\u3092\u8abf\u67fb\u3059\u308b<\/a><\/li>\n<li><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#memory-usage\" aria-label=\"\u30e1\u30e2\u30ea\u306e\u4f7f\u7528\u91cf: \u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u30e1\u30e2\u30ea\u306e\u4f7f\u7528\u91cf<\/a><\/li>\n<li><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#constant-connection-overhead\" aria-label=\"\u5b9a\u5e38\u7684\u306a\u63a5\u7d9a\u306e\u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9: \u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u5b9a\u5e38\u7684\u306a\u63a5\u7d9a\u306e\u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9<\/a>\n<ol class=\"c-list\" style=\"letter-spacing: .05em; line-height: 2em;\">\n<li><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#conclusion-connection-memory-overhead-is-acceptable\" aria-label=\"\u7d50\u8ad6: \u63a5\u7d9a\u306b\u3088\u308b\u30e1\u30e2\u30ea\u306e\u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9\u306f\u8a31\u5bb9\u53ef\u80fd: \u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u7d50\u8ad6: \u63a5\u7d9a\u306b\u3088\u308b\u30e1\u30e2\u30ea\u306e\u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9\u306f\u8a31\u5bb9\u53ef\u80fd<\/a><\/li>\n<\/ol>\n<\/li>\n<li><a class=\"c-hyperlink\" href=\"14.%09\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u80a5\u5927\u5316\" aria-label=\"\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u80a5\u5927\u5316:\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u80a5\u5927\u5316\u306b\u3064\u3044\u3066\u306e\u8a73\u7d30\">\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u80a5\u5927\u5316<\/a>\n<ol class=\"c-list\" style=\"letter-spacing: .05em; line-height: 2em;\">\n<li><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#problem-illustration\" aria-label=\"\u554f\u984c\u306e\u56f3\u89e3:\u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u554f\u984c\u306e\u56f3\u89e3<\/a><\/li>\n<li><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#conclusion-cache-bloat-is-not-the-major-issue-at-this-moment\" aria-label=\"\u7d50\u8ad6: \u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u80a5\u5927\u5316\u306f\u73fe\u6642\u70b9\u3067\u306f\u5927\u304d\u306a\u554f\u984c\u3067\u306f\u306a\u3044:\u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u7d50\u8ad6: \u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u80a5\u5927\u5316\u306f\u73fe\u6642\u70b9\u3067\u306f\u5927\u304d\u306a\u554f\u984c\u3067\u306f\u306a\u3044<\/a><\/li>\n<\/ol>\n<\/li>\n<li><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#query-memory-usage\" aria-label=\"\u30af\u30a8\u30ea\u306e\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf: \u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u30af\u30a8\u30ea\u306e\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf<\/a><\/li>\n<li><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#snapshot-scalability\" aria-label=\"\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3:\u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3<\/a>\n<ol class=\"c-list\" style=\"letter-spacing: .05em; line-height: 2em;\">\n<li><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#cause\" aria-label=\"\u539f\u56e0: \u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u539f\u56e0<\/a><\/li>\n<li><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#conclusion-snapshot-scalability-is-a-significant-limit\" aria-label=\"\u7d50\u8ad6: \u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306f\u5927\u304d\u306a\u5236\u9650: \u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u7d50\u8ad6: \u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306f\u5927\u304d\u306a\u5236\u9650<\/a><\/li>\n<\/ol>\n<\/li>\n<li><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#connection-model--context-switches\" aria-label=\"\u63a5\u7d9a\u30e2\u30c7\u30eb\u3068\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u30b9\u30a4\u30c3\u30c1: \u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u63a5\u7d9a\u30e2\u30c7\u30eb\u3068\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u30b9\u30a4\u30c3\u30c1<\/a><\/li>\n<li><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#conclusion-start-by-improving-snapshot-scalability-in-postgres\" aria-label=\"\u7d50\u8ad6: Postgres\u306e\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u6539\u5584\u304b\u3089\u59cb\u3081\u308b: \u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u7d50\u8ad6: Postgres\u306e\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u6539\u5584\u304b\u3089\u59cb\u3081\u308b<\/a><\/li>\n<\/ol>\n<h3 class=\"c-heading-3\">\u306a\u305cPostgreSQL\u306e\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u304c\u91cd\u8981\u306a\u306e\u304b<\/h3>\n<div class=\"m-image\" style=\"margin-bottom:40px;\"><img decoding=\"async\" loading=\"lazy\" width=\"400\" height=\"210\" class=\"c-image alignnone wp-image-953\" src=\"https:\/\/azbase-azbase-dev2.azurewebsites.net\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/Stylized-chart-of-Postgres-Connection-Scalability-Impact-of-Idle-Connections-1200x630-1.png\" alt=\"\u30e9\u30f3\u30c0\u30e0\u306b\u914d\u7f6e\u3055\u308c\u305f6\u3064\u306e\u30ad\u30e5\u30fc\u30d6\u306f\u3001\u6c34\u8272\u306e\u6587\u5b57\u5217\u3067\u63a5\u7d9a\u3055\u308c\u3066\u3044\u307e\u3059\" srcset=\"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/Stylized-chart-of-Postgres-Connection-Scalability-Impact-of-Idle-Connections-1200x630-1.png 400w, https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/Stylized-chart-of-Postgres-Connection-Scalability-Impact-of-Idle-Connections-1200x630-1-300x158.png 300w\" sizes=\"(max-width: 400px) 100vw, 400px\" \/><\/div>\n<p>\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306b\u95a2\u3059\u308b\u554f\u984c\u306f\u3001Postgres \u306b\u6163\u308c\u3066\u3044\u306a\u3044\u3053\u3068\u3084\u3001\u58ca\u308c\u305f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3001\u307e\u305f\u306f\u540c\u3058\u6d41\u308c\u306e\u4e2d\u306b\u3042\u308b\u4ed6\u306e\u554f\u984c\u306b\u3088\u3063\u3066\u5f15\u304d\u8d77\u3053\u3055\u308c\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\u65e2\u306b\u8ff0\u3079\u305f\u3088\u3046\u306b\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u3088\u3063\u3066\u306f\u3001\u4f55\u306e\u554f\u984c\u306b\u3082\u906d\u9047\u3059\u308b\u3053\u3068\u306a\u304f\u3001\u6570\u5343\u306e\u63a5\u7d9a\u3092\u78ba\u7acb\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>Postgres \u306e\u5927\u91cf\u306e\u63a5\u7d9a\u306e\u51e6\u7406\u3092\u6539\u5584\u3059\u308b\u8981\u6c42\u306b\u5bfe\u3059\u308b\u3088\u304f\u3042\u308b\u53cd\u8ad6\u306f\u3001\u4f55\u3082\u5bfe\u51e6\u3057\u306a\u304f\u3066\u826f\u3044\u3001\u3068\u3044\u3046\u4e3b\u5f35\u3067\u3059\u3002\u5927\u91cf\u306e\u63a5\u7d9a\u3092\u51e6\u7406\u3059\u308b\u8981\u4ef6\/\u5fc5\u8981\u6027\u304c\u305d\u3082\u305d\u3082\u9593\u9055\u3063\u3066\u304a\u308a\u3001\u58ca\u308c\u305f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3084\u985e\u4f3c\u3057\u305f\u3082\u306e\u306b\u3088\u3063\u3066\u5f15\u304d\u8d77\u3053\u3055\u308c\u308b\u3068\u3044\u3046\u3082\u306e\u3067\u3059\u3002\u591a\u304f\u306e\u5834\u5408\u3001CPU \u30b3\u30a2\u306e\u6570\u304c\u9650\u3089\u308c\u3066\u3044\u308b\u30b5\u30fc\u30d0\u30fc\u3078\u306e\u53c2\u7167\u304c\u4f34\u3044\u307e\u3059\u3002<\/p>\n<p>\u5927\u91cf\u306e\u63a5\u7d9a\u3092\u907f\u3051\u308b\u306e\u304c\u6700\u5584\u306e\u65b9\u6cd5\u3067\u3042\u308b\u5834\u5408\u3082\u3042\u308a\u307e\u3059\u304c\u3001Postgres\u3067\u305d\u308c\u3089\u304c\u5fc5\u8981\u306a\u7406\u7531\u306f\u660e\u767d\u3060\u3068\u79c1\u306f\u8003\u3048\u3066\u3044\u307e\u3059\u3002\u4e3b\u306a\u3082\u306e\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059:<\/p>\n<ul class=\"c-list\" style=\"letter-spacing: .05em; line-height: 2em;\">\n<li><strong>\u96c6\u7d04\u3055\u308c\u305f\u72b6\u614b\u3068\u8ca0\u8377\u306e\u6025\u5897\u306f\u5927\u91cf\u306e\u63a5\u7d9a\u3092\u5fc5\u8981\u3068\u3059\u308b<\/strong>: \u4e00\u822c\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3068\u72b6\u614b\u3092\u5171\u6709\u3057\u307e\u3059\uff08\u975e\u6c38\u7d9a\u30ad\u30e3\u30c3\u30b7\u30e5 \u30b5\u30fc\u30d3\u30b9\u306f\u9664\u304d\u307e\u3059)\u3002\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u306e\u78ba\u7acb\u30b3\u30b9\u30c8 (TLS\u3001\u30ec\u30a4\u30c6\u30f3\u30b7\u30fc\u3001Postgres \u306e\u30b3\u30b9\u30c8\u3068\u3044\u3063\u305f\u9806) \u3092\u8003\u3048\u308b\u3068\u660e\u767d\u306a\u306e\u3067\u3059\u304c\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306f\u3001\u53d7\u4fe1\u8981\u6c42\u306b\u4f34\u3046\u5c0f\u3055\u306a\u30b9\u30d1\u30a4\u30af\u3092\u51e6\u7406\u3059\u308b\u306e\u306b\u5341\u5206\u306a\u5927\u304d\u3055\u306e Postgres \u63a5\u7d9a\u306e\u30d7\u30fc\u30eb\u3092\u7dad\u6301\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u591a\u304f\u306e\u5834\u5408\u30011 \u3064\u306b\u96c6\u7d04\u3055\u308c\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f7f\u7528\u3059\u308b\u3001\uff08\u30a6\u30a7\u30d6\uff09\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3 \u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3057\u3066\u3044\u308b\u591a\u6570\u306e\u30b5\u30fc\u30d0\u30fc\u304c\u3042\u308a\u307e\u3059\u3002<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\">\u3053\u306e\u554f\u984c\u306b\u306f\u3001<a class=\"c-hyperlink\" href=\"https:\/\/www.pgbouncer.org\/\" aria-label=\"PgBouncer: \u30af\u30ea\u30c3\u30af\u3057\u3066 PgBouncer \u306e\u30db\u30fc\u30e0\u30da\u30fc\u30b8\u306b\u79fb\u52d5\u3057\u307e\u3059\">PgBouncer<\/a> \u3084\u6700\u8fd1\u306e <a class=\"c-hyperlink\" href=\"https:\/\/github.com\/yandex\/odyssey\" aria-label=\"Odyssey \u306e github \u30da\u30fc\u30b8\u306b\u79fb\u52d5: \">Odyssey<\/a> \u306e\u3088\u3046\u306a Postgres \u63a5\u7d9a\u30d7\u30fc\u30eb\u3092\u4f7f\u7528\u3057\u3066\u5bfe\u51e6\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30b5\u30fc\u30d0\u30fc\u3078\u306e\u63a5\u7d9a\u6570\u3092\u5b9f\u969b\u306b\u6e1b\u3089\u3059\u306b\u306f\u3001\u3053\u306e\u3088\u3046\u306a\u30d7\u30fc\u30eb\u3092\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3 (\u307e\u305f\u306f\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8) <a class=\"c-hyperlink\" href=\"https:\/\/www.pgbouncer.org\/features.html\" aria-label=\"\u30d7\u30fc\u30ea\u30f3\u30b0 \u30e2\u30fc\u30c9: \u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001PgBouncer \u6a5f\u80fd\u30da\u30fc\u30b8\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3066\u304f\u3060\u3055\u3044\">\u30d7\u30fc\u30ea\u30f3\u30b0 \u30e2\u30fc\u30c9<\/a>\u3067\u4f7f\u7528\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u305f\u3060\u3057\u3001\u3053\u308c\u3092\u884c\u3046\u3068\u3001<a class=\"c-hyperlink\" href=\"https:\/\/github.com\/yandex\/odyssey\/issues\/16\" aria-label=\"\u6e96\u5099\u6e08\u307f\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8: odyssey \u306e github issue number 16 \u306b\u79fb\u52d5\u3057\u307e\u3059\">\u6e96\u5099\u6e08\u307f\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8<\/a>\u3001\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u2026\u306e\u3088\u3046\u306a\u591a\u304f\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4fbf\u5229\u306a\u6a5f\u80fd\u3092\u9664\u5916\u3059\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<ul class=\"c-list\" style=\"letter-spacing: .05em; line-height: 2em;\">\n<li><strong>\u30ec\u30a4\u30c6\u30f3\u30b7\u30fc\u3068\u7d50\u679c\u306e\u51e6\u7406\u6642\u9593\u306f\u30a2\u30a4\u30c9\u30eb\u63a5\u7d9a\u3092\u751f\u307f\u51fa\u3057\u307e\u3059<\/strong>: \u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u306e\u30ec\u30a4\u30c6\u30f3\u30b7\u30fc\u3068\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u51e6\u7406\u6642\u9593\u306f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u53ef\u80fd\u306a\u9650\u308a\u9ad8\u901f\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8981\u6c42\u3092\u767a\u884c\u3057\u3066\u3044\u308b\u5834\u5408\u3067\u3082\u3001\u307b\u3068\u3093\u3069\u306e\u5834\u5408\u3001\u500b\u3005\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u304c\u30a2\u30a4\u30c9\u30eb\u72b6\u614b\u306b\u306a\u308a\u307e\u3059\u3002<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\">\u4e00\u822c\u7684\u306a OLTP \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u3001\u7279\u306b\u30a6\u30a7\u30d6\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306f\u3001\u8aad\u307f\u53d6\u308a\u306b\u5927\u304d\u304f\u504f\u3063\u3066\u3044\u307e\u3059\u3002\u307e\u305f\u3001OLTP \u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u3067\u306f\u3001SQL \u30af\u30a8\u30ea\u306e\u5927\u534a\u306f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3068\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u9593\u306e\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u30ec\u30a4\u30c6\u30f3\u30b7\u30fc\u3092\u5341\u5206\u306b\u4e0b\u56de\u308b\u6642\u9593\u3067\u51e6\u7406\u304c\u53ef\u80fd\u306a\u3050\u3089\u3044\u5358\u7d14\u3067\u3059\u3002<\/p>\n<p style=\"padding-left: 40px;\">\u3055\u3089\u306b\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306f\u3001\u9001\u4fe1\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30af\u30a8\u30ea\u306e\u7d50\u679c\u3092\u51e6\u7406\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u591a\u304f\u306e\u5834\u5408\u3001\u76f8\u5f53\u306a\u4f5c\u696d(\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u51e6\u7406\u3001\u30ad\u30e3\u30c3\u30b7\u30e5\u30b5\u30fc\u30d0\u30fc\u3068\u306e\u901a\u4fe1\u306a\u3069)\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n<p style=\"padding-left: 40px;\">\u3053\u306e\u3053\u3068\u3092\u7406\u89e3\u3059\u308b\u305f\u3081\u306b\u3001\u3053\u3053\u3067\u306f <a class=\"c-hyperlink\" href=\"https:\/\/www.postgresql.org\/docs\/13\/pgbench.htm\" aria-label=\"Pgbench \u306e\u8a73\u7d30\">pgbench<\/a>\uff08Postgres \u306e\u4e00\u90e8\u3067\u3042\u308b\u7c21\u5358\u306a\u30d9\u30f3\u30c1\u30de\u30fc\u30af\u30d7\u30ed\u30b0\u30e9\u30e0)\u3092\u4f7f\u7528\u3057\u305f\u7c21\u5358\u306a\u5b9f\u9a13\u3092\u3057\u307e\u3059\u3002\u30e1\u30e2\u30ea\u5e38\u99d0\u578b\u306e\u8aad\u307f\u53d6\u308a\u5c02\u7528\u306e pgbench \u30ef\u30fc\u30af\u30ed\u30fc\u30c9 (\u79c1\u306e\u30ef\u30fc\u30af\u30b9\u30c6\u30fc\u30b7\u30e7\u30f3<a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#fn:1\" aria-label=\"1: \u30d6\u30ed\u30b0\u300cPostgres\u306b\u304a\u3051\u308b\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u9650\u754c\u306e\u5206\u6790\u300d\u306e\u811a\u6ce81\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002\"><sup>1<\/sup><\/a>\u300120\/40 CPU \u30b3\u30a2\/\u30b9\u30ec\u30c3\u30c9\u3067\u5b9f\u884c) \u3067\u306f\u3001\u9045\u5ef6\u7121\u3057\u306e pgbench \u3068\u30b7\u30df\u30e5\u30ec\u30fc\u30c8\u3055\u308c\u305f\u9045\u5ef6\u3092\u4f34\u3046 pgbench \u306e\u9593\u3067\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u6570\u304c\u5897\u52a0\u3057\u3066\u3044\u304f\u969b\u306e\u30b9\u30eb\u30fc\u30d7\u30c3\u30c8\u3092\u6bd4\u8f03\u3057\u3066\u3044\u307e\u3059\u3002\u30b7\u30df\u30e5\u30ec\u30fc\u30b7\u30e7\u30f3\u3068\u3057\u3066\u30011ms\u306e\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u9045\u5ef6\u30681ms\u306e\u51e6\u7406\u9045\u5ef6\u3092\u4f7f\u7528\u3057\u307e\u3057\u305f\u3002\u9045\u5ef6\u7121\u3057\u306e pgbench \u3067\u306f\u7d0448\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u304c\u30d4\u30fc\u30af\u3068\u306a\u308a\u3001\u9045\u5ef6\u3092\u4f34\u3046 pgbench \u3067\u306f\u7d043000\u63a5\u7d9a\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002\u30db\u30b9\u30c8\u4e0a\u306e TCP \u63a5\u7d9a\u3068\u7269\u7406\u7684\u306b\u8fd1\u30442\u53f0\u306e\u30db\u30b9\u30c8\u9593\u306e10GBe \u3068\u306e\u6bd4\u8f03\u3067\u3082\u3001\u30d4\u30fc\u30af\u306f\u7d04 48 \u63a5\u7d9a\u304b\u3089 500 \u63a5\u7d9a\u306b\u8fd1\u3065\u304d\u307e\u3059\u3002<\/p>\n<ul class=\"c-list\" style=\"letter-spacing: .05em; line-height: 2em;\">\n<li><strong>\u3088\u308a\u591a\u304f\u306e\u63a5\u7d9a\u3092\u8a31\u53ef\u3059\u308b\u3088\u3046\u306b\u30b9\u30b1\u30fc\u30eb\u30a2\u30a6\u30c8\u3059\u308b\u3068\u30b3\u30b9\u30c8\u304c\u5897\u52a0\u3059\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b<\/strong>: \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u3092\u591a\u6570\u306e Postgres \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306b\u5206\u6563\u3067\u304d\u308b\u5834\u5408\u3067\u3082\u3001\u5f85\u6a5f\u6642\u9593\u3068\u63a5\u7d9a\u5236\u9650\u306e\u5f71\u97ff\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30b5\u30fc\u30d0\u30fc\u306e\u4f7f\u7528\u7387\u304c\u4f4e\u304f\u306a\u308b\u5834\u5408\u304c\u591a\u304f\u3001\u5fc5\u8981\u306a\u63a5\u7d9a\u6570\u3092\u51e6\u7406\u3059\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30b5\u30fc\u30d0\u30fc\u306e\u6570\u3092\u5897\u3084\u3059\u7406\u7531\u306b\u306a\u308a\u5f97\u307e\u3059\u3002\u3053\u308c\u306f\u3001\u904b\u7528\u30b3\u30b9\u30c8\u3092\u5927\u5e45\u306b\u5897\u52a0\u3055\u305b\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/li>\n<\/ul>\n<h3 class=\"c-heading-3\">\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u554f\u984c\u3092\u8abf\u67fb\u3059\u308b<\/h3>\n<p>\u3053\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u59cb\u3081\u308b\u79c1\u306e\u76ee\u6a19\u306f\u3001Postgres\u304c\u5927\u91cf\u306e\u63a5\u7d9a\u3092\u51e6\u7406\u3059\u308b\u80fd\u529b\u3092\u5411\u4e0a\u3055\u305b\u308b\u3053\u3068\u3067\u3057\u305f\u3002\u305d\u306e\u305f\u3081\u306b\u306f\u3001\u3064\u307e\u308a\u89e3\u6c7a\u3059\u3079\u304d\u554f\u984c\u3092\u9078\u3076\u306b\u306f\u3001\u307e\u305a\u3069\u306e\u554f\u984c\u304c\u6700\u3082\u91cd\u8981\u306a\u306e\u304b\u3092\u7406\u89e3\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3057\u305f\u3002\u305d\u3046\u3067\u306f\u306a\u304f\u3001\u5b9f\u969b\u306e\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u3092\u6539\u5584\u305b\u305a\u306b\u3001\u90e8\u5206\u7684\u306a\u6700\u9069\u5316\u3067\u7d42\u308f\u308b\u306e\u306f\u7c21\u5358\u306a\u3053\u3068\u3067\u3057\u305f\u304c\u3002<\/p>\n<p>\u305d\u3053\u3067\u3001\u79c1\u306e\u6700\u521d\u306e\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u30a8\u30f3\u30b8\u30cb\u30a2\u30ea\u30f3\u30b0\u30bf\u30b9\u30af\u306f\u3001Postgres\u306e\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u5236\u9650\u306e\u3055\u307e\u3056\u307e\u306a\u5074\u9762\u3092\u8abf\u67fb\u3059\u308b\u3053\u3068\u3067\u3057\u305f\uff1a<\/p>\n<ol class=\"c-list\" style=\"letter-spacing: .05em; line-height: 2em;\">\n<li><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#memory-usage\" aria-label=\"\u30e1\u30e2\u30ea\u306e\u4f7f\u7528\u91cf: \u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u30e1\u30e2\u30ea\u306e\u4f7f\u7528\u91cf<\/a><\/li>\n<li><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#snapshot-scalability\" aria-label=\"\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3: \u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3<\/a><\/li>\n<li><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#connection-model--context-switches\" aria-label=\"\u63a5\u7d9a\u30e2\u30c7\u30eb: \u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u63a5\u7d9a\u30e2\u30c7\u30eb<\/a><\/li>\n<\/ol>\n<p>Postgres \u306e\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u5236\u9650\u306b\u3064\u3044\u3066\u306e\u8a73\u7d30\u306a\u8abf\u67fb\u306e\u5b8c\u4e86\u307e\u3067\u306b\u3001\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u3092\u6700\u521d\u306b\u89e3\u6c7a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3068<a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#conclusion-start-by-improving-snapshot-scalability-in-postgres\" aria-label=\"\u7d50\u8ad6\u4ed8\u3051\u305f: \u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u7d50\u8ad6\u4ed8\u3051\u305f<\/a>\u7406\u7531\u3092\u7406\u89e3\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<h3 class=\"c-heading-3\">\u30e1\u30e2\u30ea\u306e\u4f7f\u7528\u91cf<\/h3>\n<p>\u5927\u91cf\u306e\u63a5\u7d9a\u306b\u3088\u308b\u30e1\u30e2\u30ea\u306e\u4f7f\u7528\u91cf\u306b\u95a2\u3059\u308b\u554f\u984c\u306b\u306f\u3001\u4e3b\u306b3\u3064\u306e\u5074\u9762\u304c\u3042\u308a\u307e\u3059\uff1a<\/p>\n<ul class=\"c-list\" style=\"letter-spacing: .05em; line-height: 2em;\">\n<li><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#constant-connection-overhead\" aria-label=\"\u5b9a\u5e38\u7684\u306a\u63a5\u7d9a\u306e\u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9: \u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u5b9a\u5e38\u7684\u306a\u63a5\u7d9a\u306e\u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9<\/a>\u3001\u78ba\u7acb\u3057\u305f\u63a5\u7d9a\u304c\u4f7f\u3063\u3066\u3044\u308b\u30e1\u30e2\u30ea\u306e\u7dcf\u91cf<\/li>\n<li><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#cache-bloat\" aria-label=\"\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u80a5\u5927\u5316: \u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u80a5\u5927\u5316<\/a>\u3001\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u3088\u308b\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u5897\u5927<\/li>\n<li><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#query-memory-usage\" aria-label=\"\u30af\u30a8\u30ea\u306e\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf: \u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u30af\u30a8\u30ea\u306e\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf<\/a>\u3001\u30af\u30a8\u30ea\u5b9f\u884c\u305d\u306e\u3082\u306e\u306b\u3088\u3063\u3066\u4f7f\u308f\u308c\u308b\u30e1\u30e2\u30ea<\/li>\n<\/ul>\n<h3 class=\"c-heading-3\">\u5b9a\u5e38\u7684\u306a\u63a5\u7d9a\u306e\u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9<\/h3>\n<p>Postgres\u306f\u3001\u591a\u304f\u306e\u4eba\u304c\u77e5\u3063\u3066\u3044\u308b\u3088\u3046\u306b\u3001\u30d7\u30ed\u30bb\u30b9\u30d9\u30fc\u30b9\u306e\u63a5\u7d9a\u30e2\u30c7\u30eb\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002\u65b0\u3057\u3044\u63a5\u7d9a\u304c\u78ba\u7acb\u3055\u308c\u308b\u3068\u3001Postgres \u306e\u30b9\u30fc\u30d1\u30fc\u30d0\u30a4\u30b6 \u30d7\u30ed\u30bb\u30b9\u306f\u3001\u305d\u306e\u63a5\u7d9a\u3092\u51e6\u7406\u3059\u308b\u305f\u3081\u306e\u5c02\u7528\u30d7\u30ed\u30bb\u30b9\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u30b9\u30ec\u30c3\u30c9\u306e\u4f7f\u7528\u306b\u5bfe\u3059\u308b\u300c\u672c\u683c\u7684\u306a\u30d7\u30ed\u30bb\u30b9\u300d\u306e\u4f7f\u7528\u306b\u306f\u3001\u5206\u96e2\/\u5805\u7262\u6027\u306e\u5411\u4e0a\u306a\u3069\u306e\u5229\u70b9\u304c\u3042\u308a\u307e\u3059\u304c\u3001\u3044\u304f\u3064\u304b\u306e\u6b20\u70b9\u3082\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u3088\u304f\u3042\u308b\u4e0d\u6e80\u306e 1 \u3064\u306f\u3001\u5404\u63a5\u7d9a\u304c\u30e1\u30e2\u30ea\u3092\u4f7f\u7528\u3057\u3059\u304e\u308b\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u3002\u3059\u306a\u308f\u3061\u3001\u8ffd\u52a0\u306e\u63a5\u7d9a\u306b\u3088\u308b\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u5897\u52a0\u3092\u6e2c\u5b9a\u3059\u308b\u3053\u3068\u306f\u9a5a\u304f\u307b\u3069\u56f0\u96e3\u3067\u3042\u308b\u305f\u3081\u3001\u5c11\u306a\u304f\u3068\u3082\u90e8\u5206\u7684\u306b\u306f\u3001\u4e00\u822c\u7684\u306a\u89b3\u5bdf\u3057\u304b\u3067\u304d\u306a\u3044\u3001\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u3002<\/p>\n<p><a class=\"c-hyperlink\" href=\"https:\/\/blog.anarazel.de\/2020\/10\/07\/measuring-the-memory-overhead-of-a-postgres-connection\/\" aria-label=\"Postgres \u63a5\u7d9a\u306e\u30e1\u30e2\u30ea \u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9\u306e: \u30d6\u30ed\u30b0\u8a18\u4e8b\u5168\u6587\u3092\u8aad\u3080\u306b\u306f\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">Postgres \u63a5\u7d9a\u306e\u30e1\u30e2\u30ea \u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9\u306e<\/a>\u6e2c\u5b9a\u306b\u95a2\u3059\u308b\u6700\u8fd1\u306e\u8a18\u4e8b\u3067\u306f\u3001\u30e1\u30e2\u30ea\u306e\u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9\u3092\u6b63\u78ba\u306b\u6e2c\u5b9a\u3059\u308b\u306e\u306f\u9a5a\u304f\u307b\u3069\u96e3\u3057\u3044\u3053\u3068\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002\u307e\u305f\u3001\u591a\u304f\u306e\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u306b\u304a\u3044\u3066\u3001\u304b\u3064\u9069\u5207\u306a\u69cb\u6210\u3092\u4f7f\u7528\u3057\u3066\u3082 &#8211; \u6700\u3082\u91cd\u8981\u306a\u3053\u3068\u306b <a class=\"c-hyperlink\" href=\"https:\/\/www.postgresql.org\/docs\/current\/runtime-config-resource.html#GUC-SHARED-BUFFERS\" aria-label=\"huge_pages: \u5de8\u5927\u30da\u30fc\u30b8\u306e\u30b5\u30a4\u30ba\u306e\u5236\u5fa1\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002\">huge_pages<\/a> \u3092\u4f7f\u7528\u3057\u3066\u3082 &#8211; \u63a5\u7d9a\u6bce\u306e\u30e1\u30e2\u30ea \u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9\u306f <a class=\"c-hyperlink\" href=\"https:\/\/blog.anarazel.de\/2020\/10\/07\/measuring-the-memory-overhead-of-a-postgres-connection#conclusion%22\" aria-label=\"2 MiB: Postgres\u63a5\u7d9a\u306e\u30e1\u30e2\u30ea\u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9\u306e\u6e2c\u5b9a\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">2 MiB<\/a><u>\u672a\u6e80<\/u>\u306b\u904e\u304e\u306a\u3044\u3053\u3068\u3067\u3059\u3002<\/p>\n<p style=\"c-heading-4\">\u7d50\u8ad6: \u63a5\u7d9a\u306b\u3088\u308b\u30e1\u30e2\u30ea\u306e\u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9\u306f\u8a31\u5bb9\u53ef\u80fd<\/p>\n<p>\u5404\u63a5\u7d9a\u306b\u6570 MiB \u306e\u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9\u3057\u304b\u306a\u3044\u5834\u5408\u3001\u78ba\u7acb\u3055\u308c\u305f\u63a5\u7d9a\u304c\u6570\u5343\u306b\u53ca\u3076\u53ef\u80fd\u6027\u306f\u5341\u5206\u306b\u3042\u308a\u307e\u3059\u3002\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u3092\u6e1b\u3089\u3059\u306e\u306f\u660e\u3089\u304b\u306b\u826f\u3044\u3053\u3068\u3067\u3059\u304c\u3001\u30e1\u30e2\u30ea\u306f\u63a5\u7d9a\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306b\u95a2\u3059\u308b\u4e3b\u8981\u306a\u554f\u984c\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n<h3 class=\"c-heading-3\">\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u80a5\u5927\u5316<\/h3>\n<p>\u30e1\u30e2\u30ea\u306b\u95a2\u9023\u3059\u308b\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u554f\u984c\u306e\u3082\u3046 1 \u3064\u306e\u91cd\u8981\u306a\u5074\u9762\u306f\u3001\u6642\u9593\u306e\u7d4c\u904e\u3068\u3068\u3082\u306b\u3001\u9577\u671f\u9593\u5b58\u5728\u3059\u308b\u30ea\u30bd\u30fc\u30b9\u304c\u539f\u56e0\u3067\u63a5\u7d9a\u306e\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u304c\u5897\u52a0\u3059\u308b\u3053\u3068\u3067\u3059\u3002\u3053\u308c\u306f\u3001\u30b9\u30ad\u30fc\u30de \u30d9\u30fc\u30b9\u306e\u30de\u30eb\u30c1\u30c6\u30ca\u30f3\u30c8\u6a5f\u80fd\u3068\u7d44\u307f\u5408\u308f\u305b\u305f\u9577\u6642\u9593\u306e\u63a5\u7d9a\u3092\u4f7f\u7528\u3059\u308b\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u3067\u7279\u306b\u554f\u984c\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u4f55\u3089\u304b\u306e\u5f62\u306e\u63a5\u7d9a &lt;-&gt; \u30c6\u30ca\u30f3\u30c8\u9023\u643a\u3092\u5b9f\u88c5\u3057\u306a\u3044\u9650\u308a\u3001\u6642\u9593\u306e\u7d4c\u904e\u3068\u5171\u306b\u3001\u5404\u63a5\u7d9a\u306f\u3001\u3059\u3079\u3066\u306e\u30c6\u30ca\u30f3\u30c8\u306e\u3059\u3079\u3066\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306b\u30a2\u30af\u30bb\u30b9\u3057\u307e\u3059\u3002\u3053\u308c\u306f\u3001\u73fe\u5728\uff08\u30d0\u30fc\u30b8\u30e7\u30f313\u306e\u6642\u70b9\u3067\uff09\u3001Postgres\u304c\u3081\u3063\u305f\u306b\u30a2\u30af\u30bb\u30b9\u3055\u308c\u306a\u3044\u30b3\u30f3\u30c6\u30f3\u30c4\u306e\u30e1\u30bf\u30c7\u30fc\u30bf\u30ad\u30e3\u30c3\u30b7\u30e5\u3092\u53d6\u308a\u9664\u304b\u306a\u3044\u305f\u3081\u3001Postgres\u306e\u5185\u90e8\u30ab\u30bf\u30ed\u30b0\u30e1\u30bf\u30c7\u30fc\u30bf\u30ad\u30e3\u30c3\u30b7\u30e5\u304c\u59a5\u5f53\u306a\u30b5\u30a4\u30ba\u3092\u8d85\u3048\u3066\u5927\u304d\u304f\u306a\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p style=\"c-heading-4\">\u554f\u984c\u306e\u56f3\u89e3<\/p>\n<p>\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u80a5\u5927\u5316\u306e\u554f\u984c\u3092\u793a\u3059\u305f\u3081\u306b\u3001\u79c1\u306f\u3044\u304f\u3064\u304b\u306e\u5217\u3068\u5358\u4e00\u306e\u30d7\u30e9\u30a4\u30de\u30ea\u30b7\u30ea\u30a2\u30eb\u5217\u30a4\u30f3\u30c7\u30c3\u30af\u30b9<a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#fn:2\" aria-label=\"2: \u30d6\u30ed\u30b0\u300cPostgres\u306b\u304a\u3051\u308b\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u9650\u754c\u306e\u5206\u6790\u300d\u306e\u811a\u6ce82\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002\"><sup>2<\/sup><\/a>\u3092\u6301\u3064100k\u30c6\u30fc\u30d6\u30eb\u3092\u5099\u3048\u305f\u30b7\u30f3\u30d7\u30eb\u306a\u30c6\u30b9\u30c8\u30d9\u30c3\u30c9\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002\u4f5c\u6210\u306b\u306f\u3061\u3087\u3063\u3068\u6642\u9593\u304c\u304b\u304b\u308a\u307e\u3059\u3002<\/p>\n<p><a class=\"c-hyperlink\" href=\"https:\/\/git.postgresql.org\/gitweb\/?p=postgresql.git;a=commit;h=3e98c0bafb28de87ae095b341687dc082371af54\" aria-label=\"\u6700\u8fd1\u8ffd\u52a0: postgresql\u306egit\u30b3\u30df\u30c3\u30c8\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\">\u6700\u8fd1\u8ffd\u52a0<\/a>\u3055\u308c\u305fpg_backend_memory_contexts\u30d3\u30e5\u30fc\u3067\u306f\u3001\u3055\u307e\u3056\u307e\u306a\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u96c6\u8a08\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u3092\u898b\u308b\u3053\u3068\u306f\u305d\u308c\u307b\u3069\u96e3\u3057\u304f\u306f\u3042\u308a\u307e\u305b\u3093(\u305f\u3060\u3057\u3001\u3055\u307e\u3056\u307e\u306a\u7a2e\u985e\u306e\u30ad\u30e3\u30c3\u30b7\u30e5\u304c\u72ec\u81ea\u306e\u30e1\u30e2\u30ea\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u306b\u5206\u5272\u3055\u308c\u3066\u3044\u308b\u306e\u3092\u898b\u308b\u3053\u3068\u3092\u304a\u52e7\u3081\u3057\u307e\u3059)\u3002<a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#fn:3\" aria-label=\"3: \u30d6\u30ed\u30b0\u300cPostgres\u306b\u304a\u3051\u308b\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u9650\u754c\u306e\u5206\u6790\u300d\u306e\u811a\u6ce83\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002\"><sup>3<\/sup><\/a>\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u65b0\u898f\u306e Postgres \u306e\u63a5\u7d9a\u3067\u306f\u3001\u30e1\u30e2\u30ea\u306f\u3042\u307e\u308a\u4f7f\u308f\u308c\u307e\u305b\u3093:<\/p>\n<div class=\"m-table\" data-grid=\"container\">\n<div class=\"c-table\">\n<table data-f-sort=\"true\" summary=\"\u65b0\u3057\u3044Postgres\u63a5\u7d9a\u306e\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u3092\u793a\u3059\u30c6\u30fc\u30d6\u30eb\">\n<caption style=\"text-align: left; font-weight: bold;\">\u65b0\u3057\u3044Postgres\u63a5\u7d9a\u306f\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u3092\u4f7f\u7528\u3057\u307e\u3059<\/caption>\n<thead>\n<tr>\n<td><strong>name<\/strong><\/td>\n<td><strong>parent<\/strong><\/td>\n<td><strong>size_bytes<\/strong><\/td>\n<td><strong>size_human<\/strong><\/td>\n<td><strong>num_contexts<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>CacheMemoryContext<\/td>\n<td>TopMemoryContext<\/td>\n<td>524288<\/td>\n<td>512 kB<\/td>\n<td>1<\/td>\n<\/tr>\n<tr>\n<td>index info<\/td>\n<td>CacheMemoryContext<\/td>\n<td>149504<\/td>\n<td>146 kB<\/td>\n<td>80<\/td>\n<\/tr>\n<tr>\n<td>relation rules<\/td>\n<td>CacheMemoryContext<\/td>\n<td>8192<\/td>\n<td>8192 bytes<\/td>\n<td>1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>\u3057\u304b\u3057\u4f5c\u6210\u3057\u305f\u3070\u304b\u308a\u306e\u5168\u3066\u306e Postgres \u306e\u30c6\u30fc\u30d6\u30eb\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3068<a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#fn:4\" aria-label=\"4: \u30d6\u30ed\u30b0\u300cPostgres\u306b\u304a\u3051\u308b\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u9650\u754c\u306e\u5206\u6790\u300d\u306e\u811a\u6ce84\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002\"><sup>4<\/sup><\/a>\u3001\u5168\u304f\u9055\u3063\u305f\u69d8\u76f8\u3092\u898b\u305b\u307e\u3059:<\/p>\n<div class=\"m-table\" data-grid=\"container\">\n<div class=\"c-table\">\n<table summary=\"\u3059\u3079\u3066\u306ePostgres\u30c6\u30fc\u30d6\u30eb\u306b\u30a2\u30af\u30bb\u30b9\u3057\u305f\u5f8c\u306e\u63a5\u7d9a\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u3092\u793a\u3059\u30c6\u30fc\u30d6\u30eb\">\n<caption style=\"text-align: left; font-weight: bold;\">\u3059\u3079\u3066\u306ePostgres\u30c6\u30fc\u30d6\u30eb\u306b\u30a2\u30af\u30bb\u30b9\u3057\u305f\u5f8c\u306e\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf<\/caption>\n<thead>\n<tr>\n<td><strong>name<\/strong><\/td>\n<td><strong>parent<\/strong><\/td>\n<td><strong>size_bytes<\/strong><\/td>\n<td><strong>size_human<\/strong><\/td>\n<td><strong>num_contexts<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>CacheMemoryContext<\/td>\n<td>TopMemoryContext<\/td>\n<td>621805848<\/td>\n<td>593 MB<\/td>\n<td>1<\/td>\n<\/tr>\n<tr>\n<td>index info<\/td>\n<td>CacheMemoryContext<\/td>\n<td>102560768<\/td>\n<td>98 MB<\/td>\n<td>100084<\/td>\n<\/tr>\n<tr>\n<td>relation rules<\/td>\n<td>CacheMemoryContext<\/td>\n<td>8192<\/td>\n<td>8192 bytes<\/td>\n<td>1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u30e1\u30bf\u30c7\u30fc\u30bf \u30ad\u30e3\u30c3\u30b7\u30e5\u306f\u72ec\u81ea\u306e\u30e1\u30e2\u30ea \u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u3067\u4f5c\u6210\u3055\u308c\u3001&#8221;\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u60c5\u5831&#8221; \u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u306enum_contexts\u306f\u3001100k \u30c6\u30fc\u30d6\u30eb (\u304a\u3088\u3073\u4e00\u90e8\u306e\u30b7\u30b9\u30c6\u30e0\u5185\u90e8\u30c6\u30fc\u30d6\u30eb) \u306b\u30a2\u30af\u30bb\u30b9\u3057\u305f\u3053\u3068\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p style=\"c-heading-4\">\u7d50\u8ad6: \u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u80a5\u5927\u5316\u306f\u73fe\u6642\u70b9\u3067\u306f\u5927\u304d\u306a\u554f\u984c\u3067\u306f\u306a\u3044<\/p>\n<p>\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u80a5\u5927\u5316\u306e\u554f\u984c\u306e\u4e00\u822c\u7684\u306a\u89e3\u6c7a\u7b56\u306f\u3001\u4e00\u5b9a\u306e\u6642\u9593\u304c\u7d4c\u904e\u3057\u305f\u5f8c\u306b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u63a5\u7d9a\u30d7\u30fc\u30eb\u304b\u3089\u300c\u53e4\u3044\u300d\u63a5\u7d9a\u3092\u524a\u9664\u3059\u308b\u3053\u3068\u3067\u3059\u3002\u591a\u304f\u306e\u63a5\u7d9a\u30d7\u30fc\u30eb\u30e9\u30a4\u30d6\u30e9\u30ea\/Web\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af\u306f\u305d\u306e\u6a5f\u80fd\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u5b9f\u884c\u53ef\u80fd\u306a\u56de\u907f\u7b56\u304c\u3042\u308a\u3001\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u80a5\u5927\u5316\u306f<em>\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304c\u591a\u3044<\/em>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u554f\u984c\u306b\u904e\u304e\u306a\u3044\u305f\u3081\u3001\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u80a5\u5927\u5316\u306f\u73fe\u6642\u70b9\u3067\u306f<strong>\u5927\u304d\u306a\u554f\u984c\u3067\u306f\u3042\u308a\u307e\u305b\u3093<\/strong>(\u305f\u3060\u3057\u3001\u660e\u3089\u304b\u306b\u6539\u5584\u306b\u5024\u3057\u307e\u3059)\u3002<\/p>\n<h3 class=\"c-heading-3\">\u30af\u30a8\u30ea\u306e\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf<\/h3>\n<p>3 \u3064\u76ee\u306e\u5074\u9762\u306f\u3001\u30af\u30a8\u30ea\u3067\u4f7f\u7528\u3055\u308c\u308b\u30e1\u30e2\u30ea\u3092\u5236\u9650\u3059\u308b\u306e\u304c\u96e3\u3057\u3044\u70b9\u3067\u3059\u3002<a class=\"c-hyperlink\" href=\"https:\/\/www.postgresql.org\/docs\/current\/runtime-config-resource.html#GUC-WORK-MEM\" aria-label=\"work_mem: \u4f7f\u7528\u3059\u308b\u30e1\u30e2\u30ea\u306e\u57fa\u672c\u6700\u5927\u5bb9\u91cf\u306e\u8a2d\u5b9a\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002\">work_mem<\/a>\u8a2d\u5b9a\u3067\u306f\u3001\u30af\u30a8\u30ea\u5168\u4f53\u3067\u4f7f\u7528\u3055\u308c\u308b\u30e1\u30e2\u30ea\u306f\u5236\u5fa1\u3055\u308c\u307e\u305b\u3093\u304c\u3001\u30af\u30a8\u30ea\u306e\u500b\u3005\u306e\u90e8\u5206 (\u30bd\u30fc\u30c8\u3001\u30cf\u30c3\u30b7\u30e5\u96c6\u8a08\u3001\u30cf\u30c3\u30b7\u30e5\u7d50\u5408\u306a\u3069) \u306e\u307f\u3092\u5236\u5fa1\u3057\u307e\u3059\u3002\u3064\u307e\u308a\u3001\u30af\u30a8\u30ea\u304c\u4f55\u5ea6\u304b work_mem \u306b\u9054\u3059\u308b\u30e1\u30e2\u30ea\u3092\u8981\u6c42\u3057\u3066\u7d42\u308f\u308b\u3053\u3068\u304c\u3042\u308b\u3001\u3053\u3068\u3092\u793a\u3057\u3066\u3044\u307e\u3059<a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#fn:5\" aria-label=\"5: \u30d6\u30ed\u30b0\u300cPostgres\u306b\u304a\u3051\u308b\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u9650\u754c\u306e\u5206\u6790\u300d\u306e\u811a\u6ce85\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002\"><sup>5<\/sup><\/a>\u3002<\/p>\n<p>\u3064\u307e\u308a\u3001\u591a\u304f\u306e\u63a5\u7d9a\u3092\u5fc5\u8981\u3068\u3059\u308b\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u306e work_mem \u306f\u614e\u91cd\u306b\u8a2d\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u5206\u6790\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u306b\u5b9f\u8cea\u7684\u306b\u5fc5\u8981\u306a\u5927\u304d\u3044 work_mem \u8a2d\u5b9a\u3067\u306f\u3001\u81a8\u5927\u306a\u6570\u306e\u540c\u6642\u63a5\u7d9a\u3092\u5408\u7406\u7684\u306b\u4f7f\u7528\u3059\u308b\u3053\u3068\u306f\u4e0d\u53ef\u80fd\u3067\u3001\u30e1\u30e2\u30ea\u67af\u6e07\u306b\u95a2\u9023\u3059\u308b\u554f\u984c(\u30a8\u30e9\u30fc\u3084 OOM \u30ad\u30e9\u30fc\u306a\u3069)\u306b\u306f\u6c7a\u3057\u3066\u5f53\u305f\u3089\u306a\u3044\u3068\u3044\u3046\u671f\u5f85\u304c\u751f\u3058\u307e\u3059\u3002<\/p>\n<p>\u3055\u3044\u308f\u3044\u3001\u591a\u304f\u306e\u63a5\u7d9a\u3092\u5fc5\u8981\u3068\u3059\u308b\u307b\u3068\u3093\u3069\u306e\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u306f\u3001\u9ad8\u3044work_mem\u8a2d\u5b9a\u3092\u5fc5\u8981\u3068\u305b\u305a\u3001\u30e6\u30fc\u30b6\u30fc\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3001\u63a5\u7d9a\u3001\u304a\u3088\u3073\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u30ec\u30d9\u30eb\u3067\u8a2d\u5b9a\u3067\u304d\u307e\u3059\u3002<\/p>\n<h3 class=\"c-heading-3\">\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3<\/h3>\n<p>\u5927\u304d\u306a\u5024\u304c\u554f\u984c\u3092\u5f15\u304d\u8d77\u3053\u3059\u53ef\u80fd\u6027\u304c\u3042\u308b\u306e\u3067\u3001Postgres\u306e <a class=\"c-hyperlink\" href=\"https:\/\/www.postgresql.org\/docs\/current\/runtime-config-connection.html#GUC-MAX-CONNECTIONS\" aria-label=\"max_connections: \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30fb\u30b5\u30fc\u30d0\u3078\u306e\u540c\u6642\u63a5\u7d9a\u306e\u6700\u5927\u6570\u306e\u6c7a\u5b9a\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002\">max_connections<\/a> \u3092\u5927\u304d\u306a\u5024\u306b\u8a2d\u5b9a\u3057\u306a\u3044\u3053\u3068\u3092\u5f37\u304f\u63a8\u5968\u3059\u308b\u63a8\u5968\u4e8b\u9805\u304c\u305f\u304f\u3055\u3093\u3042\u308a\u307e\u3059\u3002\u5b9f\u969b\u3001\u79c1\u306f\u4f55\u5ea6\u3082\u81ea\u5206\u81ea\u8eab\u3067\u4e3b\u5f35\u3057\u3066\u304d\u307e\u3057\u305f\u3002<\/p>\n<p>\u3057\u304b\u3057\u3001\u305d\u308c\u306f\u771f\u5b9f\u306e\u534a\u5206\u306b\u904e\u304e\u307e\u305b\u3093\u3002<\/p>\n<p>max_connections\u3092\u975e\u5e38\u306b\u5927\u304d\u306a\u5024\u306b\u8a2d\u5b9a\u3059\u308b\u3060\u3051\u3067\u3001\u6700\u826f\u306e\u5834\u5408 (\u6700\u60aa\uff1f)\u3067\u3001\u305d\u308c\u81ea\u4f53\u304c\u975e\u5e38\u306b\u5c0f\u3055\u306a\u6027\u80fd\u52a3\u5316\u306b\u3064\u306a\u304c\u308a\u3001\u30e1\u30e2\u30ea\u3092\u7121\u99c4\u306b\u3057\u307e\u3059\u3002\u4f8b\u3048\u3070\u30ef\u30fc\u30af\u30b9\u30c6\u30fc\u30b7\u30e7\u30f3<a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#fn:1\" aria-label=\"1: \u30d6\u30ed\u30b0\u300cPostgres\u306b\u304a\u3051\u308b\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u9650\u754c\u306e\u5206\u6790\u300d\u306e\u811a\u6ce81\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002\"><sup>1<\/sup><\/a>\u3067\u306f\u3001max_connections=100\u3068\u6975\u7aef\u306amax_connections=100000(\u3053\u306e\u5834\u5408\u306f\u540c\u3058 pgbench \u306e48\u30af\u30e9\u30a4\u30a2\u30f3\u30c8)\u306e\u5024\u306e\u9593\u3067\u3001\u8aad\u307f\u53d6\u308a\u5c02\u7528 pgbench \u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u9055\u3044\u306f\u6e2c\u5b9a\u3067\u304d\u307e\u305b\u3093\u3002\u3057\u304b\u3057\u3001Postgres\u306b\u5fc5\u8981\u306a\u30e1\u30e2\u30ea\u306e\u5897\u52a0\u306f\u3001\u3053\u306e\u3088\u3046\u306a\u6975\u7aef\u306a\u8a2d\u5b9a\u3067\u6e2c\u5b9a\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002 shared_buffers=16GB max_connections=100 \u3067\u306f 16804 MiB \u3092\u6d88\u8cbb\u3057\u3001max_connections=100000 \u3067\u306f 21463 MiB \u306e\u5171\u6709\u30e1\u30e2\u30ea\u3092\u6d88\u8cbb\u3057\u307e\u3059\u3002\u3053\u308c\u306f\u3001\u9593\u63a5\u7684\u306b\u6027\u80fd\u52a3\u5316\u3092\u5f15\u304d\u8d77\u3053\u3059\u53ef\u80fd\u6027\u304c\u3042\u308b\u307b\u3069\u5927\u304d\u306a\u5dee\u3067\u3059(\u305f\u3060\u3057\u3001\u305d\u306e\u30e1\u30e2\u30ea\u306e\u307b\u3068\u3093\u3069\u306f\u4f7f\u7528\u3055\u308c\u307e\u305b\u3093\u304c\u3001\u3044\u305a\u308c\u306e\u69cb\u6210\u3067\u3082OS\u306f\u5272\u308a\u5f53\u3066\u307e\u305b\u3093)\u3002<\/p>\n<p>\u5b9f\u969b\u306e\u554f\u984c\u306f\u3001\u307b\u307c\u3059\u3079\u3066\u306e\u63a5\u7d9a\u304c\u30a2\u30a4\u30c9\u30eb\u72b6\u614b\u3067\u3042\u3063\u3066\u3082\u3001\u73fe\u5728\u306ePostgres\u306f\u78ba\u7acb\u3055\u308c\u305f\u63a5\u7d9a\u306e\u6570\u304c\u591a\u3044\u3053\u3068\u306b\u5fdc\u3058\u3066\u3001\u3046\u307e\u304f\u30b9\u30b1\u30fc\u30eb\u3057\u306a\u3044\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u3002<\/p>\n<p>\u3053\u306e\u3053\u3068\u3092\u8aac\u660e\u3059\u308b\u305f\u3081\u306b\u3001\u79c1\u306f2\u3064\u306e\u5225\u3005\u306epgbench<a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#fn:6\" aria-label=\"6: \u30d6\u30ed\u30b0\u300cPostgres\u306b\u304a\u3051\u308b\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u9650\u754c\u306e\u5206\u6790\u300d\u306e\u811a\u6ce86\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002\"><sup>6<\/sup><\/a>\u3092\u5b9f\u884c\u3057\u307e\u3057\u305f\u3002\u305d\u306e\u3046\u3061\u306e 1 \u3064\u306f\u3001\u5b8c\u5168\u306b\u30a2\u30a4\u30c9\u30eb\u72b6\u614b\u306e\u63a5\u7d9a\u3092\u78ba\u7acb\u3059\u308b\u3060\u3051\u3067\u3059 (\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u5074\u306e\u30b9\u30ea\u30fc\u30d7\u3092\u767a\u751f\u3055\u305b\u308b \\sleep 1s \u3092\u542b\u3080\u30c6\u30b9\u30c8 \u30d5\u30a1\u30a4\u30eb\u3092\u4f7f\u7528)\u3002\u305d\u3057\u3066\u901a\u5e38\u306e pgbench \u8aad\u307f\u53d6\u308a\u5c02\u7528\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3082\u3046 1 \u3064\u3067\u3059\u3002<\/p>\n<p>\u3053\u308c\u306f\u3001\u901a\u5e38\u3001\u30a2\u30a4\u30c9\u30eb\u63a5\u7d9a\u306e\u30bb\u30c3\u30c8\u304c\u6642\u9593\u306e\u7d4c\u904e\u3068\u3068\u3082\u306b\u5909\u5316\u3057\u554f\u984c\u304c\u304b\u306a\u308a\u60aa\u5316\u3059\u308b\u305f\u3081\u3001\u3053\u306e\u554f\u984c\u306e\u6700\u60aa\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u518d\u73fe\u3059\u308b\u65b9\u6cd5\u3068\u306f\u7a0b\u9060\u3044\u3082\u306e\u3067\u3059\u3002\u3057\u304b\u3057\u3001\u3053\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306a\u3089\u518d\u73fe\u304c\u306f\u308b\u304b\u306b\u7c21\u5358\u3067\u3059\u3002<\/p>\n<p>\u3053\u308c\u306f\u3001\u8ffd\u52a0\u63a5\u7d9a\u306e\u30b3\u30b9\u30c8\u3092\u5341\u4e8c\u5206\u306b\u5206\u96e2\u3067\u304d\u308b\u305f\u3081\u3001\u30c6\u30b9\u30c8\u3059\u308b\u306b\u306f\u975e\u5e38\u306b\u4fbf\u5229\u306a\u30b7\u30ca\u30ea\u30aa\u3067\u3059\u3002\u7279\u306b\u30a2\u30af\u30c6\u30a3\u30d6\u306a\u63a5\u7d9a\u6570\u304c\u5c11\u306a\u3044\u5834\u5408\u3001\u30b7\u30b9\u30c6\u30e0\u306e CPU \u4f7f\u7528\u7387\u306f\u304b\u306a\u308a\u4f4e\u304f\u306a\u308a\u307e\u3059\u3002\u30a2\u30a4\u30c9\u30eb\u63a5\u7d9a\u306e\u6570\u304c\u5897\u3048\u308b\u3068\u901f\u5ea6\u304c\u4f4e\u4e0b\u3059\u308b\u5834\u5408\u306f\u3001\u30a2\u30a4\u30c9\u30eb\u63a5\u7d9a\u306e\u6570\u306b\u660e\u78ba\u306b\u76f8\u95a2\u3057\u307e\u3059\u3002<\/p>\n<p>\u4ee3\u308f\u308a\u306b\u3001\u30a2\u30af\u30c6\u30a3\u30d6\u306a\u63a5\u7d9a\u6570\u304c\u591a\u3044\u30b9\u30eb\u30fc\u30d7\u30c3\u30c8\u3092\u6e2c\u5b9a\u3057\u305f\u5834\u5408\u3001\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u30b9\u30a4\u30c3\u30c1\u306e\u5897\u52a0\u3084 CPU \u30b5\u30a4\u30af\u30eb\u306e\u4e0d\u8db3\u304c\u6027\u80fd\u52a3\u5316\u306e\u539f\u56e0\u3067\u3042\u308b\u304b\u3069\u3046\u304b\u3092\u7279\u5b9a\u3059\u308b\u306e\u306f\u96e3\u3057\u304f\u306a\u308a\u307e\u3059\u3002<\/p>\n<div class=\"m-image\"><img decoding=\"async\" loading=\"lazy\" width=\"999\" height=\"440\" class=\"c-image alignnone size-full wp-image-957\" src=\"https:\/\/azbase-azbase-dev2.azurewebsites.net\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/chart-performance-impact-of-idle-connections-in-Postgres-1active.png\" alt aria-describedby=\"imageCaption\" srcset=\"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/chart-performance-impact-of-idle-connections-in-Postgres-1active.png 999w, https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/chart-performance-impact-of-idle-connections-in-Postgres-1active-300x132.png 300w, https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/chart-performance-impact-of-idle-connections-in-Postgres-1active-768x338.png 768w\" sizes=\"(max-width: 999px) 100vw, 999px\" \/><\/p>\n<p id=\"imageCaption\" class=\"c-caption-2\"><em>\u30a2\u30a4\u30c9\u30eb\u63a5\u7d9a\u6570\u304c\u53ef\u5909\u306e\u5834\u5408\u306e1 \u30a2\u30af\u30c6\u30a3\u30d6\u63a5\u7d9a\u306e\u30b9\u30eb\u30fc\u30d7\u30c3\u30c8<\/em><\/p>\n<\/div>\n<div class=\"m-image\"><img decoding=\"async\" loading=\"lazy\" width=\"999\" height=\"440\" class=\"c-image alignnone size-full wp-image-958\" src=\"https:\/\/azbase-azbase-dev2.azurewebsites.net\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/chart-performance-impact-of-idle-connections-in-Postgres-48active.png\" alt aria-describedby=\"imageCaption1\" srcset=\"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/chart-performance-impact-of-idle-connections-in-Postgres-48active.png 999w, https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/chart-performance-impact-of-idle-connections-in-Postgres-48active-300x132.png 300w, https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/chart-performance-impact-of-idle-connections-in-Postgres-48active-768x338.png 768w\" sizes=\"(max-width: 999px) 100vw, 999px\" \/><\/p>\n<p id=\"imageCaption1\" class=\"c-caption-2\"><em>\u30a2\u30a4\u30c9\u30eb\u63a5\u7d9a\u6570\u304c\u53ef\u5909\u306e\u5834\u5408\u306e48 &gt;\u30a2\u30af\u30c6\u30a3\u30d6\u63a5\u7d9a\u306e\u30b9\u30eb\u30fc\u30d7\u30c3\u30c8<\/em><\/p>\n<\/div>\n<p>\u3053\u308c\u3089\u306e\u7d50\u679c<a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#fn:7\" aria-label=\"7:\u30d6\u30ed\u30b0\u300cPostgres\u306b\u304a\u3051\u308b\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u9650\u754c\u306e\u5206\u6790\u300d\u306e\u811a\u6ce87\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002\"><sup>7<\/sup><\/a>\u306f\u3001\u30a2\u30a4\u30c9\u30eb\u63a5\u7d9a\u6570\u304c\u5897\u52a0\u3059\u308b\u3068\u3001\u30a2\u30af\u30c6\u30a3\u30d6\u306a\u63a5\u7d9a\u306e\u9054\u6210\u53ef\u80fd\u306a\u30b9\u30eb\u30fc\u30d7\u30c3\u30c8\u304c\u5927\u5e45\u306b\u4f4e\u4e0b\u3059\u308b\u3053\u3068\u3092\u660e\u78ba\u306b\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u5b9f\u969b\u306b\u306f\u3001&#8221;\u30a2\u30a4\u30c9\u30eb&#8221; \u63a5\u7d9a\u306f\u5b8c\u5168\u306b\u30a2\u30a4\u30c9\u30eb\u72b6\u614b\u3067\u306f\u306a\u304f\u3001\u3088\u308a\u4f4e\u3044\u30ec\u30fc\u30c8\u3067\u30af\u30a8\u30ea\u3092\u9001\u4fe1\u3057\u307e\u3059\u3002\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u304c\u305f\u307e\u306b\u3057\u304b\u30af\u30a8\u30ea\u3092\u9001\u4fe1\u3057\u306a\u3044\u3053\u3068\u3092\u30b7\u30df\u30e5\u30ec\u30fc\u30c8\u3059\u308b\u306b\u306f\u4ee5\u4e0b\u3092\u4f7f\u3044\u307e\u3057\u305f\uff1a<\/p>\n<div style=\"white-space: nowrap; background-color: #eeeeee; padding: 5px; lineheight: 0.3; overflow: auto;\">\n<p><span style=\"color: #000000;\">\\<\/span><span _mstmutation=\"1\">sleep <span style=\"color: #993366;\" _mstmutation=\"1\">100<\/span>ms<br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #0000ff;\" _mstmutation=\"1\">SELECT<\/span> <span style=\"color: #993366;\" _mstmutation=\"1\">1<\/span><\/span><span style=\"color: #808080;\">; <\/span><\/p>\n<\/div>\n<p><!--\u4ee5\u524d\u306e\u90e8\u5206\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8<br \/>\n<span style=\"color: #000000;\">\\<\/span>sleep <span style=\"color: #993366;\">100<\/span>ms<br \/>\n<span style=\"color: #0000ff;\">SELECT<\/span> <span style=\"color: #993366;\">1<\/span><span style=\"color: #808080;\">;<\/span><br \/>\n\u3053\u3053\u307e\u3067\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8--><\/p>\n<div class=\"m-image\"><img decoding=\"async\" loading=\"lazy\" width=\"999\" height=\"441\" class=\"c-image alignnone size-full wp-image-959\" src=\"https:\/\/azbase-azbase-dev2.azurewebsites.net\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/chart-performance-impact-of-mostly-idle-connections-in-Postgres-1active.png\" alt aria-describedby=\"imageCaption2\" srcset=\"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/chart-performance-impact-of-mostly-idle-connections-in-Postgres-1active.png 999w, https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/chart-performance-impact-of-mostly-idle-connections-in-Postgres-1active-300x132.png 300w, https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/chart-performance-impact-of-mostly-idle-connections-in-Postgres-1active-768x339.png 768w\" sizes=\"(max-width: 999px) 100vw, 999px\" \/>   <\/p>\n<p id=\"imageCaption2\" class=\"c-caption-2\"><em>\u30a2\u30a4\u30c9\u30eb\u72b6\u614b\u306e\u63a5\u7d9a\u6570\u304c\u53ef\u5909\u306e\u5834\u5408\u306e 1 \u30a2\u30af\u30c6\u30a3\u30d6\u63a5\u7d9a\u306e\u30b9\u30eb\u30fc\u30d7\u30c3\u30c8<\/em><\/p>\n<\/div>\n<div class=\"m-image\">\n    <img decoding=\"async\" loading=\"lazy\" width=\"999\" height=\"440\" class=\"c-image alignnone size-full wp-image-960\" src=\"https:\/\/azbase-azbase-dev2.azurewebsites.net\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/chart-performance-impact-of-mostly-idle-connections-in-Postgres-48active.png\" alt aria-describedby=\"imageCaption3\" srcset=\"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/chart-performance-impact-of-mostly-idle-connections-in-Postgres-48active.png 999w, https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/chart-performance-impact-of-mostly-idle-connections-in-Postgres-48active-300x132.png 300w, https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/chart-performance-impact-of-mostly-idle-connections-in-Postgres-48active-768x338.png 768w\" sizes=\"(max-width: 999px) 100vw, 999px\" \/><\/p>\n<p id=\"imageCaption3\" class=\"c-caption-2\"><em>\u30a2\u30a4\u30c9\u30eb\u72b6\u614b\u306e\u63a5\u7d9a\u6570\u304c\u53ef\u5909\u306e\u5834\u5408\u306e 48 \u30a2\u30af\u30c6\u30a3\u30d6\u63a5\u7d9a\u306e\u30b9\u30eb\u30fc\u30d7\u30c3\u30c8<\/em><\/p>\n<\/div>\n<p>\u7d50\u679c<a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#fn:8\" aria-label=\"8: \u30d6\u30ed\u30b0\u300cPostgres\u306b\u304a\u3051\u308b\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u9650\u754c\u306e\u5206\u6790\u300d\u306e\u811a\u6ce88\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002\"><sup>8<\/sup><\/a>\u306f\u3001\u5c11\u3057\u3060\u3051\u73fe\u5b9f\u7684\u306a\u30b7\u30ca\u30ea\u30aa\u306b\u3088\u308a\u3001\u30a2\u30af\u30c6\u30a3\u30d6\u306a\u63a5\u7d9a\u304c\u3055\u3089\u306b\u9045\u304f\u306a\u308b\u3053\u3068\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p class=\"c-heading-4\">\u539f\u56e0<\/p>\n<p>\u3053\u308c\u3089\u306e\u7d50\u679c\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001CPU\/\u30e1\u30e2\u30ea\u304c\u8c4a\u5bcc\u306a\u5834\u5408\u3067\u3082\u3001\u591a\u304f\u306e\u63a5\u7d9a\u3092\u51e6\u7406\u3059\u308b\u91cd\u5927\u306a\u554f\u984c\u304c\u3042\u308b\u3053\u3068\u3092\u975e\u5e38\u306b\u660e\u78ba\u306b\u793a\u3057\u3066\u3044\u307e\u3059\u3002\u540c\u6642\u30a2\u30a4\u30c9\u30eb\u63a5\u7d9a\u304c\u539f\u56e0\u3067 1 \u3064\u306e\u30a2\u30af\u30c6\u30a3\u30d6\u306a\u63a5\u7d9a\u304c 2 \u500d\u4ee5\u4e0a\u306b\u901f\u5ea6\u4f4e\u4e0b\u3059\u308b\u3068\u3044\u3046\u4e8b\u5b9f\u306f\u3001\u975e\u5e38\u306b\u660e\u78ba\u306a\u554f\u984c\u3092\u6307\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>CPU \u30d7\u30ed\u30d5\u30a1\u30a4\u30eb\u306f\u3001Postgres \u306b\u8cac\u4efb\u306e\u4e00\u7aef\u304c\u3042\u308b\u3053\u3068\u3092\u7d20\u65e9\u304f\u7279\u5b9a\u3057\u307e\u3059\uff1a<\/p>\n<div class=\"m-image\">\n    <img decoding=\"async\" loading=\"lazy\" width=\"707\" height=\"474\" class=\"c-image alignnone size-full wp-image-961\" src=\"https:\/\/azbase-azbase-dev2.azurewebsites.net\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/profile_1active_with_5000_idle.png\" alt aria-describedby=\"imageCaption4\" srcset=\"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/profile_1active_with_5000_idle.png 707w, https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-content\/uploads\/2020\/12\/profile_1active_with_5000_idle-300x201.png 300w\" sizes=\"(max-width: 707px) 100vw, 707px\" \/>  <\/p>\n<p id=\"imageCaption4\" class=\"c-caption-2\"><em>5000 \u30a2\u30a4\u30c9\u30eb\u63a5\u7d9a\u3068\u540c\u6642\u306b\u8aad\u307f\u53d6\u308a\u5c02\u7528 pgbench \u3092\u5b9f\u884c\u3057\u3066\u3044\u308b 1 \u3064\u306e\u30a2\u30af\u30c6\u30a3\u30d6\u306a\u63a5\u7d9a\u306e\u30d7\u30ed\u30d5\u30a1\u30a4\u30eb\u3002\u30dc\u30c8\u30eb\u30cd\u30c3\u30af\u306f\u660e\u3089\u304b\u306b GetSnapshotData() \u306b\u3042\u308a\u307e\u3059\u3002<\/em><\/p>\n<\/div>\n<p>\u660e\u78ba\u306a\u3053\u3068\u3067\u3059\u304c\u3001\u30dc\u30c8\u30eb\u30cd\u30c3\u30af\u306f\u5b8c\u5168\u306bGetSnapshotData() \u95a2\u6570\u306b\u3042\u308a\u307e\u3059\u3002\u3053\u306e\u95a2\u6570\u306f\u3001<a class=\"c-hyperlink\" href=\"https:\/\/www.postgresql.org\/docs\/devel\/mvcc-intro.html\" aria-label=\"\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u5206\u96e2: \u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002\">\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u5206\u96e2<\/a>\u3092\u8aad\u307f\u53d6\u308a\u51e6\u7406\u306b\u63d0\u4f9b\u3059\u308b\u305f\u3081\u306b\u5fc5\u8981\u306a\u4f5c\u696d\u306e\u5927\u90e8\u5206\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002GetSnapshotData() \u306f\u3044\u308f\u3086\u308b\u300c\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u300d\u3092\u4f5c\u6210\u3057\u3001\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306f\u540c\u6642\u5b9f\u884c\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u5f71\u97ff\u306e\u3044\u305a\u308c\u304c\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306b\u5bfe\u3057\u3066\u898b\u3048\u3066\u3001\u3044\u305a\u308c\u304c\u898b\u3048\u306a\u3044\u304b\u3092\u8a18\u8ff0\u3057\u307e\u3059\u3002\u3053\u308c\u3089\u306e\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306f\u975e\u5e38\u306b\u983b\u7e41\u306b\u4f5c\u6210\u3055\u308c\u307e\u3059 (\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u3054\u3068\u306b\u5c11\u306a\u304f\u3068\u3082 1 \u56de\u3001<em>\u975e\u5e38\u306b<\/em>\u4e00\u822c\u7684\u306b\u591a\u304f\u306e\u5834\u5408)\u3002<\/p>\n<p>\u5b9f\u88c5\u3092\u77e5\u3089\u306a\u304f\u3066\u3082\u3001\u305d\u306e\u3088\u3046\u306a\u30bf\u30b9\u30af\u304c\u3088\u308a\u9ad8\u4fa1\u306b\u306a\u308b\u307b\u3069\u3001\u3088\u308a\u591a\u304f\u306e\u63a5\u7d9a\/\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u3092\u51e6\u7406\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3053\u3068\u306f\u3001\u76f4\u611f\u7684\u306a\u610f\u5473\u3092\u6301\u3061\u307e\u3059(\u5c11\u306a\u304f\u3068\u3082\u79c1\u306f\u305d\u3046\u601d\u3044\u307e\u3059\u304c\u3001\u79c1\u306f\u305d\u308c\u304c\u4f55\u3092\u3059\u308b\u306e\u304b\u3082\u77e5\u3063\u3066\u3044\u307e\u3059)\u3002<\/p>\n<p>Brandur\u306b\u3088\u308b2\u3064\u306e\u30d6\u30ed\u30b0\u8a18\u4e8b\u306f\u3001\u3053\u308c\u3092\u53d6\u308a\u5dfb\u304f\u4ed5\u7d44\u307f\u3068\u554f\u984c\u3092\u3088\u308a\u8a73\u7d30\u306b\u8aac\u660e\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<ul class=\"c-list\" style=\"letter-spacing: .05em; line-height: 2em;\">\n<li><a class=\"c-hyperlink\" href=\"https:\/\/brandur.org\/postgres-atomicity\" aria-label=\"How Postgres Makes Transactions Atomic: \u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002\">How Postgres Makes Transactions Atomic<\/a><\/li>\n<li><a class=\"c-hyperlink\" href=\"https:\/\/brandur.org\/postgres-connections\" aria-label=\"How to Manage Connections Efficiently in Postgres, or Any Database: \u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002\">How to Manage Connections Efficiently in Postgres, or Any Database<\/a><\/li>\n<\/ul>\n<p class=\"c-heading-4\">\u7d50\u8ad6: \u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306f\u5927\u304d\u306a\u5236\u9650<\/p>\n<p>\u63a5\u7d9a\u6570\u304c\u591a\u3044\u3068\u3001\u30a2\u30a4\u30c9\u30eb\u72b6\u614b\u306e\u5834\u5408\u3067\u3082\u3001\u4ed6\u306e\u63a5\u7d9a\u306e\u52b9\u7387\u304c\u660e\u3089\u304b\u306b\u4f4e\u4e0b\u3057\u307e\u3059 (\u4e0a\u3067\u8aac\u660e\u3057\u305f\u3088\u3046\u306b\u3001\u975e\u5e38\u306b\u4e00\u822c\u7684\u3067\u3059)\u3002\u540c\u6642\u63a5\u7d9a\u6570\u3092\u6e1b\u3089\u3057\u3001\u30af\u30a8\u30ea\u3092\u767a\u884c\u3059\u308b\u56de\u6570\u3092\u6e1b\u3089\u3059\u3053\u3068\u3092\u9664\u304f\u3068\u3001\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u554f\u984c\u306b\u5bfe\u3059\u308b\u5b9f\u969b\u306e\u56de\u907f\u7b56\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n<hr class=\"c-divider f-pad-vertical-3x\" \/>\n<h3 class=\"c-heading-3\">\u63a5\u7d9a\u30e2\u30c7\u30eb\u3068\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u30b9\u30a4\u30c3\u30c1<\/h3>\n<p><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#constant-connection-overhead\" aria-label=\"\u524d\u8ff0: \u3053\u306e\u30c8\u30d4\u30c3\u30af\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002\">\u524d\u8ff0<\/a>\u306e\u3088\u3046\u306b\u3001Postgres \u306f1\u63a5\u7d9a\u3054\u3068\u306b 1 \u3064\u306e\u30d7\u30ed\u30bb\u30b9\u30e2\u30c7\u30eb\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002\u3053\u308c\u306f\u591a\u304f\u306e\u5834\u5408\u306b\u9069\u3057\u3066\u3044\u307e\u3059\u304c\u300110~100\u6570\u5343\u3082\u306e\u63a5\u7d9a\u306b\u5bfe\u51e6\u3059\u308b\u969b\u306b\u306f\u5236\u9650\u8981\u56e0\u3067\u3059\u3002<\/p>\n<p>\u30d0\u30c3\u30af\u30a8\u30f3\u30c9\u30d7\u30ed\u30bb\u30b9\u304c\u30af\u30a8\u30ea\u3092\u53d7\u4fe1\u3059\u308b\u305f\u3073\u306b\u3001\u30ab\u30fc\u30cd\u30eb\u306f\u305d\u306e\u30d7\u30ed\u30bb\u30b9\u306b\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u30b9\u30a4\u30c3\u30c1\u3092\u5b9f\u884c\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u305d\u308c\u306f\u5b89\u304f\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u3057\u304b\u3057\u3001\u3055\u3089\u306b\u91cd\u8981\u306a\u306e\u306f\u3001\u30af\u30a8\u30ea\u306e\u7d50\u679c\u304c\u8a08\u7b97\u3055\u308c\u308b\u3068\u3001\u30d0\u30c3\u30af\u30a8\u30f3\u30c9\u306f\u4e00\u5b9a\u306e\u6642\u9593\u30a2\u30a4\u30c9\u30eb\u72b6\u614b\u306b\u306a\u308a\u307e\u3059\u3002\u3064\u307e\u308a\u3001\u9ad8\u8ca0\u8377\u306e\u30b5\u30fc\u30d0\u30fc\u3067\u306f\u5225\u306e\u30d7\u30ed\u30bb\u30b9\/\u30d0\u30c3\u30af\u30a8\u30f3\u30c9\/\u63a5\u7d9a\u3092\u30b9\u30b1\u30b8\u30e5\u30fc\u30eb\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059(\u30d7\u30ed\u30bb\u30b9\u9593\u306e\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u30b9\u30a4\u30c3\u30c1\u306f\u3001\u30d7\u30ed\u30bb\u30b9\u3068\u30ab\u30fc\u30cd\u30eb\u306e\u540c\u3058\u30d7\u30ed\u30bb\u30b9\u3092\u884c\u3046\u3088\u308a\u3082\u30b3\u30b9\u30c8\u304c\u304b\u304b\u308a\u307e\u3059\u3002\u4f8b\u3048\u3070\u3001syscall\u306e\u4e00\u90e8)\u3002<\/p>\n<p>1\u63a5\u7d9a\u3054\u3068\u306b1\u30b9\u30ec\u30c3\u30c9\u3068\u3044\u3046\u30e2\u30c7\u30eb\u3078\u5207\u308a\u66ff\u3048\u3066\u3082\u3001\u3053\u306e\u554f\u984c\u306b\u5bfe\u3057\u3066\u610f\u5473\u306e\u3042\u308b\u5bfe\u5fdc\u306b\u306f\u306a\u3089\u306a\u3044\u3053\u3068\u306b\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\uff1a\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u30b9\u30a4\u30c3\u30c1\u306e\u3044\u304f\u3064\u304b\u306f\u3088\u308a\u5b89\u304f\u306a\u308a\u307e\u3059\u304c\u3001\u305d\u308c\u3067\u3082\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u30b9\u30a4\u30c3\u30c1\u306f\u4e3b\u8981\u306a\u5236\u9650\u3067\u3059\u3002\u30b9\u30ec\u30c3\u30c9\u306b\u5207\u308a\u66ff\u3048\u308b\u691c\u8a0e\u3092\u3059\u308b\u7406\u7531\u306f\u3042\u308a\u307e\u3059\u304c\u3001\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u305d\u306e\u3082\u306e\u306f\u91cd\u8981\u3067\u306f\u3042\u308a\u307e\u305b\u3093\uff08\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u306e\u5909\u66f4\u3092\u8ffd\u52a0\u305b\u305a\u3001\u30b9\u30ec\u30c3\u30c9\u3092\u4f7f\u7528\u3059\u308b\u65b9\u304c\u7c21\u5358\u306a\u3082\u306e\u3082\u3042\u308a\u307e\u3059)\u3002<\/p>\n<p>\u81a8\u5927\u306a\u6570\u306e\u63a5\u7d9a\u3092\u51e6\u7406\u3059\u308b\u306b\u306f\u3001\u7570\u306a\u308b\u30bf\u30a4\u30d7\u306e\u63a5\u7d9a\u30e2\u30c7\u30eb\u304c\u5fc5\u8981\u3067\u3059\u3002\u63a5\u7d9a\u3054\u3068\u306e\u30d7\u30ed\u30bb\u30b9\/\u30b9\u30ec\u30c3\u30c9\u30e2\u30c7\u30eb\u3092\u4f7f\u7528\u3059\u308b\u4ee3\u308f\u308a\u306b\u3001\u56fa\u5b9a\/\u5236\u9650\u3055\u308c\u305f\u6570\u306e\u30d7\u30ed\u30bb\u30b9\/\u30b9\u30ec\u30c3\u30c9\u304c\u3059\u3079\u3066\u306e\u63a5\u7d9a\u3092\u51e6\u7406\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u4e00\u5ea6\u306b\u591a\u304f\u306e\u63a5\u7d9a\u3067\u53d7\u4fe1\u30af\u30a8\u30ea\u3092\u5f85\u6a5f\u3057\u3001OS \u306e CPU \u30b9\u30b1\u30b8\u30e5\u30fc\u30e9\u306b\u3088\u3063\u3066\u4e2d\u65ad\u3055\u308c\u308b\u3053\u3068\u306a\u304f\u3001\u591a\u304f\u306e\u30af\u30a8\u30ea\u3092\u51e6\u7406\u3059\u308b\u3053\u3068\u3067\u3001\u52b9\u7387\u3092\u5927\u5e45\u306b\u5411\u4e0a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u3053\u308c\u306f\u79c1\u306e\u7d20\u6674\u3089\u3057\u3044\u6d1e\u5bdf\u529b\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u3053\u306e\u3088\u3046\u306a\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u306f\u5e83\u304f\u4f7f\u7528\u3055\u308c\u3066\u304a\u308a\u3001\u5e83\u304f\u8b70\u8ad6\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u4f8b\u3048\u3070\u30011999\u5e74\u306b\u4f5c\u3089\u308c\u305f<a class=\"c-hyperlink\" href=\"https:\/\/en.wikipedia.org\/wiki\/C10k_problem\" aria-label=\"C10K\u554f\u984c\u306b\u3064\u3044\u3066\u3082\u3063\u3068\u77e5\u308b\">C10k\u554f\u984c<\/a>\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u30b9\u30a4\u30c3\u30c1\u4ee5\u5916\u306b\u3082\u3001\u591a\u304f\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u4e0a\u306e\u5229\u70b9\u3092\u5f97\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u305f\u3068\u3048\u3070\u3001\u30b3\u30a2\u6570\u306e\u591a\u3044\u30de\u30b7\u30f3\u3067\u306f\u3001\u7279\u5b9a\u306e\u30d7\u30ed\u30bb\u30b9\/\u30b9\u30ec\u30c3\u30c9\u3084\u30e1\u30e2\u30ea\u306e\u9818\u57df\u3092\u7279\u5b9a\u306eCPU\u30b3\u30a2\u306b\u30d0\u30a4\u30f3\u30c9\u3059\u308b\u3053\u3068\u3067\u5171\u6709\u30e1\u30e2\u30ea\u306e\u5c40\u6240\u6027\u3092\u9ad8\u3081\u308b\u3053\u3068\u306b\u3088\u3063\u3066\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5927\u304d\u306a\u5411\u4e0a\u3092\u5f97\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u3057\u304b\u3057\u3001\u3053\u306e\u3088\u3046\u306a\u7570\u306a\u308b\u7a2e\u985e\u306e\u63a5\u7d9a\u30e2\u30c7\u30eb\u3092\u30b5\u30dd\u30fc\u30c8\u3059\u308b\u3088\u3046\u306bPostgres\u3092\u5909\u66f4\u3059\u308b\u3053\u3068\u306f\u5927\u5909\u306a\u4f5c\u696d\u3067\u3059\u3002\u3053\u306e\u65b9\u6cd5\u3067\u306f\u3001\u30d7\u30ed\u30bb\u30b9\u3068\u63a5\u7d9a\u306e\u9593\u306e\u591a\u304f\u306e\u4f9d\u5b58\u95a2\u4fc2\u3092\u614e\u91cd\u306b\u5206\u96e2\u3059\u308b\u3060\u3051\u3067\u306a\u304f\u3001\u7570\u306a\u308b\u30af\u30a8\u30ea\u9593\u306e\u30e6\u30fc\u30b6\u30fc\u30e9\u30f3\u30c9\u30b9\u30b1\u30b8\u30e5\u30fc\u30ea\u30f3\u30b0\u3001\u975e\u540c\u671f IO \u306e\u30b5\u30dd\u30fc\u30c8\u3001\u30af\u30a8\u30ea\u5b9f\u884c\u30e2\u30c7\u30eb\u306e\u9055\u3044 (\u30af\u30a8\u30ea\u3054\u3068\u306b\u500b\u5225\u306e\u30b9\u30bf\u30c3\u30af\u304c\u5fc5\u8981\u306b\u306a\u3089\u306a\u3044\u3088\u3046\u306b) \u306a\u3069\u3092\u884c\u3046\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<hr class=\"c-divider f-pad-vertical-3x\" \/>\n<h3 class=\"c-heading-3\">\u7d50\u8ad6: Postgres\u306e\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u6539\u5584\u304b\u3089\u59cb\u3081\u308b<\/h3>\n<p>\u79c1\u306e\u610f\u898b\u3067\u306f\u3001\u30e1\u30e2\u30ea\u306e\u4f7f\u7528\u306e\u554f\u984c\u306f\u3001\u4ed6\u306e\u554f\u984c\u304c\u8b70\u8ad6\u3055\u308c\u3066\u3044\u308b\u307b\u3069\u6df1\u523b\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u7406\u7531\u306e\u4e00\u90e8\u306f\u3001\u63a5\u7d9a\u306e\u30e1\u30e2\u30ea\u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9\u306f\u521d\u3081\u306b\u76ee\u306b\u3059\u308b\u307b\u3069\u5927\u304d\u304f\u306f\u306a\u304f\u3001Postgres\u306e\u30ad\u30e3\u30c3\u30b7\u30e5\u304c\u3042\u307e\u308a\u306b\u591a\u304f\u306e\u30e1\u30e2\u30ea\u3092\u6d88\u8cbb\u3059\u308b\u554f\u984c\u306f\u5408\u7406\u7684\u306b\u56de\u907f\u51fa\u6765\u308b\u304b\u3089\u3001\u3067\u3059\u3002<\/p>\n<p>\u79c1\u305f\u3061\u306f\u3001Postgres\u306e\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306b\u95a2\u3059\u308b\u6539\u5584\u3092\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u3001\u304b\u3064<strong>\u3059\u3079\u304d<\/strong>\u3067\u3001\u7c21\u5358\u306b\u5f97\u3089\u308c\u308b\u6210\u679c\u304c\u3044\u304f\u3064\u304b\u3042\u308a\u307e\u3059\u3002\u3057\u304b\u3057\u3001\u79c1\u306f\u3001\u73fe\u5728\u306e\u3088\u3046\u306b\u3001\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u3092\u6539\u5584\u3059\u308b\u3053\u3068\u306f\u5c11\u306a\u304f\u3068\u3082\u57fa\u672c\u7684\u306a\u30ec\u30d9\u30eb\u3067\u306f\u306a\u304f\u3001\u63a5\u7d9a\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306b\u95a2\u3059\u308b\u30a4\u30e1\u30fc\u30b8\u3092\u5909\u3048\u308b\u3068\u306f\u601d\u3044\u307e\u305b\u3093\u3002<\/p>\n<p>\u3053\u308c\u306b\u5bfe\u3057\u3001\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u554f\u984c\u3092\u56de\u907f\u3059\u308b\u512a\u308c\u305f\u65b9\u6cd5\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u4e0a\u8ff0\u3057\u305f\u3088\u3046\u306b\u3001\u78ba\u7acb\u3055\u308c\u305f\u63a5\u7d9a\u306e\u6570\u3092\u5927\u5e45\u306b\u6e1b\u3089\u3059\u3053\u3068\u306f\u3001\u591a\u304f\u306e\u5834\u5408\u3001\u5b9f\u73fe\u4e0d\u53ef\u80fd\u3067\u3059\u3002\u5b9f\u969b\u306b\u306f\u3001\u4ed6\u306e\u56de\u907f\u7b56\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n<p>\u3055\u3089\u306b\u3001\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u554f\u984c\u306f\u975e\u5e38\u306b\u30ed\u30fc\u30ab\u30e9\u30a4\u30ba\u3055\u308c\u3001\u305d\u308c\u306b\u53d6\u308a\u7d44\u3080\u306e\u306f\u975e\u5e38\u306b\u73fe\u5b9f\u7684\u3067\u3059\u3002\u57fa\u672c\u7684\u306a\u30d1\u30e9\u30c0\u30a4\u30e0\u30b7\u30d5\u30c8\u306f\u5fc5\u8981\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n<p>\u6700\u5f8c\u306b\u3001\u63a5\u7d9a\u30e2\u30c7\u30eb\u3092\u5b8c\u5168\u306b\u5207\u308a\u66ff\u3048\u308b\u3053\u3068\u306b\u3088\u3063\u3066\u3001\u4f55\u4e07\u3082\u306e\u63a5\u7d9a\u3092\u51e6\u7406\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3068\u3044\u3046\u5074\u9762\u304c\u3042\u308a\u307e\u3059\u3002\u6982\u8aac\u3057\u305f\u3088\u3046\u306b\u3001\u305d\u308c\u306f\u5de8\u5927\u306a\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\/\u57fa\u672c\u7684\u306a\u30d1\u30e9\u30c0\u30a4\u30e0\u30b7\u30d5\u30c8\u3067\u3059\u3002\u660e\u3089\u304b\u306b\u3001\u305d\u308c\u306f\u53d6\u308a\u7d44\u3080\u3079\u304d\u3067\u306f\u306a\u3044\u3053\u3068\u3092\u610f\u5473\u3059\u308b\u3082\u306e\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n<p>\u3057\u305f\u304c\u3063\u3066\u3001\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u554f\u984c\u306b\u6700\u521d\u306b\u5bfe\u51e6\u3059\u308b\u3053\u3068\u306f\u4fa1\u5024\u304c\u3042\u308b\u3068\u601d\u308f\u308c\u3001\u305d\u308c\u81ea\u4f53\u3067\u5927\u304d\u306a\u5229\u70b9\u304c\u671f\u5f85\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>\u3057\u304b\u3057\u3001\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306b\u6700\u521d\u306b\u53d6\u308a\u7d44\u3080\u6839\u672c\u7684\u306a\u7406\u7531\u3082\u3042\u308a\u307e\u3059: \u4f8b\u3048\u3070\u3001\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u554f\u984c\u306b\u540c\u6642\u306b\u5bfe\u51e6\u3059\u308b\u4e00\u65b9\u3067\u3001\u63a5\u7d9a\u30e2\u30c7\u30eb\u3092\u5207\u308a\u66ff\u3048\u308bqs\u306f\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u554f\u984c\u306b\u307e\u3063\u305f\u304f\u5bfe\u51e6\u3057\u307e\u305b\u3093\u3002\u63a5\u7d9a\u306b\u5c02\u7528\u306e\u30d7\u30ed\u30bb\u30b9\u304c\u306a\u304f\u306a\u3063\u305f\u3068\u3057\u3066\u3082\u3001\u63a5\u7d9a\u9593\u306e\u5206\u96e2\u3092\u63d0\u4f9b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u306e\u306f\u660e\u3089\u304b\u3067\u3059\u3002<\/p>\n<p>\u3046\u307e\u304f\u3044\u3051\u3070\u3001\u4eca\u3001\u3042\u306a\u305f\u306f\u79c1\u304c\u6700\u521d\u306bPostgres\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306b\u7126\u70b9\u3092\u5f53\u3066\u308b\u3053\u3068\u3092\u9078\u3093\u3060\u7406\u7531\u3092\u7406\u89e3\u3057\u3066\u3044\u307e\u3059\u3002\u79c1\u306e\u6b21\u306e\u30d6\u30ed\u30b0\u8a18\u4e8b\u3067\u305d\u308c\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n<hr class=\"c-divider f-pad-vertical-3x\" \/>\n<ol class=\"c-list\" style=\"letter-spacing: .05em; line-height: 2em;\">\n<li>2x xeon gold 5215, 192GiB of RAM, kernel 5.8.5, debian Sid\u00a0<a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#fnref:1\" aria-describedby=\"go to page\">\u21a9\ufe0e<\/a><\/li>\n<li>psql \u3067 100k \u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3059\u308b:<\/li>\n<\/ol>\n<div style=\"white-space: nowrap; background-color: #eeeeee; padding: 5px; lineheight: 0.9; overflow: auto;\">postgres<span style=\"color: #808080;\">[<\/span><span style=\"color: #993366;\">2627319<\/span><span style=\"color: #808080;\">][<\/span><span style=\"color: #993366;\">1<\/span><span style=\"color: #808080;\">]=# SELECT format(&#8216;begin;create table foo_%1s(id serial primary key, data1 int, data2 text, data3 json);commit;&#8217;, g.i) FROM generate_series(1, 100000) g(i)<\/span><br \/>\n<span style=\"color: #808080;\">\\<\/span>gexec<br \/>\nCOMMIT<br \/>\nCOMMIT<br \/>\n\u2026<\/div>\n<p><!--<br \/>\npostgres<span style=\"color: #808080;\">[<\/span><span style=\"color: #993366;\">2627319<\/span><span style=\"color: #808080;\">][<\/span><span style=\"color: #993366;\">1<\/span><span style=\"color: #808080;\">]=# SELECT format('begin;create table foo_%1s(id serial primary key, data1 int, data2 text, data3 json);commit;', g.i) FROM generate_series(1, 100000) g(i)<\/span><\/p>\n\n\n\n\n<p><span style=\"color: #808080;\">\\<\/span>gexec<\/p>\n\n\n\n\n<p>COMMIT<\/p>\n\n\n\n\n<p>COMMIT<\/p>\n\n\n\n\n<p>\u2026<br \/>\n--><\/p>\n<ol class=\"c-list\" start=\"3\" style=\"letter-spacing: .05em; line-height: 2em;\">\n<li>\u30af\u30a8\u30ea\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\uff1a<\/li>\n<\/ol>\n<div style=\"white-space: nowrap; background-color: #eeeeee; padding: 5px; lineheight: 0.9; overflow: auto;\"><span style=\"color: #3366ff;\">WITH<\/span> RECURSIVE contexts <span style=\"color: #3366ff;\">AS<\/span> <span style=\"color: #808080;\">(<\/span><br \/>\n<span style=\"color: #3366ff; margin-left: 2em;\">SELECT<\/span> <span style=\"color: #b8860b;\">* <\/span><span style=\"color: #3366ff;\">FROM<\/span> pg_backend_memory_contexts<span style=\"color: #808080;\">)<\/span>,<br \/>\n<span style=\"margin-left: 2em;\">caches<\/span> <span style=\"color: #0000ff;\">AS<\/span> <span style=\"color: #808080;\">(<\/span><br \/>\n<span style=\"color: #0000ff; margin-left: 4em;\">SELECT<\/span> <span style=\"color: #b8860b;\">*<\/span><br \/>\n<span style=\"color: #0000ff; margin-left: 4em;\">FROM<\/span> contexts<br \/>\n<span style=\"color: #0000ff; margin-left: 4em;\">WHERE<\/span> name = <span style=\"color: #99cc22;\">&#8216;CacheMemoryContext&#8217;<\/span><\/div>\n<div style=\"white-space: nowrap; background-color: #eeeeee; padding: 5px; lineheight: 0.9; overflow: auto;\"><span _mstmutation=\"1\"><span style=\"color: #3366ff; margin-left: 3em;\" _mstmutation=\"1\">UNION ALL<\/span><br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #3366ff; margin-left: 4em;\" _mstmutation=\"1\">SELECT<\/span> contexts.<span style=\"color: #b8860b;\" _mstmutation=\"1\">*<\/span><br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #3366ff; margin-left: 4em;\" _mstmutation=\"1\">FROM<\/span> caches<br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #3366ff; margin-left: 4em;\" _mstmutation=\"1\">JOIN<\/span> contexts <span style=\"color: #3366ff;\" _mstmutation=\"1\">ON<\/span> <span style=\"color: #808080;\" _mstmutation=\"1\">(<\/span>contexts.parent = caches.name<span style=\"color: #808080;\" _mstmutation=\"1\">)<\/span><br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #808080; margin-left: 2em;\" _mstmutation=\"1\">)<\/span><br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #3366ff;\" _mstmutation=\"1\">SELECT<\/span><br _mstmutation=\"1\" \/><br \/>\n<span style=\"margin-left: 4em;\" _mstmutation=\"1\">name, parent,<\/span><br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #ff0000; margin-left: 4em;\" _mstmutation=\"1\">sum<\/span><span style=\"color: #808080;\" _mstmutation=\"1\">(<\/span>total_bytes<span style=\"color: #808080;\" _mstmutation=\"1\">)<\/span> size_bytes,<br _mstmutation=\"1\" \/><br \/>\n<span style=\"margin-left: 4em;\" _mstmutation=\"1\">pg_size_pretty<\/span><span style=\"color: #808080;\" _mstmutation=\"1\">(<\/span><span style=\"color: #ff0000;\" _mstmutation=\"1\">sum<\/span>(total_bytes<span style=\"color: #808080;\" _mstmutation=\"1\">))<\/span> size_human,<br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #ff0000; margin-left: 4em;\" _mstmutation=\"1\">count<\/span><span style=\"color: #808080;\" _mstmutation=\"1\">(<\/span><span style=\"color: #b8860b;\" _mstmutation=\"1\">*<\/span><span style=\"color: #808080;\" _mstmutation=\"1\">)<\/span> <span style=\"color: #3366ff;\" _mstmutation=\"1\">AS<\/span> num_contexts<br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #3366ff;\" _mstmutation=\"1\">FROM<\/span> caches<br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #3366ff;\" _mstmutation=\"1\">GROUP BY<\/span> name, parent<br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #3366ff;\" _mstmutation=\"1\">ORDER BY<\/span> <span style=\"color: #ff0000;\" _mstmutation=\"1\">SUM<\/span><span style=\"color: #808080;\" _mstmutation=\"1\">(<\/span>total_bytes<span style=\"color: #808080;\" _mstmutation=\"1\">)<\/span> <span style=\"color: #3366ff;\" _mstmutation=\"1\">DESC<\/span><\/span><span style=\"color: #808080;\">;<\/span><\/div>\n<ol class=\"c-list\" start=\"4\" style=\"letter-spacing: .05em; line-height: 2em;\">\n<li>foo* \u3068\u3044\u3046\u540d\u524d\u306e\u5168\u3066\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u30af\u30a8\u30ea\uff1a<\/li>\n<\/ol>\n<div style=\"white-space: nowrap; background-color: #eeeeee; padding: 5px; lineheight: 0.9; overflow: auto;\"><span _mstmutation=\"1\"><span style=\"color: #3366ff;\" _mstmutation=\"1\">DO<\/span> $$<br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #3366ff; margin-left: 1em;\" _mstmutation=\"1\">DECLARE<\/span><br _mstmutation=\"1\" \/><br \/>\n<span style=\"margin-left: 2em;\" _mstmutation=\"1\">cnt<\/span> <span style=\"color: #3366ff;\" _mstmutation=\"1\">int<\/span> :<span style=\"color: #b8860b;\" _mstmutation=\"1\">=<\/span> <span style=\"color: #993366;\" _mstmutation=\"1\">0<\/span><span style=\"color: #808080;\" _mstmutation=\"1\">;<\/span><br _mstmutation=\"1\" \/><br \/>\n<span style=\"margin-left: 2em;\" _mstmutation=\"1\">v record<\/span><span style=\"color: #808080;\" _mstmutation=\"1\">;<\/span><br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #3366ff; margin-left: 1em;\" _mstmutation=\"1\">BEGIN<\/span><br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #3366ff; margin-left: 2em;\" _mstmutation=\"1\">FOR<\/span> v <span style=\"color: #b8860b;\" _mstmutation=\"1\">IN<\/span> <span style=\"color: #3366ff;\" _mstmutation=\"1\">SELECT <\/span><span style=\"color: #b8860b;\" _mstmutation=\"1\">*<\/span> <span style=\"color: #3366ff;\" _mstmutation=\"1\">FROM<\/span> pg_class <span style=\"color: #3366ff;\" _mstmutation=\"1\">WHERE<\/span> relkind = <span style=\"color: #99cc22;\" _mstmutation=\"1\">&#8216;r&#8217; <\/span><span style=\"color: #b8860b;\" _mstmutation=\"1\">and<\/span> relname <span style=\"color: #b8860b;\" _mstmutation=\"1\">LIKE<\/span> <span style=\"color: #99cc22;\" _mstmutation=\"1\">&#8216;foo%&#8217;<\/span> <span style=\"color: #3366ff;\" _mstmutation=\"1\">LOOP<\/span><br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #3366ff; margin-left: 3em;\" _mstmutation=\"1\">EXECUTE<\/span> <span style=\"color: #ff0000;\" _mstmutation=\"1\">format<\/span>(<span style=\"color: #99cc22;\" _mstmutation=\"1\">&#8216;SELECT count(*) FROM %s&#8217;,<\/span> v.oid::regclass::<span style=\"color: #3366ff;\" _mstmutation=\"1\">text<\/span>)<span style=\"color: #808080;\" _mstmutation=\"1\">;<\/span><br _mstmutation=\"1\" \/><br \/>\n<span style=\"margin-left: 3em;\" _mstmutation=\"1\">cnt<\/span> <span style=\"color: #b8860b;\" _mstmutation=\"1\">=<\/span> cnt <span style=\"color: #b8860b;\" _mstmutation=\"1\">+<\/span> <span style=\"color: #993366;\" _mstmutation=\"1\">1<\/span><span style=\"color: #808080;\" _mstmutation=\"1\">;<\/span><br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #3366ff; margin-left: 3em;\" _mstmutation=\"1\">IF<\/span> cnt <span style=\"color: #b8860b;\" _mstmutation=\"1\">%<\/span>\u00a0<span style=\"color: #993366;\" _mstmutation=\"1\">100<\/span> <span style=\"color: #b8860b;\" _mstmutation=\"1\">=<\/span> <span style=\"color: #993366;\" _mstmutation=\"1\">0<\/span> <span style=\"color: #3366ff;\" _mstmutation=\"1\">THEN<\/span><br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #3366ff; margin-left: 4em;\" _mstmutation=\"1\">COMMIT<\/span><span style=\"color: #808080;\" _mstmutation=\"1\">;<\/span><br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #3366ff; margin-left: 3em;\" _mstmutation=\"1\">END IF<\/span><span style=\"color: #808080;\" _mstmutation=\"1\">;<\/span><br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #3366ff; margin-left: 2em;\" _mstmutation=\"1\">END LOOP<\/span><span style=\"color: #808080;\" _mstmutation=\"1\">;<\/span><br _mstmutation=\"1\" \/><br \/>\n<span style=\"margin-left: 2em;\" _mstmutation=\"1\">RAISE NOTICE<\/span> <span style=\"color: #99cc22;\" _mstmutation=\"1\">&#8216;tables %1&#8217;,<\/span> cnt<span style=\"color: #808080;\" _mstmutation=\"1\">;<\/span><br _mstmutation=\"1\" \/><br \/>\n<span style=\"color: #3366ff; margin-left: 1em;\" _mstmutation=\"1\">END<\/span><\/span><span style=\"color: #808080;\">;<\/span>$$<span style=\"color: #808080;\">;<\/span><\/div>\n<p><!--<br \/>\n<span style=\"color: #3366ff;\">WITH<\/span> RECURSIVE contexts <span style=\"color: #3366ff;\">AS<\/span> <span style=\"color: #808080;\">(<\/span><\/p>\n\n\n\n\n<p><span style=\"color: #3366ff;\">SELECT<\/span> <span style=\"color: #b8860b;\">* <\/span><span style=\"color: #3366ff;\">FROM<\/span> pg_backend_memory_contexts<span style=\"color: #808080;\">)<\/span>,<\/p>\n\n\n\n\n<p>caches <span style=\"color: #0000ff;\">AS<\/span> <span style=\"color: #808080;\">(<\/span><\/p>\n\n\n\n\n<p><span style=\"color: #0000ff;\">SELECT<\/span> <span style=\"color: #b8860b;\">*<\/span><\/p>\n\n\n\n\n<p><span style=\"color: #0000ff;\">FROM<\/span> contexts<\/p>\n\n\n\n\n<p><span style=\"color: #0000ff;\">WHERE<\/span> name = <span style=\"color: #99cc00;\">'CacheMemoryContext'<\/span><\/p>\n\n\n\n\n<p>&nbsp;<\/p>\n\n\n\n\n<p><span style=\"color: #3366ff;\">UNION ALL<\/span><\/p>\n\n\n\n\n<p><span style=\"color: #3366ff;\">SELECT<\/span> contexts.<span style=\"color: #b8860b;\">*<\/span><\/p>\n\n\n\n\n<p><span style=\"color: #3366ff;\">FROM<\/span> caches<\/p>\n\n\n\n\n<p><span style=\"color: #3366ff;\">JOIN<\/span> contexts <span style=\"color: #3366ff;\">ON<\/span> <span style=\"color: #808080;\">(<\/span>contexts.parent = caches.name<span style=\"color: #808080;\">)<\/span><\/p>\n\n\n\n\n<p><span style=\"color: #808080;\">)<\/span><\/p>\n\n\n\n\n<p><span style=\"color: #3366ff;\">SELECT<\/span><\/p>\n\n\n\n\n<p>name, parent,<\/p>\n\n\n\n\n<p><span style=\"color: #ff0000;\">sum<\/span><span style=\"color: #808080;\">(<\/span>total_bytes<span style=\"color: #808080;\">)<\/span> size_bytes,<\/p>\n\n\n\n\n<p>pg_size_pretty<span style=\"color: #808080;\">(<\/span><span style=\"color: #ff0000;\">sum<\/span>(total_bytes<span style=\"color: #808080;\">))<\/span> size_human,<\/p>\n\n\n\n\n<p><span style=\"color: #ff0000;\">count<\/span><span style=\"color: #808080;\">(<\/span><span style=\"color: #b8860b;\">*<\/span><span style=\"color: #808080;\">)<\/span> <span style=\"color: #3366ff;\">AS<\/span> num_contexts<\/p>\n\n\n\n\n<p><span style=\"color: #3366ff;\">FROM<\/span> caches<span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\"><\/span><\/p>\n\n\n\n\n<p><span style=\"color: #3366ff;\">GROUP BY<\/span> name, parent<\/p>\n\n\n\n\n<p><span style=\"color: #3366ff;\">ORDER BY<\/span> <span style=\"color: #ff0000;\">SUM<\/span><span style=\"color: #808080;\">(<\/span>total_bytes<span style=\"color: #808080;\">)<\/span> <span style=\"color: #3366ff;\">DESC<\/span><span style=\"color: #808080;\">;<\/span><\/p>\n\n\n\n\n<ol class=\"c-list\" start=\"4\" style=\"letter-spacing: .05em; line-height: 2em;\">\n\t\n\n<li>foo* \u3068\u3044\u3046\u540d\u524d\u306e\u5168\u3066\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u30af\u30a8\u30ea\uff1a<\/li>\n\n\n<\/ol>\n\n\n\n\n<p><span style=\"color: #3366ff;\">DO<\/span> $$<\/p>\n\n\n\n\n<p><span style=\"color: #3366ff;\">DECLARE<\/span><\/p>\n\n\n\n\n<p>cnt <span style=\"color: #3366ff;\">int<\/span> := <span style=\"color: #993366;\">0<\/span><span style=\"color: #808080;\">;<\/span><\/p>\n\n\n\n\n<p>v record<span style=\"color: #808080;\">;<\/span><\/p>\n\n\n\n\n<p><span style=\"color: #3366ff;\">BEGIN<\/span><\/p>\n\n\n\n\n<p><span style=\"color: #3366ff;\">\u00a0\u00a0\u00a0 FOR<\/span> v <span style=\"color: #b8860b;\">IN<\/span> <span style=\"color: #3366ff;\">SELECT <span style=\"color: #800000;\">*<\/span> FROM<\/span> pg_class <span style=\"color: #3366ff;\">WHERE<\/span> relkind = <span style=\"color: #99cc00;\">'r' <\/span><span style=\"color: #993300;\">and<\/span> relname <span style=\"color: #993300;\">LIKE<\/span> <span style=\"color: #99cc00;\">'foo%'<\/span> <span style=\"color: #3366ff;\">LOOP<\/span><\/p>\n\n\n\n\n<p><span style=\"color: #3366ff;\">EXECUTE<\/span> <span style=\"color: #ff0000;\">format<\/span>(<span style=\"color: #99cc00;\">'SELECT count(*) FROM %s'<\/span>, v.oid::regclass::<span style=\"color: #3366ff;\">text<\/span>)<span style=\"color: #808080;\">;<\/span><\/p>\n\n\n\n\n<p>cnt = cnt <span style=\"color: #993300;\">+<\/span> <span style=\"color: #993366;\">1<\/span><span style=\"color: #808080;\">;<\/span><\/p>\n\n\n\n\n<p><span style=\"color: #3366ff;\">IF<\/span> cnt <span style=\"color: #993300;\">%<\/span>\u00a0<span style=\"color: #993366;\">100<\/span> = <span style=\"color: #993366;\">0<\/span> <span style=\"color: #3366ff;\">THEN<\/span><\/p>\n\n\n\n\n<p><span style=\"color: #3366ff;\"> COMMIT<\/span><span style=\"color: #808080;\">;<\/span><\/p>\n\n\n\n\n<p><span style=\"color: #3366ff;\">END IF<\/span><span style=\"color: #808080;\">;<\/span><\/p>\n\n\n\n\n<p><span style=\"color: #3366ff;\">END LOOP<\/span><span style=\"color: #808080;\">;<\/span><\/p>\n\n\n\n\n<p>RAISE NOTICE <span style=\"color: #99cc00;\">'tables %1'<\/span>, cnt<span style=\"color: #808080;\">;<\/span><\/p>\n\n\n\n\n<p><span style=\"color: #3366ff;\">END<\/span><span style=\"color: #808080;\">;<\/span>$$<span style=\"color: #808080;\">;<\/span><br \/>\n--><\/p>\n<ol class=\"c-list\" start=\"5\" style=\"letter-spacing: .05em; line-height: 2em;\">\n<li>\u3055\u3089\u306b\u60aa\u3044\u3053\u3068\u306b\u3001\u30ab\u30fc\u30bd\u30eb\u306e\u4f7f\u7528\u306a\u3069\u3001\u8907\u6570\u306e\u30af\u30a8\u30ea\u304c\u540c\u6642\u306b\u9032\u884c\u4e2d\u3067\u3042\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\u305f\u3060\u3057\u3001\u591a\u304f\u306e\u30ab\u30fc\u30bd\u30eb\u3092\u540c\u6642\u306b\u4f7f\u7528\u3059\u308b\u3053\u3068\u306f\u4e00\u822c\u7684\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/li>\n<li>\u3053\u308c\u306f\u3001\u3059\u3079\u3066\u306e\u63a5\u7d9a\u304c\u78ba\u7acb\u3055\u308c\u308b\u307e\u3067\u5f85\u6a5f\u3059\u308b\u3088\u3046\u306b\u5909\u66f4\u3055\u308c\u305fpgbench\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002pgbench \u306e\u5909\u66f4\u304c\u306a\u3051\u308c\u3070\u3001\u7279\u306b\u3053\u306e\u8a18\u4e8b\u3067\u8aac\u660e\u3055\u308c\u3066\u3044\u308b\u4fee\u6b63\u306e\u524d\u306b\u3001\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306e\u30b5\u30d6\u30bb\u30c3\u30c8\u304c\u63a5\u7d9a\u3067\u304d\u306a\u3044\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u306e<a class=\"c-hyperlink\" href=\"https:\/\/www.postgresql.org\/message-id\/20200227180100.zyvjwzcpiokfsqm2%40alap3.anarazel.de\" aria-label=\"\u30e1\u30fc\u30ea\u30f3\u30b0\u30ea\u30b9\u30c8\u30dd\u30b9\u30c8\u7d30\u90e8 \">\u30e1\u30fc\u30ea\u30f3\u30b0\u30ea\u30b9\u30c8\u30dd\u30b9\u30c8<\/a>\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li>\n<\/ol>\n<div class=\"m-table\" data-grid=\"container\">\n<div class=\"c-table\">\n<table summary=\"\u30a2\u30a4\u30c9\u30eb\u63a5\u7d9a\u3068\u30a2\u30af\u30c6\u30a3\u30d6\u63a5\u7d9a\u3092\u793a\u3059\u8868\">\n<caption style=\"text-align: left; font-weight: bold;\">\u30a2\u30a4\u30c9\u30eb\u63a5\u7d9a \u5bfe \u30a2\u30af\u30c6\u30a3\u30d6\u63a5\u7d9a\uff1a<\/caption>\n<thead>\n<tr>\n<td><strong>PG Version<\/strong><\/td>\n<td><strong>Idle Connections<\/strong><\/td>\n<td><strong>Active Connections<\/strong><\/td>\n<td><strong>TPS<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>12<\/td>\n<td>0<\/td>\n<td>1<\/td>\n<td>33457<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>100<\/td>\n<td>1<\/td>\n<td>33705<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>1000<\/td>\n<td>1<\/td>\n<td>30558<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>2500<\/td>\n<td>1<\/td>\n<td>26075<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>5000<\/td>\n<td>1<\/td>\n<td>23284<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>10000<\/td>\n<td>1<\/td>\n<td>14496<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>0<\/td>\n<td>48<\/td>\n<td>1032435<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>100<\/td>\n<td>48<\/td>\n<td>960847<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>1000<\/td>\n<td>48<\/td>\n<td>902109<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>2500<\/td>\n<td>48<\/td>\n<td>759723<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>5000<\/td>\n<td>48<\/td>\n<td>702680<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>10000<\/td>\n<td>48<\/td>\n<td>521558<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p><a class=\"c-hyperlink\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/analyzing-the-limits-of-connection-scalability-in-postgres\/ba-p\/1757266#fnref:7\" aria-describedby=\"go to page\">\u21a9\ufe0e<\/a><\/p>\n<div class=\"m-table\" data-grid=\"container\">\n<div class=\"c-table\">\n<table summary=\"\u307b\u3068\u3093\u3069\u304c\u30a2\u30a4\u30c9\u30eb\u63a5\u7d9a \u5bfe \u30a2\u30af\u30c6\u30a3\u30d6\u63a5\u7d9a\u3092\u793a\u3059\u30c6\u30fc\u30d6\u30eb\">\n<caption style=\"text-align: left; font-weight: bold;\">\u307b\u3068\u3093\u3069\u304c\u30a2\u30a4\u30c9\u30eb\u63a5\u7d9a \u5bfe \u30a2\u30af\u30c6\u30a3\u30d6\u63a5\u7d9a\uff1a<\/caption>\n<thead>\n<tr>\n<td><strong>PG Version<\/strong><\/td>\n<td><strong>Less active Connections<\/strong><\/td>\n<td><strong>Active Connections<\/strong><\/td>\n<td><strong>TPS<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>12<\/td>\n<td>0<\/td>\n<td>1<\/td>\n<td>33773<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>100<\/td>\n<td>1<\/td>\n<td>29074<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>1000<\/td>\n<td>1<\/td>\n<td>25327<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>2500<\/td>\n<td>1<\/td>\n<td>19752<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>5000<\/td>\n<td>1<\/td>\n<td>9807<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>10000<\/td>\n<td>1<\/td>\n<td>6049<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>0<\/td>\n<td>48<\/td>\n<td>1040616<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>100<\/td>\n<td>48<\/td>\n<td>953755<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>1000<\/td>\n<td>48<\/td>\n<td>759366<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>2500<\/td>\n<td>48<\/td>\n<td>733000<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>5000<\/td>\n<td>48<\/td>\n<td>636057<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>10000<\/td>\n<td>48<\/td>\n<td>416819<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u203b\u672c\u30d6\u30ed\u30b0\u306f\u3001Microsoft Tech Community Blog \u2018\u2019Analyzing the Limits of Connection Scalability in Postgres &#8211; Micr [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6,72,5],"tags":[61,62,63,64,66,67,68,69,70,71],"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/posts\/952"}],"collection":[{"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/comments?post=952"}],"version-history":[{"count":52,"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/posts\/952\/revisions"}],"predecessor-version":[{"id":7264,"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/posts\/952\/revisions\/7264"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/media?parent=952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/categories?post=952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/tags?post=952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}