{"id":21982,"date":"2024-09-04T14:15:04","date_gmt":"2024-09-04T06:15:04","guid":{"rendered":"https:\/\/aif.amtbbs.org\/?p=21982"},"modified":"2024-09-04T14:15:04","modified_gmt":"2024-09-04T06:15:04","slug":"%e5%a4%a7%e5%a4%9a%e6%95%b0%e5%a4%84%e7%90%86%e6%97%b6%e5%ba%8f%e6%95%b0%e6%8d%ae%e7%9a%84%e5%9c%ba%e6%99%af%ef%bc%8c%e5%8f%af%e8%83%bd%e7%94%a8-postgresql-%e5%b0%b1%e5%a4%9f%e4%ba%86","status":"publish","type":"post","link":"https:\/\/aif.amtbbs.org\/index.php\/2024\/09\/04\/21982\/","title":{"rendered":"\u5927\u591a\u6570\u5904\u7406\u65f6\u5e8f\u6570\u636e\u7684\u573a\u666f\uff0c\u53ef\u80fd\u7528 PostgreSQL \u5c31\u591f\u4e86"},"content":{"rendered":"<div><img data-dominant-color=\"d2c4c7\" data-has-transparency=\"false\" style=\"--dominant-color: #d2c4c7;\" loading=\"lazy\" decoding=\"async\" class=\"not-transparent alignnone size-full wp-image-21984\" src=\"https:\/\/aiforumimage.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2024\/09\/9528bc7272b15e8e565310aeed060af2c5fb04-300x167-1.jpg\" width=\"300\" height=\"167\" alt=\"\" srcset=\"https:\/\/aiforumimage.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2024\/09\/9528bc7272b15e8e565310aeed060af2c5fb04-300x167-1.jpg 300w, https:\/\/aiforumimage.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2024\/09\/9528bc7272b15e8e565310aeed060af2c5fb04-300x167-1-150x84.jpg 150w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/div>\n<div class=\"article-desc\">\u73b0\u5728\u7269\u8054\u7f51\u573a\u666f\u4e0b\uff0c\u5f88\u591a\u7528\u6237\u90fd\u5728\u7528\u65f6\u5e8f\u6570\u636e\u5e93\u3002\u5b9e\u9645\u4e0a\uff0c\u5904\u7406\u65f6\u5e8f\u6570\u636e\u6bd4\u8f83\u65b9\u4fbf\u4e0a\u624b\u7684\u6570\u636e\u5e93\uff0c\u8fd8\u662f PostgreSQL \u8fd9\u6837\u7684\u901a\u7528\u6570\u636e\u5e93\u3002<\/div>\n<div id=\"postspictures\" class=\"article-content\">\n<div id=\"container\" class=\"container am-engine\" data-v-1d7a5742=\"\" data-element=\"root\">\n<p>\u65f6\u5e8f\u6570\u636e\u662f\u6309\u65f6\u95f4\u987a\u5e8f\u8fdb\u884c\u7d22\u5f15\u7684\u6570\u636e\u70b9\u5e8f\u5217\uff0c\u901a\u5e38\u5b58\u5728\u4e8e\u91d1\u878d\u3001\u79d1\u5b66\u548c\u5de5\u7a0b\u7b49\u5404\u4e2a\u9886\u57df\u3002PostgreSQL \u662f\u4e00\u4e2a\u529f\u80fd\u5f3a\u5927\u7684\u5f00\u6e90\u5173\u7cfb\u6570\u636e\u5e93\uff0c\u63d0\u4f9b\u4e86\u5f3a\u5927\u7684\u529f\u80fd\uff0c\u6765\u9ad8\u6548\u5730\u7ba1\u7406\u548c\u5206\u6790\u65f6\u5e8f\u6570\u636e\u3002\u5728\u672c\u6587\u4e2d\uff0c\u6211\u4eec\u5c06\u63a2\u7d22 PostgreSQL \u4e2d\u53ef\u7528\u4e8e\u5904\u7406\u6b64\u7c7b\u6570\u636e\u7684\u5de5\u5177\u548c\u6280\u672f\u3002<\/p>\n<h2>\u4e86\u89e3\u65f6\u5e8f\u6570\u636e\u7ed3\u6784<\/h2>\n<p>\u5728\u6df1\u5165\u63a2\u7d22\u64cd\u4f5c\u4e4b\u524d\uff0c\u6709\u6548\u5730\u6784\u5efa\u65f6\u5e8f\u6570\u636e\u81f3\u5173\u91cd\u8981\u3002PostgreSQL \u63d0\u4f9b\u4e86TIMESTAMP\u00a0\u548c\u00a0TIMESTAMPTZ\uff08\u5e26\u65f6\u533a\uff09\u6570\u636e\u7c7b\u578b\uff0c\u6765\u8bb0\u5f55\u4e0e\u65f6\u95f4\u76f8\u5173\u7684\u4fe1\u606f\u3002\u6b64\u5916\uff0c\u8303\u56f4\u548c\u6570\u7ec4\u5728\u5904\u7406\u65f6\u95f4\u6bb5\u6216\u591a\u4e2a\u65f6\u95f4\u6233\u65f6\u53ef\u80fd\u5f88\u6709\u7528\u3002<\/p>\n<div>\n<div class=\"hljs-cto\">\n<div class=\"hljs-cto\"><button class=\"copy_btn disable\" data-clipboard-target=\"#code_id_0\">\u590d\u5236<\/button><\/p>\n<div class=\"code-toolbar\">\n<pre class=\"has-pre-numbering language-sql\" tabindex=\"0\"><code class=\"language-sql\"><span class=\"token comment\">-- Creating a table with a TIMESTAMP column<\/span>\r\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">TABLE<\/span> temperature_readings <span class=\"token punctuation\">(<\/span>\r\n    id <span class=\"token keyword\">SERIAL<\/span> <span class=\"token keyword\">PRIMARY<\/span> <span class=\"token keyword\">KEY<\/span><span class=\"token punctuation\">,<\/span>\r\n    reading_time <span class=\"token keyword\">TIMESTAMP<\/span> <span class=\"token operator\">NOT<\/span> <span class=\"token boolean\">NULL<\/span><span class=\"token punctuation\">,<\/span>\r\n    <span class=\"token keyword\">value<\/span> <span class=\"token keyword\">DECIMAL<\/span> <span class=\"token operator\">NOT<\/span> <span class=\"token boolean\">NULL<\/span>\r\n<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/code><\/pre>\n<ul id=\"code_id_0\" class=\"pre-numbering\">\n<li>1.<\/li>\n<li>2.<\/li>\n<li>3.<\/li>\n<li>4.<\/li>\n<li>5.<\/li>\n<li>6.<\/li>\n<\/ul>\n<div class=\"toolbar\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h2>\u521b\u5efa\u7d22\u5f15\u63d0\u5347\u6027\u80fd<\/h2>\n<p>\u8981\u4f18\u5316\u5bf9\u65f6\u5e8f\u6570\u636e\u7684\u67e5\u8be2\uff0c\u7d22\u5f15\u662f\u5173\u952e\u3002B \u6811\u7d22\u5f15\u4e4b\u6240\u4ee5\u88ab\u5e7f\u6cdb\u4f7f\u7528\uff0c\u662f\u56e0\u4e3a\u5b83\u5728\u901a\u5e38\u4e0e\u65f6\u5e8f\u6570\u636e\u5173\u8054\u7684\u8303\u56f4\u67e5\u8be2\u4e2d\u6548\u7387\u5f88\u9ad8\u3002<\/p>\n<div>\n<div class=\"hljs-cto\">\n<div class=\"hljs-cto\"><button class=\"copy_btn disable\" data-clipboard-target=\"#code_id_1\">\u590d\u5236<\/button><\/p>\n<div class=\"code-toolbar\">\n<pre class=\"has-pre-numbering language-sql\" tabindex=\"0\"><code class=\"language-sql\"><span class=\"token comment\">-- Creating an index on the reading_time column<\/span>\r\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">INDEX<\/span> idx_reading_time <span class=\"token keyword\">ON<\/span> temperature_readings <span class=\"token punctuation\">(<\/span>reading_time<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/code><\/pre>\n<ul id=\"code_id_1\" class=\"pre-numbering\">\n<li>1.<\/li>\n<li>2.<\/li>\n<\/ul>\n<div class=\"toolbar\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h2>\u67e5\u8be2\u65f6\u5e8f\u6570\u636e<\/h2>\n<p>\u68c0\u7d22\u65f6\u5e8f\u6570\u636e\uff0c\u901a\u5e38\u4f1a\u6d89\u53ca\u67e5\u8be2\u7279\u5b9a\u65f6\u95f4\u8303\u56f4\u5185\u7684\u8bb0\u5f55\u3002\u8fd9\u53ef\u4ee5\u4f7f\u7528&gt;\u3001&lt;\u6216BETWEEN\u7b49\u8303\u56f4\u8fd0\u7b97\u7b26\u6765\u5b8c\u6210\u3002<\/p>\n<div>\n<div class=\"hljs-cto\">\n<div class=\"hljs-cto\"><button class=\"copy_btn disable\" data-clipboard-target=\"#code_id_2\">\u590d\u5236<\/button><\/p>\n<div class=\"code-toolbar\">\n<pre class=\"has-pre-numbering language-sql\" tabindex=\"0\"><code class=\"language-sql\"><span class=\"token comment\">-- Selecting records from the last 24 hours<\/span>\r\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> temperature_readings\r\n<span class=\"token keyword\">WHERE<\/span> reading_time <span class=\"token operator\">&gt;<\/span> <span class=\"token function\">NOW<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">-<\/span> <span class=\"token keyword\">INTERVAL<\/span> <span class=\"token string\">'1 day'<\/span><span class=\"token punctuation\">;<\/span>\r\n\r\n<span class=\"token comment\">-- Selecting records between two timestamps<\/span>\r\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> temperature_readings\r\n<span class=\"token keyword\">WHERE<\/span> reading_time <span class=\"token operator\">BETWEEN<\/span> <span class=\"token string\">'2023-01-01 00:00:00'<\/span> <span class=\"token operator\">AND<\/span> <span class=\"token string\">'2023-01-02 00:00:00'<\/span><span class=\"token punctuation\">;<\/span><\/code><\/pre>\n<ul id=\"code_id_2\" class=\"pre-numbering\">\n<li>1.<\/li>\n<li>2.<\/li>\n<li>3.<\/li>\n<li>4.<\/li>\n<li>5.<\/li>\n<li>6.<\/li>\n<li>7.<\/li>\n<\/ul>\n<div class=\"toolbar\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h2>\u805a\u5408\u65f6\u5e8f\u6570\u636e<\/h2>\n<p>\u805a\u5408\u51fd\u6570\uff08\u5982SUM()\uff0cAVG()\u6216COUNT()\uff09\u5bf9\u4e8e\u5206\u6790\u65f6\u5e8f\u6570\u636e\u81f3\u5173\u91cd\u8981\u3002\u53ef\u4ee5\u4f7f\u7528date_trunc()\u51fd\u6570\u5b9e\u73b0\u6309\u65f6\u95f4\u95f4\u9694\u5206\u7ec4\u3002<\/p>\n<div>\n<div class=\"hljs-cto\">\n<div class=\"hljs-cto\"><button class=\"copy_btn disable\" data-clipboard-target=\"#code_id_3\">\u590d\u5236<\/button><\/p>\n<div class=\"code-toolbar\">\n<pre class=\"has-pre-numbering language-sql\" tabindex=\"0\"><code class=\"language-sql\"><span class=\"token comment\">-- Averaging values by hour<\/span>\r\n<span class=\"token keyword\">SELECT<\/span> date_trunc<span class=\"token punctuation\">(<\/span><span class=\"token string\">'hour'<\/span><span class=\"token punctuation\">,<\/span> reading_time<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> <span class=\"token keyword\">hour<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token function\">AVG<\/span><span class=\"token punctuation\">(<\/span><span class=\"token keyword\">value<\/span><span class=\"token punctuation\">)<\/span>\r\n<span class=\"token keyword\">FROM<\/span> temperature_readings\r\n<span class=\"token keyword\">GROUP<\/span> <span class=\"token keyword\">BY<\/span> <span class=\"token keyword\">hour<\/span>\r\n<span class=\"token keyword\">ORDER<\/span> <span class=\"token keyword\">BY<\/span> <span class=\"token keyword\">hour<\/span><span class=\"token punctuation\">;<\/span><\/code><\/pre>\n<ul id=\"code_id_3\" class=\"pre-numbering\">\n<li>1.<\/li>\n<li>2.<\/li>\n<li>3.<\/li>\n<li>4.<\/li>\n<li>5.<\/li>\n<\/ul>\n<div class=\"toolbar\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h2>\u6301\u7eed\u805a\u5408\u548c\u7269\u5316\u89c6\u56fe<\/h2>\n<p>\u5728\u6027\u80fd\u8981\u6c42\u5f88\u9ad8\u7684\u60c5\u51b5\u4e0b\uff0c\u6301\u7eed\u805a\u5408\u548c\u7269\u5316\u89c6\u56fe\u5c31\u53ef\u4ee5\u53d1\u6325\u4f5c\u7528\u4e86\u3002\u5b83\u4eec\u5b58\u50a8\u590d\u6742\u67e5\u8be2\u7684\u7ed3\u679c\uff0c\u5e76\u4e14\u53ef\u4ee5\u663e\u8457\u52a0\u5feb\u6570\u636e\u68c0\u7d22\u901f\u5ea6\u3002<\/p>\n<div>\n<div class=\"hljs-cto\">\n<div class=\"hljs-cto\"><button class=\"copy_btn disable\" data-clipboard-target=\"#code_id_4\">\u590d\u5236<\/button><\/p>\n<div class=\"code-toolbar\">\n<pre class=\"has-pre-numbering language-sql\" tabindex=\"0\"><code class=\"language-sql\"><span class=\"token comment\">-- Creating a materialized view for daily averages<\/span>\r\n<span class=\"token keyword\">CREATE<\/span> MATERIALIZED <span class=\"token keyword\">VIEW<\/span> daily_avg <span class=\"token keyword\">AS<\/span>\r\n<span class=\"token keyword\">SELECT<\/span> date_trunc<span class=\"token punctuation\">(<\/span><span class=\"token string\">'day'<\/span><span class=\"token punctuation\">,<\/span> reading_time<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> <span class=\"token keyword\">day<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token function\">AVG<\/span><span class=\"token punctuation\">(<\/span><span class=\"token keyword\">value<\/span><span class=\"token punctuation\">)<\/span>\r\n<span class=\"token keyword\">FROM<\/span> temperature_readings\r\n<span class=\"token keyword\">GROUP<\/span> <span class=\"token keyword\">BY<\/span> <span class=\"token keyword\">day<\/span><span class=\"token punctuation\">;<\/span><\/code><\/pre>\n<ul id=\"code_id_4\" class=\"pre-numbering\">\n<li>1.<\/li>\n<li>2.<\/li>\n<li>3.<\/li>\n<li>4.<\/li>\n<li>5.<\/li>\n<\/ul>\n<div class=\"toolbar\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h2>\u7ed3\u8bba<\/h2>\n<p>PostgreSQL \u4e30\u5bcc\u7684\u7279\u6027\u96c6\u5408\uff0c\u4f7f\u5176\u6210\u4e3a\u5904\u7406\u65f6\u5e8f\u6570\u636e\u7684\u7edd\u4f73\u9009\u62e9\u3002\u4e86\u89e3\u5982\u4f55\u5229\u7528\u5176\u529f\u80fd\uff0c\u53ef\u4ee5\u663e\u8457\u63d0\u9ad8\u5904\u7406\u65f6\u6001\u6570\u636e\u96c6\u7684\u5e94\u7528\u7a0b\u5e8f\u7684\u6027\u80fd\u548c\u6269\u5c55\u6027\u3002<\/p>\n<\/div>\n<\/div>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_21982\" class=\"pvc_stats total_only  \" data-element-id=\"21982\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.0\" viewBox=\"0 0 502 315\" preserveAspectRatio=\"xMidYMid meet\"><g transform=\"translate(0,332) scale(0.1,-0.1)\" fill=\"\" stroke=\"none\"><path d=\"M2394 3279 l-29 -30 -3 -207 c-2 -182 0 -211 15 -242 39 -76 157 -76 196 0 15 31 17 60 15 243 l-3 209 -33 29 c-26 23 -41 29 -80 29 -41 0 -53 -5 -78 -31z\"\/><path d=\"M3085 3251 c-45 -19 -58 -50 -96 -229 -47 -217 -49 -260 -13 -295 52 -53 146 -42 177 20 16 31 87 366 87 410 0 70 -86 122 -155 94z\"\/><path d=\"M1751 3234 c-13 -9 -29 -31 -37 -50 -12 -29 -10 -49 21 -204 19 -94 39 -189 45 -210 14 -50 54 -80 110 -80 34 0 48 6 76 34 21 21 34 44 34 59 0 14 -18 113 -40 219 -37 178 -43 195 -70 221 -36 32 -101 37 -139 11z\"\/><path d=\"M1163 3073 c-36 -7 -73 -59 -73 -102 0 -56 133 -378 171 -413 34 -32 83 -37 129 -13 70 36 67 87 -16 290 -86 209 -89 214 -129 231 -35 14 -42 15 -82 7z\"\/><path d=\"M3689 3066 c-15 -9 -33 -30 -42 -48 -48 -103 -147 -355 -147 -375 0 -98 131 -148 192 -74 13 15 57 108 97 206 80 196 84 226 37 273 -30 30 -99 39 -137 18z\"\/><path d=\"M583 2784 c-38 -19 -67 -74 -58 -113 9 -42 211 -354 242 -373 16 -10 45 -18 66 -18 51 0 107 52 107 100 0 39 -1 41 -124 234 -80 126 -108 162 -133 173 -41 17 -61 16 -100 -3z\"\/><path d=\"M4250 2784 c-14 -9 -74 -91 -133 -183 -95 -150 -107 -173 -107 -213 0 -55 33 -94 87 -104 67 -13 90 8 211 198 130 202 137 225 78 284 -27 27 -42 34 -72 34 -22 0 -50 -8 -64 -16z\"\/><path d=\"M2275 2693 c-553 -48 -1095 -270 -1585 -649 -135 -104 -459 -423 -483 -476 -23 -49 -22 -139 2 -186 73 -142 361 -457 571 -626 285 -228 642 -407 990 -497 242 -63 336 -73 660 -74 310 0 370 5 595 52 535 111 1045 392 1455 803 122 121 250 273 275 326 19 41 19 137 0 174 -41 79 -309 363 -465 492 -447 370 -946 591 -1479 653 -113 14 -422 18 -536 8z m395 -428 c171 -34 330 -124 456 -258 112 -119 167 -219 211 -378 27 -96 24 -300 -5 -401 -72 -255 -236 -447 -474 -557 -132 -62 -201 -76 -368 -76 -167 0 -236 14 -368 76 -213 98 -373 271 -451 485 -162 444 86 934 547 1084 153 49 292 57 452 25z m909 -232 c222 -123 408 -262 593 -441 76 -74 138 -139 138 -144 0 -16 -233 -242 -330 -319 -155 -123 -309 -223 -461 -299 l-81 -41 32 46 c18 26 49 83 70 128 143 306 141 649 -6 957 -25 52 -61 116 -79 142 l-34 47 45 -20 c26 -10 76 -36 113 -56z m-2057 25 c-40 -58 -105 -190 -130 -263 -110 -324 -59 -707 132 -981 25 -35 42 -64 37 -64 -19 0 -241 119 -326 174 -188 122 -406 314 -532 468 l-58 71 108 103 c185 178 428 349 672 473 66 33 121 60 123 61 2 0 -10 -19 -26 -42z\"\/><path d=\"M2375 1950 c-198 -44 -350 -190 -395 -379 -18 -76 -8 -221 19 -290 114 -284 457 -406 731 -260 98 52 188 154 231 260 27 69 37 214 19 290 -38 163 -166 304 -326 360 -67 23 -215 33 -279 19z\"\/><\/g><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/aif.amtbbs.org\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u73b0\u5728\u7269\u8054\u7f51\u573a\u666f\u4e0b\uff0c\u5f88\u591a\u7528\u6237\u90fd\u5728\u7528\u65f6\u5e8f\u6570\u636e\u5e93\u3002\u5b9e\u9645\u4e0a\uff0c\u5904\u7406\u65f6\u5e8f\u6570\u636e\u6bd4\u8f83\u65b9\u4fbf\u4e0a\u624b\u7684\u6570\u636e\u5e93\uff0c\u8fd8\u662f PostgreSQ [&hellip;]<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_21982\" class=\"pvc_stats total_only  \" data-element-id=\"21982\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.0\" viewBox=\"0 0 502 315\" preserveAspectRatio=\"xMidYMid meet\"><g transform=\"translate(0,332) scale(0.1,-0.1)\" fill=\"\" stroke=\"none\"><path d=\"M2394 3279 l-29 -30 -3 -207 c-2 -182 0 -211 15 -242 39 -76 157 -76 196 0 15 31 17 60 15 243 l-3 209 -33 29 c-26 23 -41 29 -80 29 -41 0 -53 -5 -78 -31z\"\/><path d=\"M3085 3251 c-45 -19 -58 -50 -96 -229 -47 -217 -49 -260 -13 -295 52 -53 146 -42 177 20 16 31 87 366 87 410 0 70 -86 122 -155 94z\"\/><path d=\"M1751 3234 c-13 -9 -29 -31 -37 -50 -12 -29 -10 -49 21 -204 19 -94 39 -189 45 -210 14 -50 54 -80 110 -80 34 0 48 6 76 34 21 21 34 44 34 59 0 14 -18 113 -40 219 -37 178 -43 195 -70 221 -36 32 -101 37 -139 11z\"\/><path d=\"M1163 3073 c-36 -7 -73 -59 -73 -102 0 -56 133 -378 171 -413 34 -32 83 -37 129 -13 70 36 67 87 -16 290 -86 209 -89 214 -129 231 -35 14 -42 15 -82 7z\"\/><path d=\"M3689 3066 c-15 -9 -33 -30 -42 -48 -48 -103 -147 -355 -147 -375 0 -98 131 -148 192 -74 13 15 57 108 97 206 80 196 84 226 37 273 -30 30 -99 39 -137 18z\"\/><path d=\"M583 2784 c-38 -19 -67 -74 -58 -113 9 -42 211 -354 242 -373 16 -10 45 -18 66 -18 51 0 107 52 107 100 0 39 -1 41 -124 234 -80 126 -108 162 -133 173 -41 17 -61 16 -100 -3z\"\/><path d=\"M4250 2784 c-14 -9 -74 -91 -133 -183 -95 -150 -107 -173 -107 -213 0 -55 33 -94 87 -104 67 -13 90 8 211 198 130 202 137 225 78 284 -27 27 -42 34 -72 34 -22 0 -50 -8 -64 -16z\"\/><path d=\"M2275 2693 c-553 -48 -1095 -270 -1585 -649 -135 -104 -459 -423 -483 -476 -23 -49 -22 -139 2 -186 73 -142 361 -457 571 -626 285 -228 642 -407 990 -497 242 -63 336 -73 660 -74 310 0 370 5 595 52 535 111 1045 392 1455 803 122 121 250 273 275 326 19 41 19 137 0 174 -41 79 -309 363 -465 492 -447 370 -946 591 -1479 653 -113 14 -422 18 -536 8z m395 -428 c171 -34 330 -124 456 -258 112 -119 167 -219 211 -378 27 -96 24 -300 -5 -401 -72 -255 -236 -447 -474 -557 -132 -62 -201 -76 -368 -76 -167 0 -236 14 -368 76 -213 98 -373 271 -451 485 -162 444 86 934 547 1084 153 49 292 57 452 25z m909 -232 c222 -123 408 -262 593 -441 76 -74 138 -139 138 -144 0 -16 -233 -242 -330 -319 -155 -123 -309 -223 -461 -299 l-81 -41 32 46 c18 26 49 83 70 128 143 306 141 649 -6 957 -25 52 -61 116 -79 142 l-34 47 45 -20 c26 -10 76 -36 113 -56z m-2057 25 c-40 -58 -105 -190 -130 -263 -110 -324 -59 -707 132 -981 25 -35 42 -64 37 -64 -19 0 -241 119 -326 174 -188 122 -406 314 -532 468 l-58 71 108 103 c185 178 428 349 672 473 66 33 121 60 123 61 2 0 -10 -19 -26 -42z\"\/><path d=\"M2375 1950 c-198 -44 -350 -190 -395 -379 -18 -76 -8 -221 19 -290 114 -284 457 -406 731 -260 98 52 188 154 231 260 27 69 37 214 19 290 -38 163 -166 304 -326 360 -67 23 -215 33 -279 19z\"\/><\/g><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/aif.amtbbs.org\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":56,"featured_media":21984,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,80,11],"tags":[1286],"class_list":["post-21982","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-23","category-80","category-11","tag-postgresql--"],"_links":{"self":[{"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/posts\/21982","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/users\/56"}],"replies":[{"embeddable":true,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/comments?post=21982"}],"version-history":[{"count":1,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/posts\/21982\/revisions"}],"predecessor-version":[{"id":21985,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/posts\/21982\/revisions\/21985"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/media\/21984"}],"wp:attachment":[{"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/media?parent=21982"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/categories?post=21982"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/tags?post=21982"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}