{"id":299,"date":"2026-01-25T02:19:26","date_gmt":"2026-01-24T18:19:26","guid":{"rendered":"https:\/\/skwp.zeabur.app\/2026\/01\/25\/%e3%80%90asyncpg-%e6%95%99%e5%ad%b8%e3%80%9102-%e9%80%a3%e7%b7%9a%e7%ae%a1%e7%90%86%ef%bc%9aconnection-pool-%e5%af%a6%e6%88%b0\/"},"modified":"2026-01-25T02:19:26","modified_gmt":"2026-01-24T18:19:26","slug":"%e3%80%90asyncpg-%e6%95%99%e5%ad%b8%e3%80%9102-%e9%80%a3%e7%b7%9a%e7%ae%a1%e7%90%86%ef%bc%9aconnection-pool-%e5%af%a6%e6%88%b0","status":"publish","type":"post","link":"https:\/\/blog.itsmygo.uk\/wordpress\/2026\/01\/25\/%e3%80%90asyncpg-%e6%95%99%e5%ad%b8%e3%80%9102-%e9%80%a3%e7%b7%9a%e7%ae%a1%e7%90%86%ef%bc%9aconnection-pool-%e5%af%a6%e6%88%b0\/","title":{"rendered":"\u3010asyncpg \u6559\u5b78\u3011#02 \u9023\u7dda\u7ba1\u7406\uff1aConnection Pool \u5be6\u6230"},"content":{"rendered":"\n<div id=\"quiz-basic\">\n<style>\n#quiz-basic .question {\n        background: white;\n        border-radius: 8px;\n        padding: 20px;\n        margin: 20px 0;\n        box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);\n      }#quiz-basic .question h3 {\n        margin-top: 0;\n        color: #333;\n      }#quiz-basic .options {\n        list-style: none;\n        padding: 0;\n      }#quiz-basic .options li {\n        padding: 12px 15px;\n        margin: 8px 0;\n        border: 2px solid #ddd;\n        border-radius: 6px;\n        cursor: pointer;\n        transition: all 0.2s;\n      }#quiz-basic .options li:hover:not(.disabled) {\n        border-color: #4caf50;\n        background: #f0fff0;\n      }#quiz-basic .options li.correct {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-basic .options li.wrong {\n        border-color: #f44336;\n        background: #ffebee;\n      }#quiz-basic .options li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-basic .options li.show-answer {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-basic .feedback {\n        margin-top: 15px;\n        padding: 12px;\n        border-radius: 6px;\n        display: none;\n      }#quiz-basic .feedback.correct {\n        background: #e8f5e9;\n        color: #2e7d32;\n        display: block;\n      }#quiz-basic .feedback.wrong {\n        background: #ffebee;\n        color: #c62828;\n        display: block;\n      }#quiz-basic .score {\n        text-align: center;\n        font-size: 1.5em;\n        padding: 20px;\n        background: white;\n        border-radius: 8px;\n        margin-top: 20px;\n      }#quiz-basic .code-block {\n        background: #1e1e1e;\n        color: #d4d4d4;\n        padding: 14px;\n        border-radius: 6px;\n        font-family: \"Monaco\", \"Consolas\", \"Courier New\", monospace;\n        font-size: 0.9em;\n        overflow-x: auto;\n        margin: 12px 0;\n        white-space: pre-wrap;\n      }\n<\/style>\n<h1>\u6e2c\u9a57\uff1aasyncpg \u9023\u7dda\u6c60 Connection Pool \u5be6\u6230<\/h1>\n    <p>\u5171 5 \u984c\uff0c\u9ede\u9078\u7b54\u6848\u5f8c\u6703\u7acb\u5373\u986f\u793a\u7d50\u679c<\/p>\n\n    <div class=\"question\" id=\"q1\">\n      <h3>1. \u70ba\u4ec0\u9ebc\u5728\u9ad8\u4e26\u767c\u7684 Web API \u4e2d\uff0c\u55ae\u4e00\u8cc7\u6599\u5eab\u9023\u7dda\u4e0d\u5920\u7528\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(1, 'A', 'B')\">A. \u56e0\u70ba\u55ae\u4e00\u9023\u7dda\u7121\u6cd5\u57f7\u884c SQL \u67e5\u8a62<\/li>\n        <li onclick=\"checkAnswer(1, 'B', 'B')\">B. \u56e0\u70ba\u591a\u500b\u8acb\u6c42\u5fc5\u9808\u6392\u968a\u7b49\u5f85\u540c\u4e00\u689d\u9023\u7dda\uff0c\u9020\u6210\u6548\u80fd\u74f6\u9838<\/li>\n        <li onclick=\"checkAnswer(1, 'C', 'B')\">C. \u56e0\u70ba asyncpg \u4e0d\u652f\u63f4\u55ae\u4e00\u9023\u7dda\u6a21\u5f0f<\/li>\n        <li onclick=\"checkAnswer(1, 'D', 'B')\">D. \u56e0\u70ba\u55ae\u4e00\u9023\u7dda\u7121\u6cd5\u4f7f\u7528 async\/await \u8a9e\u6cd5<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb1\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q2\">\n      <h3>2. \u4f7f\u7528 asyncpg \u5efa\u7acb\u9023\u7dda\u6c60\u6642\uff0c\u61c9\u8a72\u4f7f\u7528\u54ea\u500b\u51fd\u6578\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(2, 'A', 'C')\">A. <code>asyncpg.connect()<\/code><\/li>\n        <li onclick=\"checkAnswer(2, 'B', 'C')\">B. <code>asyncpg.pool()<\/code><\/li>\n        <li onclick=\"checkAnswer(2, 'C', 'C')\">C. <code>asyncpg.create_pool()<\/code><\/li>\n        <li onclick=\"checkAnswer(2, 'D', 'C')\">D. <code>asyncpg.new_pool()<\/code><\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb2\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q3\">\n      <h3>3. \u5f9e\u9023\u7dda\u6c60\u53d6\u5f97\u9023\u7dda\u7684\u63a8\u85a6\u65b9\u5f0f\u662f\u4ec0\u9ebc\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(3, 'A', 'A')\">A. \u4f7f\u7528 <code>async with pool.acquire()<\/code><\/li>\n        <li onclick=\"checkAnswer(3, 'B', 'A')\">B. \u76f4\u63a5\u547c\u53eb <code>pool.get_connection()<\/code><\/li>\n        <li onclick=\"checkAnswer(3, 'C', 'A')\">C. \u4f7f\u7528 <code>pool.borrow()<\/code><\/li>\n        <li onclick=\"checkAnswer(3, 'D', 'A')\">D. \u6bcf\u6b21\u90fd\u547c\u53eb <code>asyncpg.connect()<\/code><\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb3\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q4\">\n      <h3>4. \u95dc\u65bc\u9023\u7dda\u6c60\u7684 <code>min_size<\/code> \u548c <code>max_size<\/code> \u53c3\u6578\uff0c\u4e0b\u5217\u6558\u8ff0\u4f55\u8005\u6b63\u78ba\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(4, 'A', 'B')\">A. <code>min_size<\/code> \u662f\u9023\u7dda\u6c60\u6700\u591a\u53ef\u5efa\u7acb\u7684\u9023\u7dda\u6578<\/li>\n        <li onclick=\"checkAnswer(4, 'B', 'B')\">B. <code>min_size<\/code> \u662f\u9023\u7dda\u6c60\u9810\u5148\u5efa\u7acb\u4e26\u4fdd\u6301\u7684\u6700\u5c11\u9023\u7dda\u6578<\/li>\n        <li onclick=\"checkAnswer(4, 'C', 'B')\">C. <code>max_size<\/code> \u662f\u9023\u7dda\u6c60\u555f\u52d5\u6642\u5efa\u7acb\u7684\u9023\u7dda\u6578<\/li>\n        <li onclick=\"checkAnswer(4, 'D', 'B')\">D. \u9019\u5169\u500b\u53c3\u6578\u7684\u503c\u5fc5\u9808\u76f8\u540c<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb4\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q5\">\n      <h3>5. \u5728 FastAPI \u4e2d\u6574\u5408 asyncpg \u9023\u7dda\u6c60\u6642\uff0c\u9023\u7dda\u6c60\u61c9\u8a72\u5728\u4ec0\u9ebc\u6642\u6a5f\u5efa\u7acb\u548c\u95dc\u9589\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(5, 'A', 'C')\">A. \u5728\u6bcf\u500b endpoint \u51fd\u6578\u5167\u5efa\u7acb\u548c\u95dc\u9589<\/li>\n        <li onclick=\"checkAnswer(5, 'B', 'C')\">B. \u5728\u5168\u57df\u8b8a\u6578\u5ba3\u544a\u6642\u5efa\u7acb\uff0c\u6c38\u4e0d\u95dc\u9589<\/li>\n        <li onclick=\"checkAnswer(5, 'C', 'C')\">C. \u5728\u61c9\u7528\u7a0b\u5f0f\u555f\u52d5\u6642\u5efa\u7acb\uff08lifespan\uff09\uff0c\u95dc\u9589\u6642\u91cb\u653e<\/li>\n        <li onclick=\"checkAnswer(5, 'D', 'C')\">D. \u7531 FastAPI \u81ea\u52d5\u7ba1\u7406\uff0c\u4e0d\u9700\u8981\u624b\u52d5\u8655\u7406<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb5\"><\/div>\n    <\/div>\n\n    <div class=\"score\" id=\"score\" style=\"display:none;\"><\/div>\n<script>\n\n      let answered = 0;\n      let correct = 0;\n      const total = 5;\n      const explanations = {\n        1: \"\u7576\u53ea\u6709\u4e00\u689d\u9023\u7dda\u6642\uff0c\u6240\u6709\u4e26\u767c\u8acb\u6c42\u90fd\u5fc5\u9808\u6392\u968a\u7b49\u5f85\uff0c\u9020\u6210\u6548\u80fd\u74f6\u9838\u3002\u6b64\u5916\uff0c\u5982\u679c\u9019\u689d\u9023\u7dda\u65b7\u4e86\uff0c\u6574\u500b\u670d\u52d9\u5c31\u6703\u4e2d\u65b7\u3002\",\n        2: \"<code>asyncpg.create_pool()<\/code> \u662f asyncpg \u63d0\u4f9b\u7528\u4f86\u5efa\u7acb\u9023\u7dda\u6c60\u7684\u51fd\u6578\uff0c\u53ef\u4ee5\u6307\u5b9a min_size\u3001max_size \u7b49\u53c3\u6578\u3002\",\n        3: \"\u4f7f\u7528 <code>async with pool.acquire()<\/code> \u662f\u6700\u5b89\u5168\u7684\u65b9\u5f0f\uff0c\u56e0\u70ba\u9023\u7dda\u4e00\u5b9a\u6703\u88ab\u6b78\u9084\uff08\u5373\u4f7f\u767c\u751f\u4f8b\u5916\uff09\uff0c\u4e0d\u9700\u8981\u624b\u52d5\u7ba1\u7406\u9023\u7dda\u7684\u751f\u547d\u9031\u671f\u3002\",\n        4: \"<code>min_size<\/code> \u6307\u5b9a\u9023\u7dda\u6c60\u9810\u5148\u5efa\u7acb\u4e26\u4fdd\u6301\u7684\u6700\u5c11\u9023\u7dda\u6578\uff0c\u9019\u4e9b\u9023\u7dda\u96a8\u6642\u5f85\u547d\uff1b<code>max_size<\/code> \u662f\u7576\u6240\u6709\u9023\u7dda\u90fd\u88ab\u501f\u8d70\u6642\uff0c\u6700\u591a\u53ef\u4ee5\u518d\u5efa\u7acb\u5230\u7684\u6578\u91cf\u3002\",\n        5: \"\u5728 FastAPI \u4e2d\u61c9\u8a72\u4f7f\u7528 lifespan context manager\uff0c\u5728\u61c9\u7528\u7a0b\u5f0f\u555f\u52d5\u6642\u5efa\u7acb\u9023\u7dda\u6c60\uff0c\u95dc\u9589\u6642\u91cb\u653e\u9023\u7dda\u6c60\uff0c\u78ba\u4fdd\u9023\u7dda\u6c60\u7684\u751f\u547d\u9031\u671f\u8207\u61c9\u7528\u7a0b\u5f0f\u4e00\u81f4\u3002\"\n      };\n\n      function checkAnswer(qNum, selected, correctAns) {\n        const question = document.getElementById(\"q\" + qNum);\n        if (question.classList.contains(\"answered\")) return;\n\n        question.classList.add(\"answered\");\n        answered++;\n\n        const options = question.querySelectorAll(\".options li\");\n        options.forEach((opt) => {\n          opt.classList.add(\"disabled\");\n          if (opt.textContent.startsWith(correctAns + \".\")) {\n            opt.classList.add(\"show-answer\");\n          }\n        });\n\n        const feedback = document.getElementById(\"fb\" + qNum);\n        if (selected === correctAns) {\n          correct++;\n          feedback.className = \"feedback correct\";\n          feedback.innerHTML = \"\u2713 \u6b63\u78ba\uff01\" + explanations[qNum];\n        } else {\n          feedback.className = \"feedback wrong\";\n          feedback.innerHTML =\n            \"\u2717 \u932f\u8aa4\u3002\u6b63\u78ba\u7b54\u6848\u662f \" + correctAns + \"\u3002\" + explanations[qNum];\n          options.forEach((opt) => {\n            if (opt.textContent.startsWith(selected + \".\")) {\n              opt.classList.add(\"wrong\");\n            }\n          });\n        }\n\n        if (answered === total) {\n          const scoreDiv = document.getElementById(\"score\");\n          scoreDiv.style.display = \"block\";\n          scoreDiv.innerHTML =\n            \"\u6e2c\u9a57\u5b8c\u6210\uff01\u5f97\u5206\uff1a\" +\n            correct +\n            \" \/ \" +\n            total +\n            (correct === total\n              ? \" \ud83c\udf89 \u5168\u5c0d\uff01\"\n              : correct >= Math.ceil(total * 0.6)\n                ? \" \ud83d\udc4d \u4e0d\u932f\uff01\"\n                : \" \ud83d\udcda \u518d\u8907\u7fd2\u4e00\u4e0b\u5427\");\n        }\n      }\n    \n<\/script>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u524d\u8a00<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728\u4e0a\u4e00\u7bc7\u6587\u7ae0\u4e2d\uff0c\u6211\u5011\u5b78\u6703\u4e86\u4f7f\u7528 <code>asyncpg.connect()<\/code> \u5efa\u7acb\u55ae\u4e00\u9023\u7dda\u3002\u4f46\u5728\u771f\u5be6\u7684\u61c9\u7528\u5834\u666f\u4e2d\uff0c\u55ae\u4e00\u9023\u7dda\u5f80\u5f80\u4e0d\u5920\u7528\u3002\u9019\u7bc7\u6587\u7ae0\u5c07\u5e36\u4f60\u7406\u89e3\u9023\u7dda\u6c60\uff08Connection Pool\uff09\u7684\u6982\u5ff5\uff0c\u4ee5\u53ca\u5982\u4f55\u5728 asyncpg \u4e2d\u6b63\u78ba\u4f7f\u7528\u5b83\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u5b78\u7fd2\u76ee\u6a19<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u8b80\u5b8c\u672c\u7bc7\u5f8c\uff0c\u4f60\u5c07\u80fd\u5920\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u7406\u89e3\u70ba\u4ec0\u9ebc\u9700\u8981\u9023\u7dda\u6c60\uff08Connection Pool\uff09<\/li>\n<li>\u6b63\u78ba\u5efa\u7acb\u8207\u914d\u7f6e asyncpg \u9023\u7dda\u6c60<\/li>\n<li>\u4f7f\u7528 async with \u5b89\u5168\u5730\u53d6\u5f97\u8207\u91cb\u653e\u9023\u7dda<\/li>\n<li>\u8a2d\u5b9a\u9023\u7dda\u6c60\u7684\u5927\u5c0f\u8207\u903e\u6642\u53c3\u6578<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u70ba\u4ec0\u9ebc\u55ae\u4e00\u9023\u7dda\u4e0d\u5920\u7528\uff1f<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u5047\u8a2d\u4f60\u6709\u4e00\u500b Web API\uff0c\u540c\u6642\u6709 100 \u500b\u4f7f\u7528\u8005\u767c\u9001\u8acb\u6c42\u3002\u5982\u679c\u53ea\u6709\u4e00\u689d\u9023\u7dda\uff0c\u6703\u767c\u751f\u4ec0\u9ebc\u4e8b\uff1f<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-comment\"># \u9019\u662f\u6709\u554f\u984c\u7684\u505a\u6cd5<\/span>\nconn = await asyncpg.connect(...)  <span class=\"hljs-comment\"># \u53ea\u6709\u4e00\u689d\u9023\u7dda<\/span>\n\nasync def handle_request():\n    <span class=\"hljs-comment\"># \u6240\u6709\u8acb\u6c42\u90fd\u6436\u9019\u4e00\u689d\u9023\u7dda<\/span>\n    result = await conn.fetch(<span class=\"hljs-string\">\"SELECT * FROM users\"<\/span>)\n    <span class=\"hljs-keyword\">return<\/span> result\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u554f\u984c\u5728\u65bc\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u6548\u80fd\u74f6\u9838<\/strong>\uff1a100 \u500b\u8acb\u6c42\u5fc5\u9808\u6392\u968a\u7b49\u5f85\u540c\u4e00\u689d\u9023\u7dda<\/li>\n<li><strong>\u9023\u7dda\u65b7\u7dda\u98a8\u96aa<\/strong>\uff1a\u5982\u679c\u9019\u689d\u9023\u7dda\u65b7\u4e86\uff0c\u6574\u500b\u670d\u52d9\u5c31\u639b\u4e86<\/li>\n<li><strong>\u8cc7\u6e90\u6d6a\u8cbb<\/strong>\uff1a\u8cc7\u6599\u5eab\u660e\u660e\u53ef\u4ee5\u8655\u7406\u591a\u500b\u9023\u7dda\uff0c\u537b\u53ea\u7528\u4e00\u689d<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Connection Pool \u662f\u4ec0\u9ebc\uff1f<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u9023\u7dda\u6c60\u5c31\u50cf\u662f\u4e00\u500b\u300c\u9023\u7dda\u7684\u5009\u5eab\u300d\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u9810\u5148\u5efa\u7acb\u591a\u689d\u9023\u7dda\u653e\u5728\u5009\u5eab\u88e1<\/li>\n<li>\u9700\u8981\u6642\u5f9e\u5009\u5eab\u501f\u4e00\u689d\u51fa\u4f86\u7528<\/li>\n<li>\u7528\u5b8c\u6b78\u9084\uff0c\u8b93\u5176\u4ed6\u4eba\u53ef\u4ee5\u4f7f\u7528<\/li>\n<\/ul>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n\u2502           Connection Pool           \u2502\n\u2502  \u250c\u2500\u2500\u2500\u2500\u2510 \u250c\u2500\u2500\u2500\u2500\u2510 \u250c\u2500\u2500\u2500\u2500\u2510 \u250c\u2500\u2500\u2500\u2500\u2510       \u2502\n\u2502  \u2502conn\u2502 \u2502conn\u2502 \u2502conn\u2502 \u2502conn\u2502 ...   \u2502\n\u2502  \u2514\u2500\u2500\u2500\u2500\u2518 \u2514\u2500\u2500\u2500\u2500\u2518 \u2514\u2500\u2500\u2500\u2500\u2518 \u2514\u2500\u2500\u2500\u2500\u2518       \u2502\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n     \u2191         \u2191\n  acquire   release\n     \u2502         \u2502\n   \u4f7f\u7528\u4e2d    \u6b78\u9084\n<\/code><\/span><\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u5efa\u7acb\u9023\u7dda\u6c60\uff1acreate_pool()<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">asyncpg \u63d0\u4f9b <code>create_pool()<\/code> \u51fd\u6578\u4f86\u5efa\u7acb\u9023\u7dda\u6c60\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">import asyncpg\nimport asyncio\n\nasync def main():\n    <span class=\"hljs-comment\"># \u5efa\u7acb\u9023\u7dda\u6c60<\/span>\n    pool = await asyncpg.create_pool(\n        host=<span class=\"hljs-string\">'localhost'<\/span>,\n        port=<span class=\"hljs-number\">5432<\/span>,\n        user=<span class=\"hljs-string\">'postgres'<\/span>,\n        password=<span class=\"hljs-string\">'password'<\/span>,\n        database=<span class=\"hljs-string\">'mydb'<\/span>,\n        min_size=<span class=\"hljs-number\">5<\/span>,      <span class=\"hljs-comment\"># \u6700\u5c11\u4fdd\u6301 5 \u689d\u9023\u7dda<\/span>\n        max_size=<span class=\"hljs-number\">20<\/span>,     <span class=\"hljs-comment\"># \u6700\u591a\u5efa\u7acb 20 \u689d\u9023\u7dda<\/span>\n    )\n\n    <span class=\"hljs-comment\"># \u4f7f\u7528\u9023\u7dda\u6c60...<\/span>\n\n    <span class=\"hljs-comment\"># \u95dc\u9589\u9023\u7dda\u6c60<\/span>\n    await pool.close()\n\nasyncio.run(main())\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u4e5f\u53ef\u4ee5\u4f7f\u7528\u9023\u7dda\u5b57\u4e32\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">pool = <span class=\"hljs-keyword\">await<\/span> asyncpg.create_pool(\n    <span class=\"hljs-string\">'postgresql:\/\/postgres:password@localhost:5432\/mydb'<\/span>,\n    min_size=<span class=\"hljs-number\">5<\/span>,\n    max_size=<span class=\"hljs-number\">20<\/span>,\n)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u5f9e\u9023\u7dda\u6c60\u53d6\u5f97\u9023\u7dda<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u6709\u5169\u7a2e\u65b9\u5f0f\u53ef\u4ee5\u5f9e\u9023\u7dda\u6c60\u53d6\u5f97\u9023\u7dda\uff1a<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u65b9\u5f0f\u4e00\uff1a\u4f7f\u7528 async with\uff08\u63a8\u85a6\uff09<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">async with pool.acquire() <span class=\"hljs-keyword\">as<\/span> conn:\n    <span class=\"hljs-comment\"># \u5728\u9019\u500b\u5340\u584a\u5167\u4f7f\u7528 conn<\/span>\n    result = await conn.fetch(<span class=\"hljs-string\">\"SELECT * FROM users\"<\/span>)\n    <span class=\"hljs-comment\"># \u96e2\u958b\u5340\u584a\u6642\uff0c\u9023\u7dda\u81ea\u52d5\u6b78\u9084\u7d66\u9023\u7dda\u6c60<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u9019\u662f\u6700\u5b89\u5168\u7684\u65b9\u5f0f\uff0c\u56e0\u70ba\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u9023\u7dda\u4e00\u5b9a\u6703\u88ab\u6b78\u9084\uff08\u5373\u4f7f\u767c\u751f\u4f8b\u5916\uff09<\/li>\n<li>\u4e0d\u9700\u8981\u624b\u52d5\u7ba1\u7406\u9023\u7dda\u7684\u751f\u547d\u9031\u671f<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u65b9\u5f0f\u4e8c\uff1a\u624b\u52d5 acquire\/release<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">conn = <span class=\"hljs-keyword\">await<\/span> pool.acquire()\n<span class=\"hljs-attr\">try<\/span>:\n    result = <span class=\"hljs-keyword\">await<\/span> conn.fetch(<span class=\"hljs-string\">\"SELECT * FROM users\"<\/span>)\n<span class=\"hljs-attr\">finally<\/span>:\n    <span class=\"hljs-keyword\">await<\/span> pool.release(conn)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u9019\u7a2e\u65b9\u5f0f\u6bd4\u8f03\u5bb9\u6613\u51fa\u932f\uff0c\u5efa\u8b70\u9664\u975e\u6709\u7279\u6b8a\u9700\u6c42\uff0c\u5426\u5247\u512a\u5148\u4f7f\u7528 <code>async with<\/code>\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u9023\u7dda\u6c60\u7684\u751f\u547d\u9031\u671f\u7ba1\u7406<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b8c\u6574\u7684\u9023\u7dda\u6c60\u751f\u547d\u9031\u671f\u5982\u4e0b\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">import asyncpg\nimport asyncio\n\nasync def main():\n    <span class=\"hljs-comment\"># 1. \u5efa\u7acb\u9023\u7dda\u6c60<\/span>\n    pool = await asyncpg.create_pool(\n        <span class=\"hljs-string\">'postgresql:\/\/postgres:password@localhost:5432\/mydb'<\/span>,\n        min_size=<span class=\"hljs-number\">2<\/span>,\n        max_size=<span class=\"hljs-number\">10<\/span>,\n    )\n\n    <span class=\"hljs-keyword\">try<\/span>:\n        <span class=\"hljs-comment\"># 2. \u4f7f\u7528\u9023\u7dda\u6c60\u57f7\u884c\u67e5\u8a62<\/span>\n        async with pool.acquire() <span class=\"hljs-keyword\">as<\/span> conn:\n            rows = await conn.fetch(<span class=\"hljs-string\">\"SELECT * FROM users LIMIT 5\"<\/span>)\n            <span class=\"hljs-keyword\">for<\/span> row in rows:\n                <span class=\"hljs-keyword\">print<\/span>(dict(row))\n    <span class=\"hljs-keyword\">finally<\/span>:\n        <span class=\"hljs-comment\"># 3. \u95dc\u9589\u9023\u7dda\u6c60\uff08\u91cd\u8981\uff01\uff09<\/span>\n        await pool.close()\n\nasyncio.run(main())\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u4e5f\u53ef\u4ee5\u628a\u9023\u7dda\u6c60\u672c\u8eab\u7576\u4f5c context manager\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-7\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">async def main():\n    async with asyncpg.create_pool(...) <span class=\"hljs-keyword\">as<\/span> pool:\n        async with pool.acquire() <span class=\"hljs-keyword\">as<\/span> conn:\n            result = await conn.fetch(<span class=\"hljs-string\">\"SELECT 1\"<\/span>)\n    <span class=\"hljs-comment\"># \u96e2\u958b\u5340\u584a\u6642\uff0c\u9023\u7dda\u6c60\u81ea\u52d5\u95dc\u9589<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u91cd\u8981\u53c3\u6578\u8aaa\u660e<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">min_size \u8207 max_size<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-8\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">pool = await asyncpg.create_pool(\n    ...,\n    min_size=<span class=\"hljs-number\">5<\/span>,   <span class=\"hljs-comment\"># \u9023\u7dda\u6c60\u6700\u5c11\u4fdd\u6301\u7684\u9023\u7dda\u6578<\/span>\n    max_size=<span class=\"hljs-number\">20<\/span>,  <span class=\"hljs-comment\"># \u9023\u7dda\u6c60\u6700\u591a\u53ef\u5efa\u7acb\u7684\u9023\u7dda\u6578<\/span>\n)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-8\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><code>min_size<\/code>\uff1a\u9023\u7dda\u6c60\u6703\u9810\u5148\u5efa\u7acb\u9019\u9ebc\u591a\u9023\u7dda\uff0c\u96a8\u6642\u5f85\u547d<\/li>\n<li><code>max_size<\/code>\uff1a\u7576\u6240\u6709\u9023\u7dda\u90fd\u88ab\u501f\u8d70\uff0c\u6700\u591a\u53ef\u4ee5\u518d\u5efa\u7acb\u5230\u9019\u500b\u6578\u91cf<\/li>\n<li>\u7576\u9023\u7dda\u9592\u7f6e\u904e\u4e45\uff0c\u6703\u7e2e\u6e1b\u56de <code>min_size<\/code><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u8abf\u6821\u5efa\u8b70<\/strong>\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>min_size<\/code>\uff1a\u8a2d\u70ba\u5e73\u6642\u7684\u5e73\u5747\u4e26\u767c\u6578<\/li>\n<li><code>max_size<\/code>\uff1a\u8a2d\u70ba\u5c16\u5cf0\u6642\u671f\u7684\u6700\u5927\u4e26\u767c\u6578<\/li>\n<li>\u901a\u5e38 <code>min<em>size<\/code> \u8a2d 5-10\uff0c<code>max<\/em>size<\/code> \u8a2d 20-50<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">command_timeout<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-9\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">pool = await asyncpg.create_pool(\n    ...,\n    command_timeout=<span class=\"hljs-number\">60<\/span>,  <span class=\"hljs-comment\"># \u55ae\u4f4d\uff1a\u79d2<\/span>\n)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-9\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u55ae\u4e00 SQL \u6307\u4ee4\u7684\u57f7\u884c\u6642\u9593\u4e0a\u9650\u3002\u8d85\u904e\u6642\u9593\u6703\u62cb\u51fa <code>asyncpg.exceptions.QueryCanceledError<\/code>\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">timeout\uff08acquire \u903e\u6642\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u7576\u6240\u6709\u9023\u7dda\u90fd\u88ab\u501f\u8d70\uff0c\u65b0\u7684 <code>acquire()<\/code> \u8981\u7b49\u5f85\u3002\u53ef\u4ee5\u8a2d\u5b9a\u7b49\u5f85\u7684\u4e0a\u9650\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-10\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-keyword\">try<\/span>:\n    <span class=\"hljs-comment\"># \u6700\u591a\u7b49\u5f85 10 \u79d2<\/span>\n    async with pool.acquire(timeout=<span class=\"hljs-number\">10<\/span>) <span class=\"hljs-keyword\">as<\/span> conn:\n        result = await conn.fetch(<span class=\"hljs-string\">\"SELECT 1\"<\/span>)\nexcept asyncio.TimeoutError:\n    <span class=\"hljs-keyword\">print<\/span>(<span class=\"hljs-string\">\"\u7121\u6cd5\u53d6\u5f97\u9023\u7dda\uff0c\u9023\u7dda\u6c60\u5df2\u6eff\"<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-10\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u9023\u7dda\u6c60\u7684\u72c0\u614b\u76e3\u63a7<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">asyncpg \u9023\u7dda\u6c60\u63d0\u4f9b\u5e7e\u500b\u6709\u7528\u7684\u5c6c\u6027\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-11\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">pool = await asyncpg.create_pool(...)\n\n<span class=\"hljs-comment\"># \u67e5\u770b\u9023\u7dda\u6c60\u72c0\u614b<\/span>\n<span class=\"hljs-keyword\">print<\/span>(f<span class=\"hljs-string\">\"\u9023\u7dda\u6c60\u5927\u5c0f: {pool.get_size()}\"<\/span>)        <span class=\"hljs-comment\"># \u76ee\u524d\u7e3d\u9023\u7dda\u6578<\/span>\n<span class=\"hljs-keyword\">print<\/span>(f<span class=\"hljs-string\">\"\u9592\u7f6e\u9023\u7dda\u6578: {pool.get_idle_size()}\"<\/span>)   <span class=\"hljs-comment\"># \u53ef\u7528\u7684\u9023\u7dda\u6578<\/span>\n<span class=\"hljs-keyword\">print<\/span>(f<span class=\"hljs-string\">\"\u6700\u5c0f\u9023\u7dda\u6578: {pool.get_min_size()}\"<\/span>)    <span class=\"hljs-comment\"># min_size \u8a2d\u5b9a\u503c<\/span>\n<span class=\"hljs-keyword\">print<\/span>(f<span class=\"hljs-string\">\"\u6700\u5927\u9023\u7dda\u6578: {pool.get_max_size()}\"<\/span>)    <span class=\"hljs-comment\"># max_size \u8a2d\u5b9a\u503c<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-11\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u9019\u5c0d\u65bc\u76e3\u63a7\u548c\u9664\u932f\u975e\u5e38\u6709\u7528\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u6574\u5408 FastAPI \u7684\u6700\u4f73\u5be6\u8e10<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728 FastAPI \u4e2d\u4f7f\u7528 asyncpg \u9023\u7dda\u6c60\u7684\u63a8\u85a6\u6a21\u5f0f\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-12\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">from contextlib import asynccontextmanager\nfrom fastapi import FastAPI, Depends\nimport asyncpg\n\n<span class=\"hljs-comment\"># \u5168\u57df\u8b8a\u6578\u5b58\u653e\u9023\u7dda\u6c60<\/span>\npool: asyncpg.Pool | None = None\n\n@asynccontextmanager\nasync def lifespan(app: FastAPI):\n    <span class=\"hljs-comment\"># \u555f\u52d5\u6642\u5efa\u7acb\u9023\u7dda\u6c60<\/span>\n    <span class=\"hljs-keyword\">global<\/span> pool\n    pool = await asyncpg.create_pool(\n        <span class=\"hljs-string\">'postgresql:\/\/postgres:password@localhost:5432\/mydb'<\/span>,\n        min_size=<span class=\"hljs-number\">5<\/span>,\n        max_size=<span class=\"hljs-number\">20<\/span>,\n    )\n    <span class=\"hljs-keyword\">print<\/span>(<span class=\"hljs-string\">\"\u9023\u7dda\u6c60\u5df2\u5efa\u7acb\"<\/span>)\n\n    <span class=\"hljs-keyword\">yield<\/span>  <span class=\"hljs-comment\"># \u61c9\u7528\u7a0b\u5f0f\u904b\u884c\u4e2d<\/span>\n\n    <span class=\"hljs-comment\"># \u95dc\u9589\u6642\u91cb\u653e\u9023\u7dda\u6c60<\/span>\n    await pool.close()\n    <span class=\"hljs-keyword\">print<\/span>(<span class=\"hljs-string\">\"\u9023\u7dda\u6c60\u5df2\u95dc\u9589\"<\/span>)\n\napp = FastAPI(lifespan=lifespan)\n\n<span class=\"hljs-comment\"># \u4f9d\u8cf4\u6ce8\u5165\uff1a\u53d6\u5f97\u9023\u7dda<\/span>\nasync def get_conn():\n    async with pool.acquire() <span class=\"hljs-keyword\">as<\/span> conn:\n        <span class=\"hljs-keyword\">yield<\/span> conn\n\n@app.get(<span class=\"hljs-string\">\"\/users\"<\/span>)\nasync def get_users(conn: asyncpg.Connection = Depends(get_conn)):\n    rows = await conn.fetch(<span class=\"hljs-string\">\"SELECT * FROM users LIMIT 10\"<\/span>)\n    <span class=\"hljs-keyword\">return<\/span> &#91;dict(row) <span class=\"hljs-keyword\">for<\/span> row in rows]\n\n@app.get(<span class=\"hljs-string\">\"\/users\/{user_id}\"<\/span>)\nasync def get_user(user_id: int, conn: asyncpg.Connection = Depends(get_conn)):\n    row = await conn.fetchrow(\n        <span class=\"hljs-string\">\"SELECT * FROM users WHERE id = $1\"<\/span>,\n        user_id\n    )\n    <span class=\"hljs-keyword\">if<\/span> row is None:\n        <span class=\"hljs-keyword\">return<\/span> {<span class=\"hljs-string\">\"error\"<\/span>: <span class=\"hljs-string\">\"User not found\"<\/span>}\n    <span class=\"hljs-keyword\">return<\/span> dict(row)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-12\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u9019\u500b\u6a21\u5f0f\u7684\u512a\u9ede\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u751f\u547d\u9031\u671f\u7ba1\u7406<\/strong>\uff1a\u9023\u7dda\u6c60\u96a8 FastAPI \u555f\u52d5\/\u95dc\u9589<\/li>\n<li><strong>\u4f9d\u8cf4\u6ce8\u5165<\/strong>\uff1a\u6bcf\u500b endpoint \u81ea\u52d5\u53d6\u5f97\u9023\u7dda<\/li>\n<li><strong>\u81ea\u52d5\u6b78\u9084<\/strong>\uff1a\u8acb\u6c42\u7d50\u675f\u6642\u9023\u7dda\u81ea\u52d5\u6b78\u9084<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">\u5b8c\u6574\u7bc4\u4f8b<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee5\u4e0b\u662f\u4e00\u500b\u5b8c\u6574\u7684\u7bc4\u4f8b\uff0c\u5c55\u793a\u9023\u7dda\u6c60\u7684\u5404\u7a2e\u64cd\u4f5c\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-13\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">import asyncpg\nimport asyncio\n\nasync def main():\n    <span class=\"hljs-comment\"># \u5efa\u7acb\u9023\u7dda\u6c60<\/span>\n    pool = await asyncpg.create_pool(\n        host=<span class=\"hljs-string\">'localhost'<\/span>,\n        port=<span class=\"hljs-number\">5432<\/span>,\n        user=<span class=\"hljs-string\">'postgres'<\/span>,\n        password=<span class=\"hljs-string\">'password'<\/span>,\n        database=<span class=\"hljs-string\">'mydb'<\/span>,\n        min_size=<span class=\"hljs-number\">2<\/span>,\n        max_size=<span class=\"hljs-number\">10<\/span>,\n        command_timeout=<span class=\"hljs-number\">60<\/span>,\n    )\n\n    <span class=\"hljs-keyword\">print<\/span>(f<span class=\"hljs-string\">\"\u521d\u59cb\u9023\u7dda\u6578: {pool.get_size()}\"<\/span>)\n    <span class=\"hljs-keyword\">print<\/span>(f<span class=\"hljs-string\">\"\u9592\u7f6e\u9023\u7dda\u6578: {pool.get_idle_size()}\"<\/span>)\n\n    <span class=\"hljs-comment\"># \u6a21\u64ec\u591a\u500b\u4e26\u767c\u8acb\u6c42<\/span>\n    async def fetch_data(task_id: int):\n        async with pool.acquire() <span class=\"hljs-keyword\">as<\/span> conn:\n            <span class=\"hljs-keyword\">print<\/span>(f<span class=\"hljs-string\">\"Task {task_id}: \u53d6\u5f97\u9023\u7dda\uff0c\u9592\u7f6e\u6578={pool.get_idle_size()}\"<\/span>)\n            <span class=\"hljs-comment\"># \u6a21\u64ec\u67e5\u8a62\u8017\u6642<\/span>\n            await asyncio.sleep(<span class=\"hljs-number\">1<\/span>)\n            result = await conn.fetchval(<span class=\"hljs-string\">\"SELECT COUNT(*) FROM users\"<\/span>)\n            <span class=\"hljs-keyword\">print<\/span>(f<span class=\"hljs-string\">\"Task {task_id}: \u67e5\u8a62\u5b8c\u6210\uff0c\u5171 {result} \u7b46\"<\/span>)\n            <span class=\"hljs-keyword\">return<\/span> result\n\n    <span class=\"hljs-comment\"># \u540c\u6642\u57f7\u884c 5 \u500b\u67e5\u8a62<\/span>\n    tasks = &#91;fetch_data(i) <span class=\"hljs-keyword\">for<\/span> i in range(<span class=\"hljs-number\">5<\/span>)]\n    results = await asyncio.gather(*tasks)\n\n    <span class=\"hljs-keyword\">print<\/span>(f<span class=\"hljs-string\">\"\u6240\u6709\u67e5\u8a62\u5b8c\u6210: {results}\"<\/span>)\n    <span class=\"hljs-keyword\">print<\/span>(f<span class=\"hljs-string\">\"\u6700\u7d42\u9592\u7f6e\u9023\u7dda\u6578: {pool.get_idle_size()}\"<\/span>)\n\n    <span class=\"hljs-comment\"># \u95dc\u9589\u9023\u7dda\u6c60<\/span>\n    await pool.close()\n\nasyncio.run(main())\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-13\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u5e38\u898b\u932f\u8aa4\u8207\u89e3\u6c7a\u65b9\u6848<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u932f\u8aa4 1\uff1a\u5fd8\u8a18\u95dc\u9589\u9023\u7dda\u6c60<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-14\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-comment\"># \u932f\u8aa4\uff1a\u9023\u7dda\u6c60\u6c92\u6709\u95dc\u9589<\/span>\nasync def main():\n    pool = await asyncpg.create_pool(...)\n    <span class=\"hljs-comment\"># ... \u4f7f\u7528\u9023\u7dda\u6c60 ...<\/span>\n    <span class=\"hljs-comment\"># \u5fd8\u8a18 await pool.close()<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-14\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u89e3\u6c7a\u65b9\u6848\uff1a\u4f7f\u7528 <code>async with<\/code> \u6216 <code>try\/finally<\/code>\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u932f\u8aa4 2\uff1a\u5728\u9023\u7dda\u6c60\u95dc\u9589\u5f8c\u9084\u60f3\u4f7f\u7528<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-15\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-comment\"># \u932f\u8aa4\uff1a\u9023\u7dda\u6c60\u5df2\u95dc\u9589<\/span>\nawait pool.close()\nasync with pool.acquire() <span class=\"hljs-keyword\">as<\/span> conn:  <span class=\"hljs-comment\"># \u6703\u62cb\u51fa\u932f\u8aa4<\/span>\n    ...\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-15\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u89e3\u6c7a\u65b9\u6848\uff1a\u78ba\u4fdd\u9023\u7dda\u6c60\u7684\u751f\u547d\u9031\u671f\u6db5\u84cb\u6240\u6709\u4f7f\u7528\u5b83\u7684\u7a0b\u5f0f\u78bc\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u932f\u8aa4 3\uff1a\u9023\u7dda\u6c60\u8017\u76e1<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u7576 <code>max_size<\/code> \u689d\u9023\u7dda\u90fd\u88ab\u501f\u8d70\uff0c\u65b0\u7684 <code>acquire()<\/code> \u6703\u5361\u4f4f\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-16\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-comment\"># \u53ef\u80fd\u6703\u6c38\u9060\u7b49\u5f85<\/span>\nasync with pool.acquire() <span class=\"hljs-keyword\">as<\/span> conn:\n    ...\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-16\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u89e3\u6c7a\u65b9\u6848\uff1a\u8a2d\u5b9a <code>timeout<\/code> \u53c3\u6578\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-17\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-keyword\">try<\/span>:\n    async with pool.acquire(timeout=<span class=\"hljs-number\">5<\/span>) <span class=\"hljs-keyword\">as<\/span> conn:\n        ...\nexcept asyncio.TimeoutError:\n    <span class=\"hljs-comment\"># \u8655\u7406\u9023\u7dda\u6c60\u6eff\u7684\u60c5\u6cc1<\/span>\n    pass\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-17\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u5c0f\u7d50<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u9019\u7bc7\u6587\u7ae0\u4ecb\u7d39\u4e86 asyncpg \u9023\u7dda\u6c60\u7684\u6838\u5fc3\u6982\u5ff5\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u70ba\u4ec0\u9ebc\u9700\u8981\u9023\u7dda\u6c60<\/strong>\uff1a\u89e3\u6c7a\u55ae\u4e00\u9023\u7dda\u7684\u6548\u80fd\u74f6\u9838\u548c\u53ef\u9760\u6027\u554f\u984c<\/li>\n<li><strong>\u5efa\u7acb\u9023\u7dda\u6c60<\/strong>\uff1a\u4f7f\u7528 <code>asyncpg.create_pool()<\/code> \u5efa\u7acb<\/li>\n<li><strong>\u53d6\u5f97\u9023\u7dda<\/strong>\uff1a\u4f7f\u7528 <code>async with pool.acquire()<\/code> \u5b89\u5168\u5730\u501f\u7528\u9023\u7dda<\/li>\n<li><strong>\u53c3\u6578\u8abf\u6821<\/strong>\uff1a<code>min<em>size<\/code>\u3001<code>max<\/em>size<\/code>\u3001<code>timeout<\/code> \u7684\u8a2d\u5b9a<\/li>\n<li><strong>FastAPI \u6574\u5408<\/strong>\uff1a\u4f7f\u7528 lifespan \u548c\u4f9d\u8cf4\u6ce8\u5165\u7684\u6700\u4f73\u5be6\u8e10<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e0b\u4e00\u7bc7\u6587\u7ae0\u5c07\u4ecb\u7d39\u5982\u4f55\u4f7f\u7528\u9023\u7dda\u6c60\u57f7\u884c\u4ea4\u6613\uff08Transaction\uff09\uff0c\u78ba\u4fdd\u591a\u500b SQL \u64cd\u4f5c\u7684\u539f\u5b50\u6027\u3002<\/p>\n\n\n\n<div id=\"quiz-advanced\">\n<style>\n#quiz-advanced .badge {\n        display: inline-block;\n        padding: 4px 10px;\n        border-radius: 12px;\n        font-size: 0.75em;\n        font-weight: bold;\n        margin-left: 8px;\n      }#quiz-advanced .badge.scenario {\n        background: #ebf8ff;\n        color: #2b6cb0;\n      }#quiz-advanced .badge.debug {\n        background: #fef3c7;\n        color: #92400e;\n      }#quiz-advanced .question-adv {\n        background: white;\n        border-radius: 10px;\n        padding: 24px;\n        margin: 20px 0;\n        box-shadow: 0 2px 8px rgba(0, 0, 0, 0.08);\n        border-left: 4px solid #ed8936;\n      }#quiz-advanced .question-adv h3 {\n        margin-top: 0;\n        color: #2d3748;\n      }#quiz-advanced .code-block {\n        background: #1e1e1e;\n        color: #d4d4d4;\n        padding: 14px;\n        border-radius: 6px;\n        font-family: \"Menlo\", \"Monaco\", \"Courier New\", monospace;\n        font-size: 0.9em;\n        overflow-x: auto;\n        margin: 12px 0;\n        white-space: pre-wrap;\n      }#quiz-advanced .options-adv {\n        list-style: none;\n        padding: 0;\n      }#quiz-advanced .options-adv li {\n        padding: 14px 16px;\n        margin: 10px 0;\n        border: 2px solid #e2e8f0;\n        border-radius: 8px;\n        cursor: pointer;\n        transition: all 0.2s;\n      }#quiz-advanced .options-adv li:hover:not(.disabled) {\n        border-color: #ed8936;\n        background: #fffaf0;\n      }#quiz-advanced .options-adv li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-advanced .options-adv li.show-answer {\n        border-color: #48bb78;\n        background: #f0fff4;\n      }#quiz-advanced .options-adv li.wrong {\n        border-color: #fc8181;\n        background: #fff5f5;\n      }#quiz-advanced .feedback-adv {\n        margin-top: 16px;\n        padding: 14px;\n        border-radius: 8px;\n        display: none;\n        line-height: 1.6;\n      }#quiz-advanced .feedback-adv.correct {\n        background: #f0fff4;\n        color: #276749;\n        display: block;\n      }#quiz-advanced .feedback-adv.wrong {\n        background: #fff5f5;\n        color: #c53030;\n        display: block;\n      }#quiz-advanced .feedback-adv \n      .score-adv {\n        text-align: center;\n        font-size: 1.4em;\n        padding: 24px;\n        background: white;\n        border-radius: 10px;\n        margin-top: 24px;\n        box-shadow: 0 2px 8px rgba(0, 0, 0, 0.08);\n      }#quiz-advanced .intro {\n        background: #ebf8ff;\n        padding: 16px;\n        border-radius: 8px;\n        margin-bottom: 20px;\n        color: #2c5282;\n      }\n<\/style>\n<h1>\u9032\u968e\u6e2c\u9a57\uff1aasyncpg \u9023\u7dda\u6c60 Connection Pool \u5be6\u6230<\/h1>\n    <div class=\"intro\">\n      <strong>\u6e2c\u9a57\u76ee\u6a19\uff1a<\/strong>\u9a57\u8b49\u4f60\u662f\u5426\u80fd\u5728\u5be6\u969b\u60c5\u5883\u4e2d\u61c9\u7528\u6240\u5b78\u3002<br \/>\n      \u5171 5 \u984c\uff0c\u5305\u542b\u60c5\u5883\u984c\u8207\u932f\u8aa4\u8a3a\u65b7\u984c\u3002\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv1\">\n      <h3>1. \u4f60\u6b63\u5728\u958b\u767c\u4e00\u500b FastAPI \u61c9\u7528\u7a0b\u5f0f\uff0c\u9810\u671f\u5e73\u6642\u6709 10 \u500b\u4e26\u767c\u9023\u7dda\uff0c\u5c16\u5cf0\u6642\u671f\u53ef\u80fd\u9054\u5230 40 \u500b\u3002\u4f60\u61c9\u8a72\u5982\u4f55\u8a2d\u5b9a\u9023\u7dda\u6c60\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(1, 'A', 'B')\">A. <code>min_size=1, max_size=100<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(1, 'B', 'B')\">B. <code>min_size=10, max_size=40<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(1, 'C', 'B')\">C. <code>min_size=40, max_size=40<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(1, 'D', 'B')\">D. <code>min_size=40, max_size=100<\/code><\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv1\"><\/div>\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv2\">\n      <h3>2. \u540c\u4e8b\u5beb\u4e86\u4ee5\u4e0b\u7a0b\u5f0f\u78bc\uff0c\u4f46\u5728\u58d3\u529b\u6e2c\u8a66\u6642\u767c\u73fe\u9023\u7dda\u6c92\u6709\u88ab\u6b63\u78ba\u6b78\u9084\u3002\u554f\u984c\u51fa\u5728\u54ea\u88e1\uff1f <span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">async def get_users():\n    conn = await pool.acquire()\n    result = await conn.fetch(&#8220;SELECT * FROM users&#8221;)\n    return result<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(2, 'A', 'C')\">A. \u61c9\u8a72\u4f7f\u7528 <code>conn.fetchall()<\/code> \u800c\u4e0d\u662f <code>conn.fetch()<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(2, 'B', 'C')\">B. \u9023\u7dda\u6c60\u6c92\u6709\u6b63\u78ba\u521d\u59cb\u5316<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'C', 'C')\">C. \u6c92\u6709\u4f7f\u7528 <code>try\/finally<\/code> \u6216 <code>async with<\/code> \u78ba\u4fdd\u9023\u7dda\u6b78\u9084<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'D', 'C')\">D. \u61c9\u8a72\u5728\u51fd\u6578\u7d50\u675f\u524d\u547c\u53eb <code>conn.close()<\/code><\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv2\"><\/div>\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv3\">\n      <h3>3. \u4f60\u7684\u61c9\u7528\u7a0b\u5f0f\u5728\u9ad8\u6d41\u91cf\u6642\u6536\u5230\u4ee5\u4e0b\u932f\u8aa4\uff0c\u61c9\u8a72\u5982\u4f55\u8655\u7406\uff1f <span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">asyncio.TimeoutError: connection pool is exhausted<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(3, 'A', 'D')\">A. \u91cd\u65b0\u555f\u52d5\u61c9\u7528\u7a0b\u5f0f<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'B', 'D')\">B. \u5c07 <code>command_timeout<\/code> \u8a2d\u5f97\u66f4\u5927<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'C', 'D')\">C. \u6539\u7528\u55ae\u4e00\u9023\u7dda\u6a21\u5f0f<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'D', 'D')\">D. \u589e\u52a0 <code>max_size<\/code> \u6216\u8a2d\u5b9a <code>acquire(timeout=...)<\/code> \u4e26\u8655\u7406\u903e\u6642\u60c5\u6cc1<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv3\"><\/div>\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv4\">\n      <h3>4. \u4f60\u9700\u8981\u5728 FastAPI \u4e2d\u5be6\u4f5c\u4e00\u500b endpoint\uff0c\u8b93\u6bcf\u500b\u8acb\u6c42\u81ea\u52d5\u53d6\u5f97\u9023\u7dda\u4e26\u5728\u7d50\u675f\u6642\u6b78\u9084\u3002\u6700\u4f73\u5be6\u8e10\u662f\u4ec0\u9ebc\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(4, 'A', 'B')\">A. \u5728\u6bcf\u500b endpoint \u5167\u624b\u52d5\u547c\u53eb <code>pool.acquire()<\/code> \u548c <code>pool.release()<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(4, 'B', 'B')\">B. \u5efa\u7acb\u4e00\u500b\u4f9d\u8cf4\u6ce8\u5165\u51fd\u6578\uff0c\u4f7f\u7528 <code>async with pool.acquire()<\/code> \u4e26 yield \u9023\u7dda<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'C', 'B')\">C. \u5c07\u9023\u7dda\u5b58\u5728\u5168\u57df\u8b8a\u6578\u4e2d\uff0c\u6240\u6709 endpoint \u5171\u7528<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'D', 'B')\">D. \u5728\u6bcf\u500b endpoint \u5efa\u7acb\u65b0\u7684\u9023\u7dda\u6c60<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv4\"><\/div>\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv5\">\n      <h3>5. \u4ee5\u4e0b\u7a0b\u5f0f\u78bc\u5728\u61c9\u7528\u7a0b\u5f0f\u95dc\u9589\u5f8c\u4ecd\u7136\u5617\u8a66\u4f7f\u7528\u9023\u7dda\u6c60\uff0c\u5c0e\u81f4\u932f\u8aa4\u3002\u6839\u672c\u539f\u56e0\u662f\u4ec0\u9ebc\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <div class=\"code-block\">@asynccontextmanager\nasync def lifespan(app: FastAPI):\n    global pool\n    pool = await asyncpg.create_pool(&#8230;)\n    yield\n    await pool.close()\n\n# \u5728\u67d0\u500b\u80cc\u666f\u4efb\u52d9\u4e2d\nasync def background_task():\n    await asyncio.sleep(60)\n    async with pool.acquire() as conn:  # \u9019\u88e1\u51fa\u932f\n        await conn.execute(&#8220;INSERT INTO logs &#8230;&#8221;)<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(5, 'A', 'C')\">A. <code>pool.acquire()<\/code> \u8a9e\u6cd5\u932f\u8aa4<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'B', 'C')\">B. \u80cc\u666f\u4efb\u52d9\u4e0d\u80fd\u4f7f\u7528\u9023\u7dda\u6c60<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'C', 'C')\">C. \u80cc\u666f\u4efb\u52d9\u7684\u57f7\u884c\u6642\u9593\u8d85\u904e\u4e86\u61c9\u7528\u7a0b\u5f0f\u7684\u751f\u547d\u9031\u671f\uff0c\u9023\u7dda\u6c60\u5df2\u5728 lifespan \u7d50\u675f\u6642\u95dc\u9589<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'D', 'C')\">D. \u61c9\u8a72\u4f7f\u7528 <code>pool.release()<\/code> \u800c\u4e0d\u662f <code>async with<\/code><\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv5\"><\/div>\n    <\/div>\n\n    <div class=\"score-adv\" id=\"scoreAdv\" style=\"display:none;\"><\/div>\n<script>\n\n      let answeredAdv = 0;\n      let correctAdv = 0;\n      const totalAdv = 5;\n      const explanationsAdv = {\n        1: \"<code>min_size<\/code> \u61c9\u8a2d\u70ba\u5e73\u6642\u7684\u5e73\u5747\u4e26\u767c\u6578\uff0810\uff09\uff0c<code>max_size<\/code> \u61c9\u8a2d\u70ba\u5c16\u5cf0\u6642\u671f\u7684\u6700\u5927\u4e26\u767c\u6578\uff0840\uff09\u3002\u9019\u6a23\u5e73\u6642\u6709\u8db3\u5920\u7684\u9023\u7dda\u5f85\u547d\uff0c\u5c16\u5cf0\u6642\u4e5f\u80fd\u61c9\u4ed8\u9700\u6c42\uff0c\u540c\u6642\u4e0d\u6703\u6d6a\u8cbb\u8cc7\u6e90\u3002\",\n        2: \"\u4f7f\u7528 <code>pool.acquire()<\/code> \u53d6\u5f97\u9023\u7dda\u5f8c\uff0c\u5fc5\u9808\u78ba\u4fdd\u9023\u7dda\u88ab\u6b78\u9084\u3002\u6700\u5b89\u5168\u7684\u65b9\u5f0f\u662f\u4f7f\u7528 <code>async with pool.acquire() as conn<\/code>\uff0c\u9019\u6a23\u5373\u4f7f\u767c\u751f\u4f8b\u5916\uff0c\u9023\u7dda\u4e5f\u6703\u81ea\u52d5\u6b78\u9084\u3002\u82e5\u4e0d\u4f7f\u7528 async with\uff0c\u5247\u5fc5\u9808\u7528 <code>try\/finally<\/code> \u78ba\u4fdd\u547c\u53eb <code>pool.release(conn)<\/code>\u3002\",\n        3: \"\u9019\u500b\u932f\u8aa4\u8868\u793a\u6240\u6709\u9023\u7dda\u90fd\u88ab\u501f\u8d70\u4e86\uff0c\u65b0\u7684\u8acb\u6c42\u7121\u6cd5\u53d6\u5f97\u9023\u7dda\u3002\u89e3\u6c7a\u65b9\u6848\u5305\u62ec\uff1a\u589e\u52a0 <code>max_size<\/code> \u5141\u8a31\u66f4\u591a\u9023\u7dda\u3001\u5728 <code>acquire()<\/code> \u8a2d\u5b9a timeout \u4e26\u512a\u96c5\u8655\u7406\u903e\u6642\u60c5\u6cc1\u3001\u6216\u6aa2\u67e5\u662f\u5426\u6709\u9023\u7dda\u672a\u88ab\u6b63\u78ba\u6b78\u9084\uff08\u9023\u7dda\u6d29\u6f0f\uff09\u3002\",\n        4: \"\u4f7f\u7528\u4f9d\u8cf4\u6ce8\u5165\uff08Depends\uff09\u914d\u5408 <code>async with pool.acquire()<\/code> \u662f FastAPI \u7684\u6700\u4f73\u5be6\u8e10\u3002\u9019\u6a23\u6bcf\u500b\u8acb\u6c42\u81ea\u52d5\u53d6\u5f97\u9023\u7dda\uff0c\u8acb\u6c42\u7d50\u675f\u6642\u9023\u7dda\u81ea\u52d5\u6b78\u9084\uff0c\u7a0b\u5f0f\u78bc\u7c21\u6f54\u4e14\u4e0d\u6613\u51fa\u932f\u3002\",\n        5: \"\u9023\u7dda\u6c60\u7684\u751f\u547d\u9031\u671f\u7531 lifespan \u7ba1\u7406\uff0c\u7576\u61c9\u7528\u7a0b\u5f0f\u95dc\u9589\u6642\uff08yield \u4e4b\u5f8c\uff09\uff0c<code>pool.close()<\/code> \u88ab\u547c\u53eb\u3002\u5982\u679c\u80cc\u666f\u4efb\u52d9\u57f7\u884c\u6642\u9593\u8f03\u9577\uff0c\u53ef\u80fd\u5728\u9023\u7dda\u6c60\u95dc\u9589\u5f8c\u9084\u8a66\u5716\u4f7f\u7528\u5b83\u3002\u89e3\u6c7a\u65b9\u6848\u662f\u78ba\u4fdd\u6240\u6709\u80cc\u666f\u4efb\u52d9\u5728\u61c9\u7528\u7a0b\u5f0f\u95dc\u9589\u524d\u5b8c\u6210\uff0c\u6216\u4f7f\u7528\u5176\u4ed6\u65b9\u5f0f\u7ba1\u7406\u9577\u6642\u9593\u904b\u884c\u7684\u4efb\u52d9\u3002\"\n      };\n\n      function checkAnswerAdv(qNum, selected, correctAns) {\n        const question = document.getElementById(\"qAdv\" + qNum);\n        if (question.classList.contains(\"answered\")) return;\n\n        question.classList.add(\"answered\");\n        answeredAdv++;\n\n        const options = question.querySelectorAll(\".options-adv li\");\n        options.forEach((opt) => {\n          opt.classList.add(\"disabled\");\n          if (opt.textContent.startsWith(correctAns + \".\")) {\n            opt.classList.add(\"show-answer\");\n          }\n        });\n\n        const feedback = document.getElementById(\"fbAdv\" + qNum);\n        if (selected === correctAns) {\n          correctAdv++;\n          feedback.className = \"feedback-adv correct\";\n          feedback.innerHTML = \"\u2713 \u6b63\u78ba\uff01\" + explanationsAdv[qNum];\n        } else {\n          feedback.className = \"feedback-adv wrong\";\n          feedback.innerHTML =\n            \"\u2717 \u932f\u8aa4\u3002\u6b63\u78ba\u7b54\u6848\u662f \" + correctAns + \"\u3002\" + explanationsAdv[qNum];\n          options.forEach((opt) => {\n            if (opt.textContent.startsWith(selected + \".\")) {\n              opt.classList.add(\"wrong\");\n            }\n          });\n        }\n\n        if (answeredAdv === totalAdv) {\n          const scoreDiv = document.getElementById(\"scoreAdv\");\n          scoreDiv.style.display = \"block\";\n          let msg = \"\";\n          if (correctAdv === totalAdv) msg = \"\ud83c\udfaf \u5b8c\u7f8e\uff01\u4f60\u5df2\u7d93\u6e96\u5099\u597d\u5be6\u6230\u4e86\uff01\";\n          else if (correctAdv >= Math.ceil(totalAdv * 0.8))\n            msg = \"\ud83d\udcaa \u5f88\u68d2\uff01\u518d\u8907\u7fd2\u4e00\u4e0b\u932f\u7684\u984c\u76ee\";\n          else if (correctAdv >= Math.ceil(totalAdv * 0.6))\n            msg = \"\ud83d\udcd6 \u5efa\u8b70\u91cd\u8b80\u76f8\u95dc\u6bb5\u843d\u5f8c\u518d\u8a66\u4e00\u6b21\";\n          else msg = \"\ud83d\udd04 \u5efa\u8b70\u91cd\u65b0\u95b1\u8b80\u6587\u4ef6\uff0c\u7279\u5225\u6ce8\u610f\u64cd\u4f5c\u6d41\u7a0b\";\n          scoreDiv.innerHTML =\n            \"\u6e2c\u9a57\u5b8c\u6210\uff01\u5f97\u5206\uff1a\" + correctAdv + \" \/ \" + totalAdv + \"<br>\" + msg;\n        }\n      }\n    \n<\/script>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u6e2c\u9a57\uff1aasyncpg \u9023\u7dda\u6c60 Connection Pool \u5be6\u6230 \u5171 5 \u984c\uff0c\u9ede\u9078\u7b54\u6848\u5f8c\u6703\u7acb\u5373\u986f\u793a\u7d50\u679c 1. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rolpb_likes":0,"footnotes":""},"categories":[316],"tags":[317],"class_list":["post-299","post","type-post","status-publish","format-standard","hentry","category-asyncpg","tag-asyncpg"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":7}},"_links":{"self":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts\/299","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/comments?post=299"}],"version-history":[{"count":0,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts\/299\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/media?parent=299"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/categories?post=299"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/tags?post=299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}