{"id":41636,"date":"2023-07-14T06:45:25","date_gmt":"2023-03-30T01:18:06","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e6%94%af%e6%8c%81%e5%b9%b6%e8%a1%8c%e7%bc%96%e7%a8%8b%e3%80%82\/"},"modified":"2024-04-30T13:30:08","modified_gmt":"2024-04-30T05:30:08","slug":"postgresql%e6%94%af%e6%8c%81%e5%b9%b6%e8%a1%8c%e7%bc%96%e7%a8%8b%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e6%94%af%e6%8c%81%e5%b9%b6%e8%a1%8c%e7%bc%96%e7%a8%8b%e3%80%82\/","title":{"rendered":"PostgreSQL\u652f\u6301\u5e76\u884c\u7f16\u7a0b"},"content":{"rendered":"<p>\u8fd9\u7bc7\u6587\u7ae0\u662f\u201cPostgreSQL Advent Calendar 2016\u201d\u7b2c9\u5929\u7684\u6587\u7ae0\u3002<\/p>\n<h1>\u9996\u5148<\/h1>\n<p>\u6628\u5929\uff0c\u5f00\u53d1\u4e2d\u7684PostgreSQL10.0\u7ec8\u4e8e\u5f15\u5165\u4e86\u4e13\u95e8\u7528\u4e8e\u5206\u533a\u7684\u8bed\u6cd5\uff0c\u4e0b\u4e00\u4e2a\u7248\u672c\u4e5f\u662f\u4ee4\u4eba\u671f\u5f85\u7684\u3002\u867d\u7136\u6211\u539f\u672c\u6253\u7b97\u5199\u4e00\u7bc7\u5173\u4e8e\u5206\u533a\u7684\u6587\u7ae0\uff0c\u4f46\u6211\u5e0c\u671b\u6709\u5176\u4ed6\u4eba\u80fd\u5199\uff0c\u6240\u4ee5\u4eca\u5929\u6211\u8981\u4ecb\u7ecd\u7684\u662f\u5728\u6700\u65b0\u7248\u672c\u7684PostgreSQL 9.6\u4e2d\u5f15\u5165\u4e86\u5e76\u884c\u67e5\u8be2\u548c\u5e76\u884c\u5316\u7684\u70ed\u95e8\u8bdd\u9898\uff0c\u4ee5\u53ca\u5982\u4f55\u4f7f\u7528PostgreSQL\u7684\u5e76\u884c\u673a\u5236\u8fdb\u884c\u5e76\u884c\u7f16\u7a0b\u7684\u65b9\u6cd5\u3002<\/p>\n<p>\u6211\u521b\u5efa\u4e86\u4e00\u4e2a\u540d\u4e3apg_foobar\u7684\u6269\u5c55\u4f5c\u4e3a\u793a\u4f8b\u7a0b\u5e8f\uff0c\u8bf7\u4eceGitHub\u5b58\u50a8\u5e93\u4e0b\u8f7d\u3002<\/p>\n<h1>\u6267\u884c\u793a\u4f8b<\/h1>\n<p>\u5728pg_foobar EXTENSION\u4e2d\uff0c\u6211\u4eec\u51c6\u5907\u4e86pg_foobar()\u51fd\u6570\uff0c\u5f53\u6267\u884cSELECT pg_foobar(2, 3, 4)\u65f6\uff0c\u4e24\u4e2a\u5e76\u884c\u7684\u5de5\u4f5c\u8fdb\u7a0b\u4f1a\u5206\u522b\u8bf4\u51fa&#8217;foo&#8217;3\u6b21\uff0c&#8217;bar&#8217;4\u6b21\u3002\u65e5\u5fd7\u7684\u8f93\u51fa\u683c\u5f0f\u662fworker &lt;\u7528\u4e8e\u8bc6\u522b\u5de5\u4f5c\u8fdb\u7a0b&gt; &lt;\u662ffoo\u8fd8\u662fbar&gt; &lt;\u6b21\u6570&gt;\u3002\u4ee5\u4e0b\u662f\u4e00\u4e2a\u6267\u884c\u793a\u4f8b\uff0c\u53ef\u4ee5\u770b\u5230\u4e24\u4e2a\u5de5\u4f5c\u8fdb\u7a0b\u5e76\u884c\u5730\u8f93\u51fa\u4e863\u6b21foo\u548c4\u6b21bar\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"o\">=#<\/span> <span class=\"k\">CREATE<\/span> <span class=\"n\">EXTENSION<\/span> <span class=\"n\">pg_foobar<\/span><span class=\"p\">;<\/span>\r\n<span class=\"o\">=#<\/span> <span class=\"k\">SELECT<\/span> <span class=\"n\">pg_foobar<\/span><span class=\"p\">(<\/span><span class=\"mi\">2<\/span><span class=\"p\">,<\/span> <span class=\"mi\">3<\/span><span class=\"p\">,<\/span> <span class=\"mi\">4<\/span><span class=\"p\">);<\/span>\r\n <span class=\"n\">pg_foobar<\/span> \r\n<span class=\"c1\">-----------<\/span>\r\n\r\n<span class=\"p\">(<\/span><span class=\"mi\">1<\/span> <span class=\"k\">row<\/span><span class=\"p\">)<\/span>\r\n\r\n<span class=\"err\">$<\/span> <span class=\"n\">cat<\/span> <span class=\"o\">\/<\/span><span class=\"n\">path<\/span><span class=\"o\">\/<\/span><span class=\"k\">to<\/span><span class=\"o\">\/<\/span><span class=\"n\">postgresql<\/span><span class=\"p\">.<\/span><span class=\"n\">log<\/span>\r\n<span class=\"n\">LOG<\/span><span class=\"p\">:<\/span>  <span class=\"n\">worker<\/span> <span class=\"mi\">0<\/span> <span class=\"n\">foo<\/span> <span class=\"mi\">0<\/span>\r\n<span class=\"n\">LOG<\/span><span class=\"p\">:<\/span>  <span class=\"n\">worker<\/span> <span class=\"mi\">0<\/span> <span class=\"n\">foo<\/span> <span class=\"mi\">1<\/span>\r\n<span class=\"n\">LOG<\/span><span class=\"p\">:<\/span>  <span class=\"n\">worker<\/span> <span class=\"mi\">1<\/span> <span class=\"n\">foo<\/span> <span class=\"mi\">0<\/span>\r\n<span class=\"n\">LOG<\/span><span class=\"p\">:<\/span>  <span class=\"n\">worker<\/span> <span class=\"mi\">0<\/span> <span class=\"n\">foo<\/span> <span class=\"mi\">2<\/span>\r\n<span class=\"n\">LOG<\/span><span class=\"p\">:<\/span>  <span class=\"n\">worker<\/span> <span class=\"mi\">1<\/span> <span class=\"n\">foo<\/span> <span class=\"mi\">1<\/span>\r\n<span class=\"n\">LOG<\/span><span class=\"p\">:<\/span>  <span class=\"n\">worker<\/span> <span class=\"mi\">0<\/span> <span class=\"n\">bar<\/span> <span class=\"mi\">0<\/span>\r\n<span class=\"n\">LOG<\/span><span class=\"p\">:<\/span>  <span class=\"n\">worker<\/span> <span class=\"mi\">1<\/span> <span class=\"n\">foo<\/span> <span class=\"mi\">2<\/span>\r\n<span class=\"n\">LOG<\/span><span class=\"p\">:<\/span>  <span class=\"n\">worker<\/span> <span class=\"mi\">0<\/span> <span class=\"n\">bar<\/span> <span class=\"mi\">1<\/span>\r\n<span class=\"n\">LOG<\/span><span class=\"p\">:<\/span>  <span class=\"n\">worker<\/span> <span class=\"mi\">1<\/span> <span class=\"n\">bar<\/span> <span class=\"mi\">0<\/span>\r\n<span class=\"n\">LOG<\/span><span class=\"p\">:<\/span>  <span class=\"n\">worker<\/span> <span class=\"mi\">0<\/span> <span class=\"n\">bar<\/span> <span class=\"mi\">2<\/span>\r\n<span class=\"n\">LOG<\/span><span class=\"p\">:<\/span>  <span class=\"n\">worker<\/span> <span class=\"mi\">1<\/span> <span class=\"n\">bar<\/span> <span class=\"mi\">1<\/span>\r\n<span class=\"n\">LOG<\/span><span class=\"p\">:<\/span>  <span class=\"n\">worker<\/span> <span class=\"mi\">0<\/span> <span class=\"n\">bar<\/span> <span class=\"mi\">3<\/span>\r\n<span class=\"n\">LOG<\/span><span class=\"p\">:<\/span>  <span class=\"n\">worker<\/span> <span class=\"mi\">1<\/span> <span class=\"n\">bar<\/span> <span class=\"mi\">2<\/span>\r\n<span class=\"n\">LOG<\/span><span class=\"p\">:<\/span>  <span class=\"n\">worker<\/span> <span class=\"mi\">1<\/span> <span class=\"n\">bar<\/span> <span class=\"mi\">3<\/span>\r\n<\/code><\/pre>\n<h1>\u8fdb\u884c\u5e76\u884c\u5316\u6240\u9700\u7684\u4e1c\u897f<\/h1>\n<p>\u53ea\u9700\u8981\u4ee5\u4e0b\u8fd9\u4e9b\u5185\u5bb9\uff0c\u5c31\u53ef\u4ee5\u7f16\u5199\u7b80\u5355\u7684\u5e76\u884c\u5904\u7406\u7a0b\u5e8f\u3002<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u52a8\u6001\u5171\u4eab\u5185\u5b58(DSM)\u548cToC<\/ol>\n<\/li>\n<\/ol>\n<p>\u8fd9\u662f\u4e00\u79cd\u5728\u52a8\u6001\u65f6\u673a\u4e0a\u5206\u914d\u5171\u4eab\u5185\u5b58\u7684\u673a\u5236\u3002<br \/>\n\u5b83\u7528\u4e8e\u5728\u5404\u4e2a\u5de5\u4f5c\u8fdb\u7a0b\u4e4b\u95f4\u6216\u4e0e\u542f\u52a8\u5e76\u884c\u5de5\u4f5c\u8fdb\u7a0b\u7684\u8bfb\u53d6\u8fdb\u7a0b\u4e4b\u95f4\u8fdb\u884c\u6570\u636e\u4ea4\u6362\u3002<\/p>\n<p>\u5e76\u884c\u5de5\u4f5c\u8fdb\u7a0b\u7684\u5165\u53e3\u70b9\u51fd\u6570<\/p>\n<p>\u5728\u6bcf\u4e2a\u5de5\u4f5c\u8fdb\u7a0b\u542f\u52a8\u540e\uff0c\u5b9a\u4e49\u5c06\u8981\u5904\u7406\u7684\u51fd\u6570\u3002<\/p>\n<h1>\u6982\u8ff0\u5904\u7406<\/h1>\n<p>\u5728\u9886\u5bfc\u8fdb\u7a0b\u4e2d\uff0c\u4e3b\u8981\u60c5\u51b5\u5982\u4e0b\u3002\u5e26\u6709\u2605\u6807\u8bb0\u7684\u90e8\u5206\u662f\u6b64\u7a0b\u5e8f\u7279\u6709\u7684\u5904\u7406\uff0c\u6839\u636e\u6240\u9700\u7684\u5e76\u884c\u5904\u7406\u548c\u534f\u4f5c\u6570\u636e\u8fdb\u884c\u66f4\u6539\u3002\u5176\u4ed6\u5904\u7406\u57fa\u672c\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528\u3002\u8fd9\u6837\u770b\u6765\uff0c\u53ef\u4ee5\u53d1\u73b0\u7b80\u5355\u5904\u7406\u7684\u5e76\u884c\u5316\u975e\u5e38\u5bb9\u6613\u3002\u4e0b\u9762\u662f\u6dfb\u52a0\u4e86\u65e5\u8bed\u6ce8\u91ca\u7684\u4ee3\u7801\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"cm\">\/* \u2605toc\u7528\u306e\u30ad\u30fc\u306e\u8a2d\u5b9a\u3002\u91cd\u8907\u304c\u306a\u3051\u308c\u3070\u306a\u3093\u3067\u3082OK *\/<\/span>\r\n<span class=\"cp\">#define FOO_KEY 1000 <\/span><span class=\"cm\">\/* foo\u7528\u306e\u30ad\u30fc\u756a\u53f7 *\/<\/span><span class=\"cp\">\r\n#define BAR_KEY 1001 <\/span><span class=\"cm\">\/* bar\u7528\u306e\u30ad\u30fc\u756a\u53f7 *\/<\/span>\r\n\r\n<span class=\"cm\">\/* \u30ea\u30fc\u30c0\u30d7\u30ed\u30bb\u30b9\u306e\u30e1\u30a4\u30f3\u51e6\u7406 *\/<\/span>\r\n<span class=\"n\">Datum<\/span>\r\n<span class=\"nf\">pg_foobar<\/span><span class=\"p\">(<\/span><span class=\"n\">PG_FUNCTION_ARGS<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">{<\/span>\r\n    <span class=\"kt\">int<\/span> <span class=\"n\">nworkers<\/span> <span class=\"o\">=<\/span> <span class=\"n\">PG_GETARG_INT32<\/span><span class=\"p\">(<\/span><span class=\"mi\">0<\/span><span class=\"p\">);<\/span>\r\n    <span class=\"kt\">int<\/span> <span class=\"n\">n_foo<\/span> <span class=\"o\">=<\/span> <span class=\"n\">PG_GETARG_INT32<\/span><span class=\"p\">(<\/span><span class=\"mi\">1<\/span><span class=\"p\">);<\/span>\r\n    <span class=\"kt\">int<\/span> <span class=\"n\">n_bar<\/span> <span class=\"o\">=<\/span> <span class=\"n\">PG_GETARG_INT32<\/span><span class=\"p\">(<\/span><span class=\"mi\">2<\/span><span class=\"p\">);<\/span>\r\n    <span class=\"kt\">int<\/span> <span class=\"n\">size<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">0<\/span>\r\n    <span class=\"kt\">int<\/span> <span class=\"n\">keys<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">0<\/span><span class=\"p\">;<\/span>\r\n    <span class=\"kt\">int<\/span> <span class=\"o\">*<\/span><span class=\"n\">shm_area<\/span><span class=\"p\">;<\/span>\r\n    <span class=\"n\">ParallelContext<\/span> <span class=\"o\">*<\/span><span class=\"n\">pcxt<\/span><span class=\"p\">;<\/span>\r\n\r\n    <span class=\"cm\">\/* \u30d1\u30e9\u30ec\u30eb\u51e6\u7406\u958b\u59cb\u6642\u306e\u304a\u307e\u3058\u306a\u3044 *\/<\/span>\r\n    <span class=\"n\">EnterParallelMode<\/span><span class=\"p\">();<\/span>\r\n\r\n    <span class=\"cm\">\/* \u7b2c\u4e00\u5f15\u6570\u306b\u30a8\u30f3\u30c8\u30ea\u30dd\u30a4\u30f3\u30c8\u306e\u95a2\u6570\u540d\u3001\u7b2c\u4e8c\u5f15\u6570\u306b\u4e26\u5217\u5ea6 *\/<\/span>\r\n    <span class=\"n\">pcxt<\/span> <span class=\"o\">=<\/span> <span class=\"n\">CreateParallelContext<\/span><span class=\"p\">(<\/span><span class=\"n\">foobar_worker<\/span><span class=\"p\">,<\/span> <span class=\"n\">nworkers<\/span><span class=\"p\">);<\/span>\r\n\r\n    <span class=\"cm\">\/*\r\n     * \u2605DSM\u9818\u57df\u306e\u898b\u7a4d\u308a\u3001\u78ba\u4fdd\u3059\u308b\u3002\r\n     * foo\u306e\u51fa\u529b\u56de\u6570\u7528\u3001bar\u306e\u51fa\u529b\u56de\u6570\u7528\u306e\u305f\u3081\u306bDSM\u306e\u9818\u57df\u306f2\u3064\u3002\u30ad\u30fc\u306e\u6570\u30822\u3064\u3002\r\n     *\/<\/span>\r\n    <span class=\"n\">size<\/span> <span class=\"o\">+=<\/span> <span class=\"n\">BUFFERALIGN<\/span><span class=\"p\">(<\/span><span class=\"k\">sizeof<\/span><span class=\"p\">(<\/span><span class=\"kt\">int<\/span><span class=\"p\">));<\/span>\r\n    <span class=\"n\">keys<\/span><span class=\"o\">++<\/span><span class=\"p\">;<\/span>\r\n    <span class=\"n\">size<\/span> <span class=\"o\">+=<\/span> <span class=\"n\">BUFFERALIGN<\/span><span class=\"p\">(<\/span><span class=\"k\">sizeof<\/span><span class=\"p\">(<\/span><span class=\"kt\">int<\/span><span class=\"p\">));<\/span>\r\n    <span class=\"n\">keys<\/span><span class=\"o\">++<\/span><span class=\"p\">;<\/span>\r\n    <span class=\"n\">shm_toc_estimate_chunk<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">pcxt<\/span><span class=\"o\">-&gt;<\/span><span class=\"n\">estimator<\/span><span class=\"p\">,<\/span> <span class=\"n\">size<\/span><span class=\"p\">);<\/span>\r\n    <span class=\"n\">shm_toc_estimate_keys<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">pcxt<\/span><span class=\"o\">-&gt;<\/span><span class=\"n\">estimator<\/span><span class=\"p\">,<\/span> <span class=\"n\">keys<\/span><span class=\"p\">);<\/span>\r\n    <span class=\"n\">InitializeParallelDSM<\/span><span class=\"p\">(<\/span><span class=\"n\">pcxt<\/span><span class=\"p\">);<\/span>\r\n\r\n    <span class=\"cm\">\/* \u2605foo\u306e\u56de\u6570(n_foo)\u3092DSM\u4e0a\u306e\u30e1\u30e2\u30ea\u9818\u57df\u306b\u683c\u7d0d *\/<\/span>\r\n    <span class=\"n\">shm_area<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"kt\">int<\/span> <span class=\"o\">*<\/span><span class=\"p\">)<\/span> <span class=\"n\">shm_toc_allocate<\/span><span class=\"p\">(<\/span><span class=\"n\">pcxt<\/span><span class=\"o\">-&gt;<\/span><span class=\"n\">toc<\/span><span class=\"p\">,<\/span> <span class=\"k\">sizeof<\/span><span class=\"p\">(<\/span><span class=\"kt\">int<\/span><span class=\"p\">));<\/span>\r\n    <span class=\"n\">shm_toc_insert<\/span><span class=\"p\">(<\/span><span class=\"n\">pcxt<\/span><span class=\"o\">-&gt;<\/span><span class=\"n\">toc<\/span><span class=\"p\">,<\/span> <span class=\"n\">FOO_KEY<\/span><span class=\"p\">,<\/span> <span class=\"n\">shm_area<\/span><span class=\"p\">);<\/span> <span class=\"cm\">\/* \u3042\u3068\u3067\u30ef\u30fc\u30ab\u30fc\u304c\u63a2\u305b\u308b\u3088\u3046\u306b\u30ad\u30fc(FOO_KEY)\u3092\u8a2d\u5b9a *\/<\/span>\r\n    <span class=\"o\">*<\/span><span class=\"n\">shm_area<\/span> <span class=\"o\">=<\/span> <span class=\"n\">n_foo<\/span><span class=\"p\">;<\/span>\r\n    <span class=\"cm\">\/* \u2605bar\u306e\u56de\u6570(n_bar)\u3092DSM\u4e0a\u306e\u30e1\u30e2\u30ea\u9818\u57df\u306b\u683c\u7d0d *\/<\/span>\r\n    <span class=\"n\">shm_area<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"kt\">int<\/span> <span class=\"o\">*<\/span><span class=\"p\">)<\/span> <span class=\"n\">shm_toc_allocate<\/span><span class=\"p\">(<\/span><span class=\"n\">pcxt<\/span><span class=\"o\">-&gt;<\/span><span class=\"n\">toc<\/span><span class=\"p\">,<\/span> <span class=\"k\">sizeof<\/span><span class=\"p\">(<\/span><span class=\"kt\">int<\/span><span class=\"p\">));<\/span>\r\n    <span class=\"n\">shm_toc_insert<\/span><span class=\"p\">(<\/span><span class=\"n\">pcxt<\/span><span class=\"o\">-&gt;<\/span><span class=\"n\">toc<\/span><span class=\"p\">,<\/span> <span class=\"n\">BAR_KEY<\/span><span class=\"p\">,<\/span> <span class=\"n\">shm_area<\/span><span class=\"p\">);<\/span>  <span class=\"cm\">\/* \u3042\u3068\u3067\u30ef\u30fc\u30ab\u30fc\u304c\u63a2\u305b\u308b\u3088\u3046\u306b\u30ad\u30fc(FOO_KEY)\u3092\u8a2d\u5b9a *\/<\/span>\r\n    <span class=\"o\">*<\/span><span class=\"n\">shm_area<\/span> <span class=\"o\">=<\/span> <span class=\"n\">n_bar<\/span><span class=\"p\">;<\/span>\r\n\r\n    <span class=\"cm\">\/* \u30ef\u30fc\u30ab\u30fc\u3092\u8d77\u52d5 *\/<\/span>\r\n    <span class=\"n\">LaunchParallelWorkers<\/span><span class=\"p\">(<\/span><span class=\"n\">pcxt<\/span><span class=\"p\">);<\/span>\r\n\r\n    <span class=\"cm\">\/* \u5168\u30ef\u30fc\u30ab\u30fc\u304c\u7d42\u4e86\u3059\u308b\u307e\u3067\u5f85\u6a5f *\/<\/span>\r\n    <span class=\"n\">WaitForParallelWorkersToFinish<\/span><span class=\"p\">(<\/span><span class=\"n\">pcxt<\/span><span class=\"p\">);<\/span>\r\n\r\n    <span class=\"cm\">\/* \u30d1\u30e9\u30ec\u30eb\u51e6\u7406\u7d42\u4e86\u6642\u306e\u304a\u307e\u3058\u306a\u3044 *\/<\/span>\r\n    <span class=\"n\">DestroyParallelContext<\/span><span class=\"p\">(<\/span><span class=\"n\">pcxt<\/span><span class=\"p\">);<\/span>\r\n    <span class=\"n\">ExitParallelMode<\/span><span class=\"p\">();<\/span>\r\n\r\n    <span class=\"n\">PG_RETURN_NULL<\/span><span class=\"p\">();<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<p>\u5de5\u4eba\u53ea\u9700\u8981\u7b80\u5355\u5730\u4eceDSM\u83b7\u53d6\u6570\u636e\uff0c\u5e76\u8fdb\u884c\u81ea\u5df1\u7684\u5904\u7406\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"k\">static<\/span> <span class=\"kt\">void<\/span>\r\n<span class=\"nf\">parallel_worker<\/span><span class=\"p\">(<\/span><span class=\"n\">dsm_segment<\/span> <span class=\"o\">*<\/span><span class=\"n\">seg<\/span><span class=\"p\">,<\/span> <span class=\"n\">shm_toc<\/span> <span class=\"o\">*<\/span><span class=\"n\">toc<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">{<\/span>\r\n    <span class=\"kt\">int<\/span> <span class=\"n\">n_foo<\/span><span class=\"p\">;<\/span>\r\n    <span class=\"kt\">int<\/span> <span class=\"n\">n_bar<\/span><span class=\"p\">;<\/span>\r\n    <span class=\"kt\">int<\/span> <span class=\"o\">*<\/span><span class=\"n\">shm_area<\/span><span class=\"p\">;<\/span>\r\n    <span class=\"kt\">int<\/span> <span class=\"n\">i<\/span><span class=\"p\">;<\/span>\r\n\r\n    <span class=\"cm\">\/* FOO_KEY\u3092\u4f7f\u3063\u3066toc\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97 *\/<\/span>\r\n    <span class=\"n\">shm_area<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"kt\">int<\/span> <span class=\"o\">*<\/span><span class=\"p\">)<\/span> <span class=\"n\">shm_toc_lookup<\/span><span class=\"p\">(<\/span><span class=\"n\">toc<\/span><span class=\"p\">,<\/span> <span class=\"n\">FOO_KEY<\/span><span class=\"p\">);<\/span>\r\n    <span class=\"n\">n_foo<\/span> <span class=\"o\">=<\/span> <span class=\"o\">*<\/span><span class=\"n\">shm_area<\/span><span class=\"p\">;<\/span>\r\n\r\n    <span class=\"cm\">\/* BAR_KEY\u3092\u4f7f\u3063\u3066toc\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97 *\/<\/span>\r\n    <span class=\"n\">shm_area<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"kt\">int<\/span> <span class=\"o\">*<\/span><span class=\"p\">)<\/span> <span class=\"n\">shm_toc_lookup<\/span><span class=\"p\">(<\/span><span class=\"n\">toc<\/span><span class=\"p\">,<\/span> <span class=\"n\">BAR_KEY<\/span><span class=\"p\">);<\/span>\r\n    <span class=\"n\">n_bar<\/span> <span class=\"o\">=<\/span> <span class=\"o\">*<\/span><span class=\"n\">shm_area<\/span><span class=\"p\">;<\/span>\r\n\r\n    <span class=\"cm\">\/* \u4ee5\u4e0b\u306f\u30ef\u30fc\u30ab\u30fc\u72ec\u81ea\u306e\u51e6\u7406 *\/<\/span>\r\n\r\n    <span class=\"cm\">\/* foo *\/<\/span>\r\n    <span class=\"k\">for<\/span> <span class=\"p\">(<\/span><span class=\"n\">i<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">0<\/span><span class=\"p\">;<\/span> <span class=\"n\">i<\/span> <span class=\"o\">&lt;<\/span> <span class=\"n\">n_foo<\/span><span class=\"p\">;<\/span> <span class=\"n\">i<\/span><span class=\"o\">++<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"n\">elog<\/span><span class=\"p\">(<\/span><span class=\"n\">LOG<\/span><span class=\"p\">,<\/span> <span class=\"s\">\"[%d] worker %d foo\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">i<\/span><span class=\"p\">,<\/span> <span class=\"n\">ParallelWorkerNumber<\/span><span class=\"p\">);<\/span>\r\n\r\n    <span class=\"cm\">\/* bar *\/<\/span>\r\n    <span class=\"k\">for<\/span> <span class=\"p\">(<\/span><span class=\"n\">i<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">0<\/span><span class=\"p\">;<\/span> <span class=\"n\">i<\/span> <span class=\"o\">&lt;<\/span> <span class=\"n\">n_bar<\/span><span class=\"p\">;<\/span> <span class=\"n\">i<\/span><span class=\"o\">++<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"n\">elog<\/span><span class=\"p\">(<\/span><span class=\"n\">LOG<\/span><span class=\"p\">,<\/span> <span class=\"s\">\"[%d] worker %d bar\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">i<\/span><span class=\"p\">,<\/span> <span class=\"n\">ParallelWorkerNumber<\/span><span class=\"p\">);<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<h1>\u5b9e\u65bd\u8981\u70b91\uff1aDSM\u548cToC<\/h1>\n<p>\u751f\u6210\u5de5\u4f5c\u8fdb\u7a0b\u662f\u7531postmaster\u8fdb\u7a0b\u6267\u884c\u7684\uff0c\u56e0\u6b64\u5de5\u4f5c\u8fdb\u7a0b\u65e0\u6cd5\u8bbf\u95ee\u9886\u5bfc\u8fdb\u7a0b\u4e4b\u524d\u7684\u5904\u7406\u5185\u5bb9\u548c\u53d8\u91cf\u3002\u56e0\u6b64\uff0c\u5982\u679c\u60f3\u8981\u4ece\u9886\u5bfc\u8fdb\u7a0b\u4f20\u9012\u6570\u636e\uff0c\u5c31\u9700\u8981\u901a\u8fc7DSM\u8fdb\u884c\u4f20\u9012\u3002\u540c\u6837\u5730\uff0c\u5982\u679c\u8981\u5c06\u5de5\u4f5c\u8fdb\u7a0b\u7684\u5904\u7406\u7ed3\u679c\u4f20\u9012\u7ed9\u9886\u5bfc\u8fdb\u7a0b\u4e5f\u662f\u5982\u6b64\u3002<\/p>\n<p>PostgreSQL\u7684\u5e76\u884c\u673a\u5236\u4e2d\u63d0\u4f9b\u4e86Shmem ToC\uff08Table of Contents\uff0c\u76ee\u5f55\uff09\uff0c\u901a\u8fc7DSM\uff08Distributed Shared Memory\uff0c\u5206\u5e03\u5f0f\u5171\u4eab\u5185\u5b58\uff09\u53ef\u76f8\u5bf9\u5bb9\u6613\u5730\u5b9e\u73b0\u8fdb\u7a0b\u95f4\u7684\u6570\u636e\u5171\u4eab\u3002<\/p>\n<h2>\u6b65\u9aa41\uff1a\u786e\u4fddDSM<\/h2>\n<p>\u4e3a\u4e86\u4f7f\u7528ToC\uff0c\u6211\u4eec\u9884\u5148\u4f30\u8ba1\u5e76\u786e\u4fddDSM\u9886\u57df\u3002\u5728\u793a\u4f8b\u4ee3\u7801\u7684\u5f00\u5934\uff0c\u4ee5\u4e0b\u90e8\u5206\u9002\u7528\u3002\u5728pg_foobar\u4e2d\uff0c\u4e3a\u4e86\u5c06&#8217;foo&#8217;\u8bf4\u7684\u6b21\u6570\uff08int\uff09\u548c&#8217;bar&#8217;\u8bf4\u7684\u6b21\u6570\uff08int\uff09\u8fd9\u4e24\u4e2a\u6570\u636e\u4e0e\u6bcf\u4e2a\u5de5\u4f5c\u8005\u5171\u4eab\uff0c\u6211\u4eec\u9700\u8981\u4e24\u4e2aint\u533a\u57df\u548c\u4e00\u4e2a\u952e\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"o\">:<\/span>\r\n    <span class=\"kt\">int<\/span> <span class=\"n\">size<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">0<\/span><span class=\"p\">;<\/span>\r\n    <span class=\"kt\">int<\/span> <span class=\"n\">keys<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">0<\/span><span class=\"p\">;<\/span>\r\n<span class=\"o\">:<\/span>\r\n    <span class=\"n\">size<\/span> <span class=\"o\">+=<\/span> <span class=\"n\">BUFFERALIGN<\/span><span class=\"p\">(<\/span><span class=\"k\">sizeof<\/span><span class=\"p\">(<\/span><span class=\"kt\">int<\/span><span class=\"p\">));<\/span>\r\n    <span class=\"n\">keys<\/span><span class=\"o\">++<\/span><span class=\"p\">;<\/span>\r\n    <span class=\"n\">size<\/span> <span class=\"o\">+=<\/span> <span class=\"n\">BUFFERALIGN<\/span><span class=\"p\">(<\/span><span class=\"k\">sizeof<\/span><span class=\"p\">(<\/span><span class=\"kt\">int<\/span><span class=\"p\">));<\/span>\r\n    <span class=\"n\">keys<\/span><span class=\"o\">++<\/span><span class=\"p\">;<\/span>\r\n    <span class=\"n\">shm_toc_estimate_chunk<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">pcxt<\/span><span class=\"o\">-&gt;<\/span><span class=\"n\">estimator<\/span><span class=\"p\">,<\/span> <span class=\"n\">size<\/span><span class=\"p\">);<\/span> <span class=\"cm\">\/* size\u30d0\u30a4\u30c8\u5206\u306eDSM\u3092\u78ba\u4fdd *\/<\/span>\r\n    <span class=\"n\">shm_toc_estimate_keys<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">pcxt<\/span><span class=\"o\">-&gt;<\/span><span class=\"n\">estimator<\/span><span class=\"p\">,<\/span> <span class=\"n\">keys<\/span><span class=\"p\">);<\/span> <span class=\"cm\">\/* keys\u500b\u306e\u30ad\u30fc\u3092\u78ba\u4fdd *\/<\/span>\r\n    <span class=\"n\">InitializeParallelDSM<\/span><span class=\"p\">(<\/span><span class=\"n\">pcxt<\/span><span class=\"p\">);<\/span>\r\n<span class=\"o\">:<\/span>\r\n\r\n<\/code><\/pre>\n<h2>\u7b2c\u4e8c\u6b65\uff1a\u521b\u5efa\u76ee\u5f55<\/h2>\n<p>\u7531\u4e8e\u53ea\u5b8c\u6210\u4e86\u7b2c\u4e00\u6b65\uff0c\u5728\u8be5\u6b65\u9aa4\u4e2d\u9884\u7559\u4e86DSM\u9886\u57df\uff0c\u56e0\u6b64\u5728\u7b2c\u4e8c\u6b65\u4e2d\u5c06\u521b\u5efaToC\u3002\u5177\u4f53\u64cd\u4f5c\u662f\u4ece\u4e8b\u5148\u9884\u7559\u7684DSM\u4e2d\u5212\u5206\u533a\u57df\uff0c\u5e76\u4f7f\u7528\u6807\u8bc6\u7b26\u4f5c\u4e3a\u952e\u6765\u6ce8\u518c\u5230ToC\u4e2d\u3002\u5728pg_foobar\u4e2d\uff0c\u4e3a\u4e86\u533a\u5206\u4fdd\u7559\u7684\u4e24\u4e2a\u533a\u57df\uff0c\u5df2\u51c6\u5907\u4e86FOO_KEY\u548cBAR_KEY\u3002\u4ee5\u4e0b\u662f\u4ee3\u7801\u793a\u4f8b\u4e2d\u76f8\u5173\u7684\u90e8\u5206\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"o\">:<\/span>\r\n    <span class=\"cm\">\/* \u2605foo\u306e\u56de\u6570\u3092\u683c\u7d0d *\/<\/span>\r\n    <span class=\"n\">shm_area<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"kt\">int<\/span> <span class=\"o\">*<\/span><span class=\"p\">)<\/span> <span class=\"n\">shm_toc_allocate<\/span><span class=\"p\">(<\/span><span class=\"n\">pcxt<\/span><span class=\"o\">-&gt;<\/span><span class=\"n\">toc<\/span><span class=\"p\">,<\/span> <span class=\"k\">sizeof<\/span><span class=\"p\">(<\/span><span class=\"kt\">int<\/span><span class=\"p\">));<\/span>\r\n    <span class=\"n\">shm_toc_insert<\/span><span class=\"p\">(<\/span><span class=\"n\">pcxt<\/span><span class=\"o\">-&gt;<\/span><span class=\"n\">toc<\/span><span class=\"p\">,<\/span> <span class=\"n\">FOO_KEY<\/span><span class=\"p\">,<\/span> <span class=\"n\">shm_area<\/span><span class=\"p\">);<\/span> <span class=\"cm\">\/* \u3042\u3068\u3067\u30ef\u30fc\u30ab\u30fc\u30d7\u30ed\u30bb\u30b9\u304c\u63a2\u305b\u308b\u3088\u3046\u306b\u30ad\u30fc(FOO_KEY)\u3092\u8a2d\u5b9a *\/<\/span>\r\n    <span class=\"o\">*<\/span><span class=\"n\">shm_area<\/span> <span class=\"o\">=<\/span> <span class=\"n\">n_foo<\/span><span class=\"p\">;<\/span>\r\n    <span class=\"cm\">\/* \u2605bar\u306e\u56de\u6570\u3092\u683c\u7d0d *\/<\/span>\r\n    <span class=\"n\">shm_area<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"kt\">int<\/span> <span class=\"o\">*<\/span><span class=\"p\">)<\/span> <span class=\"n\">shm_toc_allocate<\/span><span class=\"p\">(<\/span><span class=\"n\">pcxt<\/span><span class=\"o\">-&gt;<\/span><span class=\"n\">toc<\/span><span class=\"p\">,<\/span> <span class=\"k\">sizeof<\/span><span class=\"p\">(<\/span><span class=\"kt\">int<\/span><span class=\"p\">));<\/span>\r\n    <span class=\"n\">shm_toc_insert<\/span><span class=\"p\">(<\/span><span class=\"n\">pcxt<\/span><span class=\"o\">-&gt;<\/span><span class=\"n\">toc<\/span><span class=\"p\">,<\/span> <span class=\"n\">BAR_KEY<\/span><span class=\"p\">,<\/span> <span class=\"n\">shm_area<\/span><span class=\"p\">);<\/span>  <span class=\"cm\">\/* \u3042\u3068\u3067\u30ef\u30fc\u30ab\u30fc\u30d7\u30ed\u30bb\u30b9\u304c\u63a2\u305b\u308b\u3088\u3046\u306b\u30ad\u30fc(FOO_KEY)\u3092\u8a2d\u5b9a *\/<\/span>\r\n    <span class=\"o\">*<\/span><span class=\"n\">shm_area<\/span> <span class=\"o\">=<\/span> <span class=\"n\">n_bar<\/span><span class=\"p\">;<\/span>\r\n<span class=\"o\">:<\/span>\r\n\r\n<\/code><\/pre>\n<p>\u521b\u5efaToC\u4e3b\u8981\u6709\u4ee5\u4e0b\u4e24\u4e2a\u6b65\u9aa4\uff1a<br \/>\n1. \u4f7f\u7528shm_toc_allocate()\u5206\u914d\u5e76\u5207\u5272DSM\u533a\u57df\u3002\u2192 \u8fd4\u56de\u6307\u5411\u5207\u5272\u533a\u57df\u7684\u6307\u9488\u3002<br \/>\n2. \u4f7f\u7528shm_toc_insert()\u5c06\u5207\u5272\u7684\u533a\u57df\u4e0e\u952e\u4e00\u8d77\u6ce8\u518c\u5230ToC\u4e2d\u3002<br \/>\n\u7136\u540e\uff0c\u53ea\u9700\u5c06\u6570\u636e\u5b58\u50a8\u5728\u901a\u8fc7shm_toc_allocate()\u5206\u914d\u7684\u533a\u57df\u4e2d\uff0c\u5373\u53ef\u5728\u540e\u7eed\u5de5\u4f5c\u4eba\u5458\u4e2d\u5f15\u7528\u3002<\/p>\n<h1>\u5b9e\u65bd\u91cd\u70b92\uff1a\u4eceToC\u4e2d\u63d0\u53d6\u6570\u636e<\/h1>\n<p>\u7531\u4e8e\u5df2\u7ecf\u5b8c\u6210\u4e86ToC\u7684\u8bbe\u7f6e\uff0c\u5de5\u4f5c\u4eba\u5458\u5728\u542f\u52a8\u540e\u4f1a\u4eceToC\u4e2d\u81ea\u884c\u83b7\u53d6\u6570\u636e\u3002\u5728\u5f00\u5934\u7684\u4ee3\u7801\u793a\u4f8b\u4e2d\uff0c\u4ee5\u4e0b\u90e8\u5206\u9002\u7528\uff1a\u5de5\u4f5c\u4eba\u5458\u7684\u5165\u53e3\u51fd\u6570\u53c2\u6570\u5e94\u4e3a\uff08dsm_segment *seg\uff0cshm_toc *toc\uff09\uff0c\u4f7f\u7528shm_toc_lookup\uff08\uff09\u548c\u952e\u6765\u4ecetoc\u53d8\u91cf\u4e2d\u627e\u5230\u6240\u9700\u7684\u6570\u636e\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"cm\">\/* \u30ef\u30fc\u30ab\u30fc\u306e\u30a8\u30f3\u30c8\u30ea\u30dd\u30a4\u30f3\u30c8\u3068\u306a\u308b\u95a2\u6570 *\/<\/span>\r\n<span class=\"k\">static<\/span> <span class=\"kt\">void<\/span>\r\n<span class=\"nf\">parallel_worker<\/span><span class=\"p\">(<\/span><span class=\"n\">dsm_segment<\/span> <span class=\"o\">*<\/span><span class=\"n\">seg<\/span><span class=\"p\">,<\/span> <span class=\"n\">shm_toc<\/span> <span class=\"o\">*<\/span><span class=\"n\">toc<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">{<\/span>\r\n<span class=\"o\">:<\/span>\r\n    <span class=\"cm\">\/* FOO_KEY\u3092\u4f7f\u3063\u3066toc\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97 *\/<\/span>\r\n    <span class=\"n\">shm_area<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"kt\">int<\/span> <span class=\"o\">*<\/span><span class=\"p\">)<\/span> <span class=\"n\">shm_toc_lookup<\/span><span class=\"p\">(<\/span><span class=\"n\">toc<\/span><span class=\"p\">,<\/span> <span class=\"n\">FOO_KEY<\/span><span class=\"p\">);<\/span>\r\n    <span class=\"n\">n_foo<\/span> <span class=\"o\">=<\/span> <span class=\"o\">*<\/span><span class=\"n\">shm_area<\/span><span class=\"p\">;<\/span>\r\n\r\n    <span class=\"cm\">\/* BAR_KEY\u3092\u4f7f\u3063\u3066toc\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97 *\/<\/span>\r\n    <span class=\"n\">shm_area<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"kt\">int<\/span> <span class=\"o\">*<\/span><span class=\"p\">)<\/span> <span class=\"n\">shm_toc_lookup<\/span><span class=\"p\">(<\/span><span class=\"n\">toc<\/span><span class=\"p\">,<\/span> <span class=\"n\">BAR_KEY<\/span><span class=\"p\">);<\/span>\r\n    <span class=\"n\">n_bar<\/span> <span class=\"o\">=<\/span> <span class=\"o\">*<\/span><span class=\"n\">shm_area<\/span><span class=\"p\">;<\/span>\r\n<span class=\"o\">:<\/span>\r\n<\/code><\/pre>\n<h1>\u5176\u4ed6\uff1a\u5e73\u884c\u5de5\u4f5c\u8005\u548c\u9886\u5bfc\u8fc7\u7a0b<\/h1>\n<p>\u5f53\u5728\u6bcf\u4e2a\u573a\u5408\u4e0a\u9700\u8981\u8fdb\u884c\u81ea\u5df1\u7684\u5e76\u884c\u5904\u7406\u65f6\uff0c\u53ef\u4ee5\u8ba9\u6bcf\u4e2a\u5de5\u4f5c\u8005\u8fdb\u884c\u4e0d\u540c\u7684\u5904\u7406\uff0c\u6216\u8005\u5728\u5de5\u4f5c\u8005\u8fdb\u7a0b\u548c\u9886\u5bfc\u8fdb\u7a0b\u95f4\u5206\u914d\u5904\u7406\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">ParallelWorkerNumber\u5909\u6570<\/ul>\n<\/li>\n<\/ul>\n<p>\u30ef\u30fc\u30ab\u30fc\u6bce\u306b\u30e6\u30cb\u30fc\u30af\u306b\u3064\u3051\u3089\u308c\u305fID<br \/>\n\u30ea\u30fc\u30c0\u30fc\u30d7\u30ed\u30bb\u30b9\u306f-1\u3001\u30ef\u30fc\u30ab\u30fc\u30d7\u30ed\u30bb\u30b9\u306f0\u304b\u3089\u9806\u756a\u306b\u3064\u3051\u3089\u308c\u308b\u3002<\/p>\n<p>IsParallelWorker()\u30de\u30af\u30ed<\/p>\n<p>\u81ea\u5206\u304c\u30ea\u30fc\u30c0\u30fc\u304b\u3001\u30ef\u30fc\u30ab\u30fc\u304b\u3092\u5224\u5225\u3059\u308b\u3002<\/p>\n<h1>\u603b\u7ed3<\/h1>\n<p>\u672c\u6587\u91c7\u7528PostgreSQL\u7684\u5e76\u884c\u673a\u5236\u6765\u5bf9\u7b80\u5355\u5904\u7406\u8fdb\u884c\u5e76\u884c\u5316\u7684\u65b9\u6cd5\u8fdb\u884c\u4e86\u4ecb\u7ecd\u3002\u66f4\u8be6\u7ec6\u7684\u4fe1\u606f\u8bf7\u53c2\u9605PostgreSQL\u7684README.parallel\u6587\u4ef6\u3002<br \/>\npg_foobar\u62e5\u6709\u7528\u4e8e\u81ea\u5b9a\u4e49\u5e76\u884c\u5904\u7406\u6240\u9700\u7684\u6700\u57fa\u672c\u7684\u4ee3\u7801\uff0c\u56e0\u6b64\u53ef\u4ee5\u4f5c\u4e3a\u521b\u5efa\u81ea\u5b9a\u4e49\u5e76\u884c\u5904\u7406\u7684\u53c2\u8003\u3002\u4ece\u90a3\u91cc\u5f00\u59cb\uff0c\u6839\u636e\u4f7f\u7528\u65b9\u6cd5\uff0c\u65e0\u9650\u7684\u53ef\u80fd\u6027\u5c06\u5c55\u5f00\u3002\u60a8\u53ef\u4ee5\u8ba9\u4e3b\u8fdb\u7a0b\u5728\u7b49\u5f85\u671f\u95f4\u6267\u884c\u5176\u4ed6\u5904\u7406\u64cd\u4f5c\uff0c\u4e5f\u53ef\u4ee5\u901a\u8fc7DSM\u5171\u4eab\u6bcf\u4e2a\u5de5\u4f5c\u8fdb\u7a0b\u7684\u5904\u7406\u7ed3\u679c\uff0c\u7531\u4e3b\u8fdb\u7a0b\u5728\u6700\u540e\u8fdb\u884c\u805a\u5408\u3002\u60a8\u8fd8\u53ef\u4ee5\u51c6\u5907\u50cfbgworker\u8fd9\u6837\u7684\u5e38\u9a7b\u8fdb\u7a0b\uff0c\u5e76\u4ece\u90a3\u91cc\u542f\u52a8\u66f4\u591a\u7684\u5e76\u884c\u5de5\u4f5c\u8005\u3002\u8bf7\u5c1d\u8bd5\u521b\u5efa\u81ea\u5df1\u7684\u5e76\u884c\u5904\u7406\u5427\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8fd9\u7bc7\u6587\u7ae0\u662f\u201cPostgreSQL Advent Calendar 2016\u201d\u7b2c9\u5929\u7684\u6587\u7ae0\u3002 \u9996\u5148 \u6628\u5929\uff0c\u5f00\u53d1\u4e2d [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-41636","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PostgreSQL\u652f\u6301\u5e76\u884c\u7f16\u7a0b - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/postgresql\u652f\u6301\u5e76\u884c\u7f16\u7a0b\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL\u652f\u6301\u5e76\u884c\u7f16\u7a0b\" \/>\n<meta property=\"og:description\" content=\"\u8fd9\u7bc7\u6587\u7ae0\u662f\u201cPostgreSQL Advent Calendar 2016\u201d\u7b2c9\u5929\u7684\u6587\u7ae0\u3002 \u9996\u5148 \u6628\u5929\uff0c\u5f00\u53d1\u4e2d [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/postgresql\u652f\u6301\u5e76\u884c\u7f16\u7a0b\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-30T01:18:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-30T05:30:08+00:00\" \/>\n<meta name=\"author\" content=\"\u6587, \u7fd4\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6587, \u7fd4\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e6%94%af%e6%8c%81%e5%b9%b6%e8%a1%8c%e7%bc%96%e7%a8%8b%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e6%94%af%e6%8c%81%e5%b9%b6%e8%a1%8c%e7%bc%96%e7%a8%8b%e3%80%82\/\",\"name\":\"PostgreSQL\u652f\u6301\u5e76\u884c\u7f16\u7a0b - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-03-30T01:18:06+00:00\",\"dateModified\":\"2024-04-30T05:30:08+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e6%94%af%e6%8c%81%e5%b9%b6%e8%a1%8c%e7%bc%96%e7%a8%8b%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e6%94%af%e6%8c%81%e5%b9%b6%e8%a1%8c%e7%bc%96%e7%a8%8b%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e6%94%af%e6%8c%81%e5%b9%b6%e8%a1%8c%e7%bc%96%e7%a8%8b%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL\u652f\u6301\u5e76\u884c\u7f16\u7a0b\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c\",\"name\":\"\u6587, \u7fd4\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g\",\"caption\":\"\u6587, \u7fd4\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/wenxiang\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e6%94%af%e6%8c%81%e5%b9%b6%e8%a1%8c%e7%bc%96%e7%a8%8b%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PostgreSQL\u652f\u6301\u5e76\u884c\u7f16\u7a0b - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/postgresql\u652f\u6301\u5e76\u884c\u7f16\u7a0b\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"PostgreSQL\u652f\u6301\u5e76\u884c\u7f16\u7a0b","og_description":"\u8fd9\u7bc7\u6587\u7ae0\u662f\u201cPostgreSQL Advent Calendar 2016\u201d\u7b2c9\u5929\u7684\u6587\u7ae0\u3002 \u9996\u5148 \u6628\u5929\uff0c\u5f00\u53d1\u4e2d [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/postgresql\u652f\u6301\u5e76\u884c\u7f16\u7a0b\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-03-30T01:18:06+00:00","article_modified_time":"2024-04-30T05:30:08+00:00","author":"\u6587, \u7fd4","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6587, \u7fd4","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"3 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e6%94%af%e6%8c%81%e5%b9%b6%e8%a1%8c%e7%bc%96%e7%a8%8b%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e6%94%af%e6%8c%81%e5%b9%b6%e8%a1%8c%e7%bc%96%e7%a8%8b%e3%80%82\/","name":"PostgreSQL\u652f\u6301\u5e76\u884c\u7f16\u7a0b - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-03-30T01:18:06+00:00","dateModified":"2024-04-30T05:30:08+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e6%94%af%e6%8c%81%e5%b9%b6%e8%a1%8c%e7%bc%96%e7%a8%8b%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e6%94%af%e6%8c%81%e5%b9%b6%e8%a1%8c%e7%bc%96%e7%a8%8b%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e6%94%af%e6%8c%81%e5%b9%b6%e8%a1%8c%e7%bc%96%e7%a8%8b%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL\u652f\u6301\u5e76\u884c\u7f16\u7a0b"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c","name":"\u6587, \u7fd4","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g","caption":"\u6587, \u7fd4"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/wenxiang\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e6%94%af%e6%8c%81%e5%b9%b6%e8%a1%8c%e7%bc%96%e7%a8%8b%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41636","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=41636"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41636\/revisions"}],"predecessor-version":[{"id":92194,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41636\/revisions\/92194"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}