{"id":1000,"date":"2020-12-15T11:05:52","date_gmt":"2020-12-15T02:05:52","guid":{"rendered":"https:\/\/azbase-azbase-dev2.azurewebsites.net\/ja-jp\/events\/azurebase\/?p=1000"},"modified":"2022-09-16T12:23:32","modified_gmt":"2022-09-16T03:23:32","slug":"citus-9-4-whats-new","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/blog\/citus-9-4-whats-new\/","title":{"rendered":"Postgres \u306eCitus \u62e1\u5f35\u6a5f\u80fd\u306e\u6700\u65b0\u30ea\u30ea\u30fc\u30b9 Citus 9.4 \u306b\u3064\u3044\u3066"},"content":{"rendered":"<p class=\"c-paragraph-3\">\n    \u203b\u672c\u30d6\u30ed\u30b0\u306f\u3001\u2018\u2019<a href=\"https:\/\/www.citusdata.com\/blog\/2020\/09\/05\/citus-9-4-whats-new\/\" class=\"c-hyperlink\">What\u2019s new in the Citus 9.4 extension to Postgres (citusdata.com)<\/a>\u2018\u2019\u306e\u6284\u8a33\u3067\u3059\u3002\n<\/p>\n<p class=\"c-paragraph-3\">\n    Postgres \u306e<a href=\"https:\/\/github.com\/citusdata\/citus\" class=\"c-hyperlink\" aria-label=\"Citus \u62e1\u5f35: Postgres \u306eCitus \u62e1\u5f35\u6a5f\u80fd\u306e\u6700\u65b0\u30ea\u30ea\u30fc\u30b9\u306fCitus 9.4\u3067\u3059\">Citus \u62e1\u5f35<\/a><u>\u6a5f\u80fd<\/u>\u306e\u6700\u65b0\u30ea\u30ea\u30fc\u30b9\u306fCitus 9.4\u3067\u3059\u3002\u99b4\u67d3\u307f\u304c\u306a\u3044\u65b9\u306b\u7c21\u5358\u306b\u8aac\u660e\u3057\u3066\u304a\u304f\u3068\u3001Citus \u306f Postgres \u3092\u5206\u6563\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5909\u63db\u3057\u3001\u30c7\u30fc\u30bf\u3068 SQL \u30af\u30a8\u30ea\u3092\u8907\u6570\u306e\u30ce\u30fc\u30c9\u306b\u5206\u6563\u3055\u305b\u307e\u3059\u3002\u3053\u306e\u6295\u7a3f\u306f\u5b9f\u8cea\u7684\u306b\u306f Citus 9.4 \u306e\u30ea\u30ea\u30fc\u30b9\u30ce\u30fc\u30c8\u3067\u3059\u3002\n<\/p>\n<p class=\"c-paragraph-3\">\n    Citus \u3092\u4f7f\u3044\u59cb\u3081\u308b\u6e96\u5099\u304c\u3067\u304d\u3066\u3044\u308b\u306a\u3089\u30019.4 \u7528\u306e Citus \u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u7c21\u5358\u306b<a href=\"https:\/\/www.citusdata.com\/download\/\" class=\"c-hyperlink\" aria-label=\"\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9: 9.4\u7528\u306eCitus\u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u7c21\u5358\u306b\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u306b\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002\">\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/a>\u3067\u304d\u307e\u3059\u3002\n<\/p>\n<p class=\"c-paragraph-3\">\n    \u8a73\u7d30\u3092\u77e5\u308b\u306b\u306f <a href=\"https:\/\/docs.citusdata.com\/\" class=\"c-hyperlink\" aria-label=\"docs.citusdata.com: Citus\u306e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u306b\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">docs.citusdata.com<\/a> \u3092\u78ba\u8a8d\u3059\u308b\u306e\u304c\u5e38\u306b\u304a\u52e7\u3081\u306e\u65b9\u6cd5\u3067\u3059\u3002Citus \u306e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u306f\u3001\u6b63\u78ba\u306a\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3001\u3059\u3079\u3066\u306e Citus \u6a5f\u80fd\u306e\u8a73\u7d30\u3001\u91cd\u8981\u306a\u6982\u5ff5\u306e\u8aac\u660e\uff08<a href=\"https:\/\/docs.citusdata.com\/en\/stable\/sharding\/data_modeling.html#choosing-distribution-column\" class=\"c-hyperlink\" aria-label=\"\u5206\u6563\u5217: \u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001\u5206\u6563\u5217\u306e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u30a2\u30af\u30bb\u30b9\u3057\u307e\u3059\u3002\">\u5206\u6563\u5217<\/a>\u306e\u9078\u629e\u306a\u3069\uff09\u3001\u5358\u4e00\u306e\u30b5\u30fc\u30d0\u30fc\u3067Citus\u3092\u624b\u5143\u306b\u69cb\u7bc9\u3059\u308b\u65b9\u6cd5\u3001\u8907\u6570\u306e\u30b5\u30fc\u30d0\u30fc\u306bCitus\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u65b9\u6cd5\u3001\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u5206\u6790\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u3092\u69cb\u7bc9\u3059\u308b\u65b9\u6cd5\u3001\u30de\u30eb\u30c1\u30c6\u30ca\u30f3\u30c8\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u69cb\u7bc9\u65b9\u6cd5\u306a\u3069\u304c\u3042\u308a\u307e\u3059\u3002\n<\/p>\n<p class=\"c-paragraph-3\">\n    \u3088\u308a\u9ad8\u5ea6\u306a\u30ea\u30bd\u30fc\u30b9\u3068\u3057\u3066\u3001<a href=\"https:\/\/github.com\/citusdata\/citus\" class=\"c-hyperlink\" ari-label=\"Citus \u306e\u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u30ec\u30dd\u30b8\u30c8\u30ea\u30fc: Citus\u306e\u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u30ea\u30dd\u30b8\u30c8\u30ea\u306e\u5b9f\u969b\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3092\u898b\u308b\u306b\u306f\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">Citus \u306e\u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u30ec\u30dd\u30b8\u30c8\u30ea\u30fc<\/a>\u3067\u5b9f\u969b\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3092\u898b\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u306e\u3067\u3001\u79c1\u305f\u3061\u304c\u4f55\u3092\u3057\u3066\u3044\u308b\u306e\u304b\u3001\u305d\u3057\u3066Postgres \u306e Citus \u62e1\u5f35\u6a5f\u80fd\u306e\u5c06\u6765\u306e\u30ea\u30ea\u30fc\u30b9\u3067\u4f55\u304c\u8d77\u3053\u308b\u304b\u3092\u898b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<strong>\u00a0<\/strong>\n<\/p>\n<p><span style=\"font-size: 18pt;\"><strong>Citus 9.4<\/strong><strong>\u306e\u65b0\u6a5f\u80fd<\/strong><\/span><\/p>\n<p class=\"c-paragraph-3\">\n    Citus 9.4 \u306e\u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u306e\u30d1\u30c3\u30b1\u30fc\u30b8\u3068\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306f\u3059\u3067\u306b\u516c\u958b\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3001Citus 9.4 \u3067\u6ce8\u76ee\u3059\u3079\u304d\u65b0\u6a5f\u80fd\u5168\u3066\u3092\u898b\u308b\u306b\u306f\u826f\u3044\u30bf\u30a4\u30df\u30f3\u30b0\u3060\u3068\u601d\u3044\u307e\u3059\u3002\u4ed6\u306e\u6700\u8fd1\u306e\u30ea\u30ea\u30fc\u30b9\u306b\u3064\u3044\u3066\u77e5\u308a\u305f\u3044\u5834\u5408\u306f\u3001<a href=\"https:\/\/www.citusdata.com\/blog\/2020\/06\/13\/citus-9-3-release-notes\/\" class=\"c-hyperlink\" aria-label=\"Citus 9.3\u306e\u30ea\u30ea\u30fc\u30b9\u30ce\u30fc\u30c8: \u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30e1\u30e2\u3092\u30c1\u30a7\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">Citus 9.3\u306e\u30ea\u30ea\u30fc\u30b9\u30ce\u30fc\u30c8<\/a>\u3084\u3001HTAP\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u6539\u826f\u5168\u3066\u306b\u3064\u3044\u3066\u306f<a href=\"https:\/\/www.citusdata.com\/blog\/2020\/03\/02\/citus-9-2-speeds-up-large-scale-htap\/\" class=\"c-hyperlink\" aria-label=\"Citus 9.2: \u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30e1\u30e2\u3092\u30c1\u30a7\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">Citus 9.2<\/a><u>\u306e\u30ea\u30ea\u30fc\u30b9\u30ce\u30fc\u30c8<\/u> \u3092\u8997\u3044\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002\n<\/p>\n<p>    Citus 9.4 \u306e\u65b0\u6a5f\u80fd\u3092\u6df1\u6398\u308a\u3059\u308b\u524d\u306b\u3001\u6982\u8981\u3092\u4ee5\u4e0b\u306b\u793a\u3057\u307e\u3059\uff1a<\/p>\n<ul style=\"list-style-type: disc;\">\n<li>EXPLAIN ANALYZE\u306e\u6539\u826f<\/li>\n<li>INSERT INTO \u30ed\u30fc\u30ab\u30eb\u30c6\u30fc\u30d6\u30eb SELECT .. FROM \u5206\u6563\u30c6\u30fc\u30d6\u30eb<\/li>\n<li>\u30ed\u30fc\u30ab\u30eb \u30c6\u30fc\u30d6\u30eb\u3068 CTE \u9593\u306e\u7d50\u5408<\/li>\n<li>COPY \u306e\u30b3\u30cd\u30af\u30b7\u30e7\u30f3\u7ba1\u7406<\/li>\n<li>t-digest \u306b\u3088\u308b\u30d1\u30fc\u30bb\u30f3\u30bf\u30a4\u30eb\u306e\u8a08\u7b97\u306e\u30b9\u30b1\u30fc\u30eb<\/li>\n<li>\u30eb\u30fc\u30bf \u30af\u30a8\u30ea\u3067\u306e CTE \u306e\u843d\u3068\u3057\u8fbc\u307f\u306e\u4fee\u6b63<\/li>\n<li>\u30d0\u30a4\u30ca\u30ea \u30d7\u30ed\u30c8\u30b3\u30eb\u306e\u8ffd\u52a0\u30b5\u30dd\u30fc\u30c8<\/li>\n<li>Citus \u306e\u30c0\u30a6\u30f3\u30b0\u30ec\u30fc\u30c9 \u30b9\u30af\u30ea\u30d7\u30c8<\/li>\n<\/ul>\n<p><span style=\"font-size: 18pt;\"><strong>EXPLAIN ANALYZE <\/strong><strong>\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u7406\u89e3<\/strong><\/span><\/p>\n<p class=\"c-paragraph-3\">\n    Postgres\u306e EXPLAIN ANALYZE \u30b3\u30de\u30f3\u30c9\u306f\u3001<a href=\"https:\/\/docs.citusdata.com\/en\/stable\/performance\/performance_tuning.html#postgresql-tuning\" class=\"c-hyperlink\" aria-label=\"\u30af\u30a8\u30ea\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u7406\u89e3: PostgreSQL\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u306b\u3064\u3044\u3066\u5b66\u3076\u306b\u306f\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u30af\u30a8\u30ea\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u7406\u89e3<\/a>\u3059\u308b\u305f\u3081\u306b\u4e0d\u53ef\u6b20\u3067\u3059\u3002Citus 9.4 \u3067\u306f\u3001EXPLAIN ANALYZE \u304c Citus \u3067\u3069\u306e\u3088\u3046\u306b\u52d5\u4f5c\u3059\u308b\u304b\u3092\u6539\u5584\u3057\u3001\u5206\u6563\u3057\u305f Citus \u30af\u30a8\u30ea\u306b\u95a2\u3059\u308b\u8a73\u7d30\u306a\u60c5\u5831\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002\n<\/p>\n<p class=\"c-paragraph-3\">\n    Citus \u306e\u5185\u90e8\u3092\u8997\u304f\u3068\uff08<a href=\"https:\/\/github.com\/citusdata\/citus\" class=\"c-hyperlink\" aria-label=\"Citus: Github \u3092\u958b\u3044\u3066 Citus \u306b\u3064\u3044\u3066\u77e5\u308b\u306b\u306f\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002\">Citus<\/a> \u306f\u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u3067\u3059\uff09\u3001Citus\u306e EXPLAIN ANALYZE \u30b3\u30de\u30f3\u30c9\u306f\u3001\u5206\u6563\u3057\u305f Citus \u30af\u30a8\u30ea\u3092 2 \u56de\u5b9f\u884c\u3059\u308b\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3059\u3002\u4e00\u5ea6\u3001Citus \u306e\u30b3\u30fc\u30c7\u30a3\u30cd\u30fc\u30bf\u30fc \u30ce\u30fc\u30c9\u4e0a\u3067 EXPLAIN \u306e\u30d7\u30e9\u30f3\u3092\u69cb\u7bc9\u3059\u308b\u305f\u3081\u306b\u30ef\u30fc\u30ab\u30fc \u30ce\u30fc\u30c9\u304b\u3089\u7d50\u679c\u3092\u5f97\u3066\u3001\u305d\u3057\u3066\u518d\u3073 Citus \u306e\u30ef\u30fc\u30ab\u30fc\u30ce\u30fc\u30c9\u304b\u3089 EXPLAIN \u306e\u30d7\u30e9\u30f3\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<span style=\"text-decoration: line-through;\">\u00a0<\/span>\n<\/p>\n<p class=\"c-paragraph-3\">\n    \u3053\u306e 2 \u6bb5\u968e\u306e\u30a2\u30d7\u30ed\u30fc\u30c1\u3067\u306f\u3001EXPLAIN \u304c\u5e38\u306b\u30ad\u30e3\u30c3\u30b7\u30e5\u306b\u30d2\u30c3\u30c8\u3059\u308b\u305f\u3081\u3001\u983b\u7e41\u306b\u30ad\u30e3\u30c3\u30b7\u30e5 \u30df\u30b9\u304c\u767a\u751f\u3059\u308b\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u3067\u306f\u8aa4\u89e3\u3092\u62db\u304f\u7d50\u679c\u304c\u751f\u3058\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\n<\/p>\n<p class=\"c-paragraph-3\">\n    Citus 9.4\u3067\u306f\u30012\u3064\u306e\u30b9\u30c6\u30c3\u30d7\u30921\u3064\u306b\u7d44\u307f\u5408\u308f\u305b\u3066\u3001\u3088\u308a\u6b63\u78ba\u306aEXPLAIN ANALYZE \u306e\u7d50\u679c\u304c\u5f97\u3089\u308c\u307e\u3059\u3002\u3055\u3089\u306b\u3001\u5206\u6563\u3057\u305f Citus \u306e\u30af\u30a8\u30ea\u306e\u3059\u3079\u3066\u306e\u30bf\u30b9\u30af\u3092\u8aac\u660e\u3059\u308b\u969b\u306b\u3001\u30af\u30e9\u30b9\u30bf\u5168\u4f53\u3067\u540c\u6642\u306b EXPLAIN \u30d7\u30e9\u30f3\u3092\u4f5c\u6210\u3057\u3001EXPLAIN ANALYZE \u306e\u7d50\u679c\u3092\u306f\u308b\u304b\u306b\u9ad8\u901f\u306b\u5b9f\u884c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002\u3053\u306e\u65b0\u3057\u3044\u30a2\u30d7\u30ed\u30fc\u30c1\u3067\u306f\u3001INSERT\u3084\u305d\u306e\u4ed6\u306e DML \u30b3\u30de\u30f3\u30c9\u306b\u5bfe\u3059\u308bEXPLAIN ANALYZE \u3082\u6709\u52b9\u306b\u306a\u308a\u307e\u3059\u3002\n<\/p>\n<p>    Citus \u306b\u95a2\u9023\u3059\u308b\u4ee5\u4e0b\u306e\u60c5\u5831\u3082\u8ffd\u52a0\u3057\u307e\u3057\u305f\uff1a<\/p>\n<ul class=\"c-list\">\n<li>EXPLAIN\u306b\u3088\u308b\u3001\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u7d4c\u7531\u3067\u8ee2\u9001\u3055\u308c\u305f\u30d0\u30a4\u30c8\u6570\u306e\u8868\u793a<\/li>\n<li>EXPLAIN\u306b\u3088\u308b\u3001\u30ef\u30fc\u30ab\u30fc \u30ce\u30fc\u30c9\u3068\u306e\u9593\u3067\u9001\u53d7\u4fe1\u3055\u308c\u308b Postgres \u30af\u30a8\u30ea\u306e\u8868\u793a\u304c\u53ef\u80fd\u306b<\/li>\n<\/ul>\n<p class=\"c-paragraph-3\">\n    Citus 9.4 \u306e EXPLAIN ANALYZE \u306e\u6a5f\u80fd\u5f37\u5316\u306b\u3088\u308a\u3001Citus \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30af\u30e9\u30b9\u30bf\u3067 Postgres \u30af\u30a8\u30ea\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u7406\u89e3\u3057\u3001\u8abf\u6574\u3059\u308b\u3053\u3068\u304c\u975e\u5e38\u306b\u7c21\u5358\u306b\u306a\u308a\u307e\u3057\u305f\u3002\u4f8b\uff1a\u5927\u304d\u306a\u30c6\u30fc\u30d6\u30eb\u3067\u306e\u5e73\u5747\u306e\u53d6\u5f97\u3002Citus \u306f\u3001\u5404\u30b7\u30e3\u30fc\u30c9\u304b\u3089\u5408\u8a08\u3068\u30ab\u30a6\u30f3\u30c8\u306e\u307f\u3092\u53d6\u5f97\u3059\u308b\u305f\u3081\u3001\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u3067 44 \u30d0\u30a4\u30c8\u3057\u304b\u8ee2\u9001\u3057\u307e\u305b\u3093\uff1a\n<\/p>\n<div style=\"white-space: nowrap; background-color: #000000; padding: 5px; lineheight: 0.1; overflow: auto;\">\n<p>    <span style=\"color: #33cccc;\">EXPLAIN<\/span> <span style=\"color: #ffffff;\">(<\/span><span style=\"color: #33cccc;\">ANALYZE<\/span><span style=\"color: #ffffff;\">,<\/span> <span style=\"color: #33cccc;\">VERBOSE<\/span><span style=\"color: #ffffff;\">)<\/span> <span style=\"color: #33cccc;\">SELECT avg<\/span><span style=\"color: #ffffff;\">(rating)<\/span><span style=\"color: #33cccc;\"> FROM<\/span> <span style=\"color: #ffffff;\">item_ratings;<\/span><\/p>\n<p style=\"text-align: right;\"><span style=\"color: #ffffff;\">QUERY PLAN<\/span><\/p>\n<p>    <span style=\"color: #ffffff;\"><em>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/em><\/span><br \/>\n    <span style=\"color: #33cccc;\">\u00a0Aggregate\u00a0<\/span> <span style=\"color: #ffffff;\">(cost<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">500<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">00<\/span><span style=\"color: #ffffff;\">..<\/span><span style=\"color: #339966;\">500<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">02<\/span> <span style=\"color: #33cccc;\">rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span> <span style=\"color: #ffffff;\">width<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">8<\/span><span style=\"color: #ffffff;\">) (actual time<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">95<\/span>.<span style=\"color: #339966;\">942<\/span>..<span style=\"color: #339966;\">95<\/span>.<span style=\"color: #339966;\">942<\/span> <span style=\"color: #33cccc;\">row<span style=\"color: #00ccff;\">s<\/span><\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span> <span style=\"color: #ffffff;\">loops<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span><span style=\"color: #ffffff;\">)<\/span><br \/>\n    <span style=\"color: #33cccc;\">\u00a0 \u00a0 \u00a0Output<\/span><span style=\"color: #ffffff;\">:<\/span> <span style=\"color: #ffffff;\">(<\/span><span style=\"color: #33cccc;\">sum<\/span><span style=\"color: #ffffff;\">(remote_scan.<\/span><span style=\"color: #33cccc;\">avg<\/span><span style=\"color: #ffffff;\">)<\/span> <span style=\"color: #00ccff;\">\/<\/span> <span style=\"color: #ffffff;\">(pg_catalog.<\/span><span style=\"color: #33cccc;\">sum<\/span><span style=\"color: #ffffff;\">(remote_scan.avg_1))::double<\/span> <span style=\"color: #33cccc;\">precision<\/span><span style=\"color: #ffffff;\">)<\/span><br \/>\n    <span style=\"color: #00ccff;\">\u00a0 \u00a0 \u00a0-&gt;<\/span>\u00a0 <span style=\"color: #ffffff;\">Custom Scan (Citus Adaptive)\u00a0 (cost<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">0<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">00<\/span><span style=\"color: #ffffff;\">..<\/span><span style=\"color: #339966;\">0<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">00<\/span> <span style=\"color: #33cccc;\">rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">100000<\/span> <span style=\"color: #ffffff;\">width<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">16<\/span><span style=\"color: #ffffff;\">) (actual time<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">95<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">917<\/span><span style=\"color: #ffffff;\">..<\/span><span style=\"color: #339966;\">95<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">918<\/span> <span style=\"color: #33cccc;\">rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">2<\/span> <span style=\"color: #ffffff;\">loops<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span><span style=\"color: #ffffff;\">)<\/span><br \/>\n    <span style=\"color: #33cccc;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0Output<\/span><span style=\"color: #ffffff;\">: remote_scan.<\/span><span style=\"color: #33cccc;\">avg<\/span><span style=\"color: #ffffff;\">, remote_scan.avg_1<\/span><br \/>\n    <span style=\"color: #ffffff;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0Task<\/span> <span style=\"color: #33cccc;\">Count<\/span><span style=\"color: #ffffff;\">:<\/span> <span style=\"color: #339966;\">2<\/span><br \/>\n    <span style=\"color: #ffffff;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0Tuple<\/span><span style=\"color: #33cccc;\"> data<\/span><span style=\"color: #ffffff;\"> received<\/span> <span style=\"color: #33cccc;\">from<\/span> <span style=\"color: #ffffff;\">nodes:<\/span> <span style=\"color: #339966;\">44<\/span> <span style=\"color: #ffffff;\">bytes<\/span><br \/>\n    <span style=\"color: #ffffff;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0Tasks Shown:<\/span> <span style=\"color: #33cccc;\">All<\/span><br \/>\n    <span style=\"color: #00ccff;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0-&gt;\u00a0<\/span><span style=\"color: #ffffff;\"> Task<\/span><br \/>\n    <span style=\"color: #ffffff;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Query:<\/span> <span style=\"color: #33cccc;\">SELECT sum<\/span><span style=\"color: #ffffff;\">(rating)<\/span> <span style=\"color: #33cccc;\">AS avg<span style=\"color: #ffffff;\">,<\/span> count<\/span><span style=\"color: #ffffff;\">(rating)<\/span> <span style=\"color: #33cccc;\">AS avg FROM<\/span> <span style=\"color: #ffffff;\">item_ratings_102077 item_ratings<\/span> <span style=\"color: #33cccc;\">WHERE true<\/span><br \/>\n    <span style=\"color: #ffffff;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Tuple<\/span> <span style=\"color: #33cccc;\">data<\/span> <span style=\"color: #ffffff;\">received<\/span> <span style=\"color: #33cccc;\">from<\/span> <span style=\"color: #ffffff;\">node:<\/span> <span style=\"color: #339966;\">22<\/span> <span style=\"color: #ffffff;\">bytes<\/span><br \/>\n    <span style=\"color: #ffffff;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Node:<\/span> <span style=\"color: #33cccc;\">host<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #ffffff;\">localhost port<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">9700<\/span> <span style=\"color: #ffffff;\">dbname<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #ffffff;\">postgres<\/span><br \/>\n    <span style=\"color: #00ccff;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 -&gt;<\/span>\u00a0 <span style=\"color: #33cccc;\">Aggregate<\/span>\u00a0 <span style=\"color: #ffffff;\">(cost<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">10872<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">68<\/span><span style=\"color: #ffffff;\">..<\/span><span style=\"color: #339966;\">10872<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">69<\/span> <span style=\"color: #33cccc;\">rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span> <span style=\"color: #ffffff;\">width<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">16<\/span><span style=\"color: #ffffff;\">) (actual time<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">92<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">390<\/span><span style=\"color: #ffffff;\">..<\/span><span style=\"color: #339966;\">92<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">391<\/span> <span style=\"color: #ffffff;\">rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span> <span style=\"color: #ffffff;\">loops<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span><span style=\"color: #ffffff;\">)<\/span><br \/>\n    <span style=\"color: #33cccc;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Output<\/span><span style=\"color: #ffffff;\">:<\/span> <span style=\"color: #33cccc;\">sum<\/span><span style=\"color: #ffffff;\">(rating),<\/span> <span style=\"color: #33cccc;\">count<\/span><span style=\"color: #ffffff;\">(rating)<\/span><br \/>\n    <span style=\"color: #00ccff;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0-&gt;<\/span>\u00a0<span style=\"color: #ffffff;\"> Seq Scan<\/span> <span style=\"color: #33cccc;\">on public<\/span><span style=\"color: #ffffff;\">.item_ratings_102077 item_ratings\u00a0 (cost<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">0<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">00<\/span><span style=\"color: #ffffff;\">..<\/span><span style=\"color: #339966;\">8141<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">12<\/span> <span style=\"color: #33cccc;\">rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">546312<\/span> <span style=\"color: #ffffff;\">width<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">8<\/span><span style=\"color: #ffffff;\">) (actual time<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">0<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">120<\/span><span style=\"color: #ffffff;\">..<\/span><span style=\"color: #339966;\">53<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">408<\/span> <span style=\"color: #33cccc;\">rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">495406<\/span> <span style=\"color: #ffffff;\">loops=<\/span><span style=\"color: #339966;\">1<\/span><span style=\"color: #ffffff;\">)<\/span><br \/>\n    <span style=\"color: #33cccc;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Output<\/span><span style=\"color: #ffffff;\">: user_id, rating<\/span><br \/>\n    <span style=\"color: #ffffff;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Planning Time:<\/span> <span style=\"color: #339966;\">0<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">051<\/span> <span style=\"color: #ffffff;\">ms<\/span><br \/>\n    <span style=\"color: #ffffff;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Execution Time:<\/span> <span style=\"color: #339966;\">92<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">424<\/span> <span style=\"color: #ffffff;\">ms<\/span><br \/>\n    <span style=\"color: #00ccff;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 -&gt;<\/span>\u00a0 <span style=\"color: #ffffff;\">Task<\/span><br \/>\n    <span style=\"color: #ffffff;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Query:<\/span> <span style=\"color: #33cccc;\">SELECT sum<\/span><span style=\"color: #ffffff;\">(rating)<\/span> <span style=\"color: #33cccc;\">AS avg<\/span><span style=\"color: #ffffff;\">,<\/span> <span style=\"color: #33cccc;\">count<\/span><span style=\"color: #ffffff;\">(rating)<\/span> <span style=\"color: #33cccc;\">AS avg FROM<\/span> <span style=\"color: #ffffff;\">item_ratings_102078 item_ratings<\/span> <span style=\"color: #33cccc;\">WHERE true<\/span><br \/>\n    <span style=\"color: #ffffff;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Tuple<\/span> <span style=\"color: #33cccc;\">data<\/span> <span style=\"color: #ffffff;\">received<\/span> <span style=\"color: #33cccc;\">from<\/span><span style=\"color: #ffffff;\"> node:<\/span> <span style=\"color: #339966;\">22<\/span> <span style=\"color: #ffffff;\">bytes<\/span><br \/>\n    <span style=\"color: #ffffff;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Node:<\/span> <span style=\"color: #33cccc;\">host<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #ffffff;\">localhost port<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">9701<\/span> <span style=\"color: #ffffff;\">dbname<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #ffffff;\">postgres<\/span><br \/>\n    <span style=\"color: #00ccff;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0-&gt;<\/span>\u00a0 <span style=\"color: #33cccc;\">Aggregate\u00a0<\/span><span style=\"color: #ffffff;\"> (cost<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">11075<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">68<\/span><span style=\"color: #ffffff;\">..<\/span><span style=\"color: #339966;\">11075<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">69<\/span> <span style=\"color: #33cccc;\">rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span> <span style=\"color: #ffffff;\">width<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">16<\/span><span style=\"color: #ffffff;\">) (actual time<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">93<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">468<\/span><span style=\"color: #ffffff;\">..<\/span><span style=\"color: #339966;\">93<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">468<\/span> <span style=\"color: #33cccc;\">rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span> <span style=\"color: #00ccff;\"><span style=\"color: #ffffff;\">loops<\/span>=<span style=\"color: #339966;\">1<\/span><span style=\"color: #ffffff;\">)<\/span><\/span><br \/>\n    <span style=\"color: #33cccc;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Output<\/span>: <span style=\"color: #33cccc;\">sum<\/span><span style=\"color: #ffffff;\">(rating),<\/span><span style=\"color: #33cccc;\"> count<\/span><span style=\"color: #ffffff;\">(rating)<\/span><br \/>\n    <span style=\"color: #00ccff;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0-&gt;\u00a0<\/span> <span style=\"color: #ffffff;\">Seq Scan<\/span> <span style=\"color: #33cccc;\">on public<\/span><span style=\"color: #ffffff;\">.item_ratings_102078 item_ratings\u00a0 (cost<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">0<span style=\"color: #ffffff;\">.<\/span>00<span style=\"color: #ffffff;\">..<\/span>8293<span style=\"color: #ffffff;\">.<\/span>12<\/span><span style=\"color: #33cccc;\"> rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">556512<\/span> <span style=\"color: #ffffff;\">width<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">8<\/span><span style=\"color: #ffffff;\">) (actual time<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">0<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">053<\/span><span style=\"color: #ffffff;\">..<\/span><span style=\"color: #339966;\">53<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">639<\/span> <span style=\"color: #33cccc;\">rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">504594<\/span> <span style=\"color: #ffffff;\">loops<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span><span style=\"color: #ffffff;\">)<\/span><br \/>\n    <span style=\"color: #33cccc;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Output<\/span><span style=\"color: #ffffff;\">: user_id, rating<\/span><br \/>\n    <span style=\"color: #ffffff;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Planning Time:<\/span> <span style=\"color: #339966;\">0<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">090<\/span> <span style=\"color: #ffffff;\">ms<\/span><br \/>\n    <span style=\"color: #ffffff;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Execution Time:<\/span> <span style=\"color: #339966;\">93<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">500<\/span> <span style=\"color: #ffffff;\">ms<\/span><br \/>\n    <span style=\"color: #ffffff;\">\u00a0 <\/span><span style=\"color: #ffffff;\">Planning Time:<\/span> <span style=\"color: #339966;\">0<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">370<\/span> <span style=\"color: #ffffff;\">ms<\/span><br \/>\n    <span style=\"color: #ffffff;\">\u00a0 Execution Time:<\/span> <span style=\"color: #339966;\">96<\/span><span style=\"color: #ffffff;\">.<\/span><span style=\"color: #339966;\">191<\/span><span style=\"color: #ffffff;\"> ms<\/span><br \/>\n    <span style=\"color: #ffffff;\">\u00a0(<\/span><span style=\"color: #339966;\">29<\/span> <span style=\"color: #33cccc;\">rows<\/span><span style=\"color: #ffffff;\">)<\/span><\/p>\n<\/div>\n<p><!--\u4ee5\u524d\u306e\u90e8\u5206\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\n&nbsp;\n\n<span style=\"color: #33cccc;\">EXPLAIN<\/span> (<span style=\"color: #33cccc;\">ANALYZE<\/span>, <span style=\"color: #33cccc;\">VERBOSE<\/span>) <span style=\"color: #33cccc;\">SELECT avg<\/span>(rating)<span style=\"color: #33cccc;\"> FROM<\/span> item_ratings;\n\nQUERY PLAN\n\n<em>--------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/em>\n\n<span style=\"color: #33cccc;\">Aggregate\u00a0<\/span> (cost<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">500<\/span>.<span style=\"color: #339966;\">00<\/span>..<span style=\"color: #339966;\">500<\/span>.<span style=\"color: #339966;\">02<\/span> <span style=\"color: #33cccc;\">rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span> width<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">8<\/span>) (actual time<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">95<\/span>.<span style=\"color: #339966;\">942<\/span>..<span style=\"color: #339966;\">95<\/span>.<span style=\"color: #339966;\">942<\/span> <span style=\"color: #33cccc;\">row<span style=\"color: #00ccff;\">s<\/span><\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span> loops<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span>)\n<span style=\"color: #33cccc;\">Output<\/span>: (<span style=\"color: #33cccc;\">sum<\/span>(remote_scan.<span style=\"color: #33cccc;\">avg<\/span>) <span style=\"color: #00ccff;\">\/<\/span> (pg_catalog.<span style=\"color: #33cccc;\">sum<\/span>(remote_scan.avg_1))::double <span style=\"color: #33cccc;\">precision<\/span>)\n\n<span style=\"color: #00ccff;\">-&gt;<\/span>\u00a0 Custom Scan (Citus Adaptive)\u00a0 (cost<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">0<\/span>.<span style=\"color: #339966;\">00<\/span>..<span style=\"color: #339966;\">0<\/span>.<span style=\"color: #339966;\">00<\/span> <span style=\"color: #33cccc;\">rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">100000<\/span> width<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">16<\/span>) (actual time<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">95<\/span>.<span style=\"color: #339966;\">917<\/span>..<span style=\"color: #339966;\">95<\/span>.<span style=\"color: #339966;\">918<\/span> <span style=\"color: #33cccc;\">rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">2<\/span> loops<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span>)\n\n<span style=\"color: #33cccc;\">Output<\/span>: remote_scan.<span style=\"color: #33cccc;\">avg<\/span>, remote_scan.avg_1\n\nTask <span style=\"color: #33cccc;\">Count<\/span>: <span style=\"color: #339966;\">2<\/span>\n\nTuple<span style=\"color: #33cccc;\"> data<\/span> received <span style=\"color: #33cccc;\">from<\/span> nodes: <span style=\"color: #339966;\">44<\/span> bytes\n\nTasks Shown: <span style=\"color: #33cccc;\">All<\/span>\n\n<span style=\"color: #00ccff;\">-&gt;\u00a0<\/span> Task\n\nQuery: <span style=\"color: #33cccc;\">SELECT sum<\/span>(rating) <span style=\"color: #33cccc;\">AS avg, count<\/span>(rating) <span style=\"color: #33cccc;\">AS avg FROM<\/span> item_ratings_102077 item_ratings <span style=\"color: #33cccc;\">WHERE true<\/span>\n\nTuple <span style=\"color: #33cccc;\">data<\/span> received <span style=\"color: #33cccc;\">from<\/span> node: <span style=\"color: #339966;\">22<\/span> bytes\n\nNode: <span style=\"color: #33cccc;\">host<\/span><span style=\"color: #00ccff;\">=<\/span>localhost port<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">9700<\/span> dbname<span style=\"color: #00ccff;\">=<\/span>postgres\n\n<span style=\"color: #00ccff;\">-&gt;<\/span>\u00a0 <span style=\"color: #33cccc;\">Aggregate<\/span>\u00a0 (cost<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">10872<\/span>.<span style=\"color: #339966;\">68<\/span>..<span style=\"color: #339966;\">10872<\/span>.<span style=\"color: #339966;\">69<\/span> <span style=\"color: #33cccc;\">rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span> width<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">16<\/span>) (actual time<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">92<\/span>.<span style=\"color: #339966;\">390<\/span>..<span style=\"color: #339966;\">92<\/span>.<span style=\"color: #339966;\">391<\/span> rows<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span> loops<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span>)\n\n<span style=\"color: #33cccc;\">Output<\/span>: <span style=\"color: #33cccc;\">sum<\/span>(rating), <span style=\"color: #33cccc;\">count<\/span>(rating)\n\n<span style=\"color: #00ccff;\">-&gt;<\/span>\u00a0 Seq Scan <span style=\"color: #33cccc;\">on public<\/span>.item_ratings_102077 item_ratings\u00a0 (cost<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">0<\/span>.<span style=\"color: #339966;\">00<\/span>..<span style=\"color: #339966;\">8141<\/span>.<span style=\"color: #339966;\">12<\/span> <span style=\"color: #33cccc;\">rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">546312<\/span> width<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">8<\/span>) (actual time<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">0<\/span>.<span style=\"color: #339966;\">120<\/span>..<span style=\"color: #339966;\">53<\/span>.<span style=\"color: #339966;\">408<\/span> <span style=\"color: #33cccc;\">rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">495406<\/span> loops=<span style=\"color: #339966;\">1<\/span>)\n\n<span style=\"color: #33cccc;\">Output<\/span>: user_id, rating\n\nPlanning Time: <span style=\"color: #339966;\">0<\/span>.<span style=\"color: #339966;\">051<\/span> ms\n\nExecution Time: <span style=\"color: #339966;\">92<\/span>.<span style=\"color: #339966;\">424<\/span> ms\n\n<span style=\"color: #00ccff;\">-&gt;<\/span>\u00a0 Task\n\nQuery: <span style=\"color: #33cccc;\">SELECT sum<\/span>(rating) <span style=\"color: #33cccc;\">AS avg<\/span>, <span style=\"color: #33cccc;\">count<\/span>(rating) <span style=\"color: #33cccc;\">AS avg FROM<\/span> item_ratings_102078 item_ratings <span style=\"color: #33cccc;\">WHERE true<\/span>\n\nTuple <span style=\"color: #33cccc;\">data<\/span> received <span style=\"color: #33cccc;\">from<\/span> node: <span style=\"color: #339966;\">22<\/span> bytes\n\nNode: <span style=\"color: #33cccc;\">host<\/span><span style=\"color: #00ccff;\">=<\/span>localhost port<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">9701<\/span> dbname=postgres\n\n-&gt;\u00a0 <span style=\"color: #33cccc;\">Aggregate\u00a0<\/span> (cost<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">11075<\/span>.<span style=\"color: #339966;\">68<\/span>..<span style=\"color: #339966;\">11075<\/span>.<span style=\"color: #339966;\">69<\/span> <span style=\"color: #33cccc;\">rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span> width<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">16<\/span>) (actual time<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">93<\/span>.<span style=\"color: #339966;\">468<\/span>..<span style=\"color: #339966;\">93<\/span>.<span style=\"color: #339966;\">468<\/span> <span style=\"color: #33cccc;\">rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span> <span style=\"color: #00ccff;\"><span style=\"color: #000000;\">loops<\/span>=<span style=\"color: #339966;\">1<\/span>)<\/span>\n\n<span style=\"color: #33cccc;\">Output<\/span>: <span style=\"color: #33cccc;\">sum<\/span>(rating),<span style=\"color: #33cccc;\"> count<\/span>(rating)\n\n<span style=\"color: #00ccff;\">-&gt;\u00a0<\/span> Seq Scan <span style=\"color: #33cccc;\">on public<\/span>.item_ratings_102078 item_ratings\u00a0 (cost=0.00..8293.12<span style=\"color: #33cccc;\"> rows<\/span><span style=\"color: #00ccff;\">=<\/span>556512 width<span style=\"color: #00ccff;\">=<\/span>8) (actual time<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">0<\/span>.<span style=\"color: #339966;\">053<\/span>..<span style=\"color: #339966;\">53<\/span>.<span style=\"color: #339966;\">639<\/span> <span style=\"color: #33cccc;\">rows<\/span><span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">504594<\/span> loops<span style=\"color: #00ccff;\">=<\/span><span style=\"color: #339966;\">1<\/span>)\n\n<span style=\"color: #33cccc;\">Output<\/span>: user_id, rating\n\nPlanning Time: <span style=\"color: #339966;\">0<\/span>.<span style=\"color: #339966;\">090<\/span> ms\n\nExecution Time: <span style=\"color: #339966;\">93<\/span>.<span style=\"color: #339966;\">500<\/span> ms\n\nPlanning Time: <span style=\"color: #339966;\">0<\/span>.<span style=\"color: #339966;\">370<\/span> ms\n\nExecution Time: <span style=\"color: #339966;\">96<\/span>.<span style=\"color: #339966;\">191<\/span> ms\n\n(<span style=\"color: #339966;\">29<\/span> <span style=\"color: #33cccc;\">rows<\/span>)\n\u3053\u3053\u307e\u3067\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8--><\/p>\n<p><span style=\"font-size: 18pt;\"><strong>\u30a2\u30d7\u30ea\u304c <\/strong><strong>Citus <\/strong><strong>\u306e<\/strong><strong>\u30ed\u30fc\u30ab\u30eb\u304a\u3088\u3073\u5206\u6563\u30c6\u30fc\u30d6\u30eb\u306e\u4e21\u65b9\u3092\u6d3b\u7528\u3067\u304d\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3059\u308b<\/strong><\/span><\/p>\n<p><span style=\"font-size: 14pt;\"><strong>INSERT INTO <\/strong><strong>\u30ed\u30fc\u30ab\u30eb\u30c6\u30fc\u30d6\u30eb<\/strong><strong> SELECT .. FROM <\/strong><strong>\u5206\u6563\u30c6\u30fc\u30d6\u30eb<\/strong>:<\/span><\/p>\n<p class=\"c-paragraph-3\">\n    \u30af\u30a8\u30ea\u306e\u7d50\u679c\u3092\u30c6\u30fc\u30d6\u30eb\u306b INSERT \u307e\u305f\u306f UPSERT \u3059\u308b\u3053\u3068\u306f\u3001PostgreSQL \u3068 Citus \u3067\u306e\u5f37\u529b\u306a\u30c7\u30fc\u30bf\u5909\u63db\u30e1\u30ab\u30cb\u30ba\u30e0\u3067\u3059\u3002Citus 9.4 \u4ee5\u964d\u3067\u306f\u3001\u5206\u6563\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3059\u308b SQL \u30af\u30a8\u30ea\u306e\u7d50\u679c\u3092\u30ed\u30fc\u30ab\u30eb \u30c6\u30fc\u30d6\u30eb\u306b INSERT \u307e\u305f\u306f UPSERT \u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002\u3053\u308c\u306b\u3088\u308a\u6709\u52b9\u306b\u306a\u308b\u91cd\u8981\u306a\u5229\u7528\u6cd5\u306f\u3001\u30ec\u30a4\u30c6\u30f3\u30b7\u30fc\u3092\u5c0f\u3055\u304f\u3059\u308b\u305f\u3081\u306b\u30b3\u30fc\u30c7\u30a3\u30cd\u30fc\u30bf\u30fc\u306b\u914d\u7f6e\u3055\u308c\u308b\u5c0f\u3055\u306a<a href=\"https:\/\/docs.citusdata.com\/en\/v9.4\/develop\/reference_dml.html#caching-aggregations-with-rollups\" class=\"c-hyperlink\" aria-label=\"\u96c6\u8a08\u30c6\u30fc\u30d6\u30eb: \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u306b\u306f\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u96c6\u8a08\u30c6\u30fc\u30d6\u30eb<\/a>\u3092\u4fdd\u6301\u3059\u308b\u3053\u3068\u3067\u3059\u304c\u3001\u4ed6\u306e\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u3082\u7c21\u7d20\u5316\u3057\u307e\u3059\u3002\u305f\u3068\u3048\u3070\u3001\u5206\u6563\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3059\u308b\u30af\u30a8\u30ea\u306e\u7d50\u679c\u3092\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u306b\u76f4\u63a5\u66f8\u304d\u8fbc\u3080\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002\u3053\u306e\u6a5f\u80fd\u306b\u3088\u308a\u3001Citus \u306f\u4efb\u610f\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u7d44\u307f\u5408\u308f\u305b\u306b\u5bfe\u3057\u3066 INSERT..SELECT \u3092\u5229\u7528\u51fa\u6765\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002\n<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>\u30ed\u30fc\u30ab\u30eb \u30c6\u30fc\u30d6\u30eb\u3068<\/strong><strong> CTE <\/strong><strong>\u9593\u306e\u7d50\u5408<\/strong><strong>:<\/strong><\/span><\/p>\n<p class=\"c-paragraph-3\">\n    Citus \u30b3\u30fc\u30c7\u30a3\u30cd\u30fc\u30bf\u30fc\u4e0a\u306e\u30ed\u30fc\u30ab\u30eb \u30c6\u30fc\u30d6\u30eb\u3068\u3001\u5206\u6563\u30c6\u30fc\u30d6\u30eb\u306b\u30af\u30a8\u30ea\u3059\u308b<a href=\"https:\/\/www.citusdata.com\/blog\/2018\/03\/09\/distributed-execution-of-ctes-and-subqueries-in-citus\/\" class=\"c-hyperlink\" aria-label=\"Common Table Expressions: \u7d9a\u304d\u3092\u8aad\u3080\u306b\u306f\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">Common Table Expressions<\/a> (CTE) \u306e\u9593\u306e JOIN \u304c\u30b5\u30dd\u30fc\u30c8\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002\u3053\u308c\u306b\u3088\u308a\u3001\u5206\u6563\u30c6\u30fc\u30d6\u30eb\u3001\u53c2\u7167\u30c6\u30fc\u30d6\u30eb\u3001\u30ed\u30fc\u30ab\u30eb \u30c6\u30fc\u30d6\u30eb\u3092\u6df7\u5728\u3055\u305b\u308b\u30cf\u30a4\u30d6\u30ea\u30c3\u30c9 \u30c7\u30fc\u30bf \u30e2\u30c7\u30eb\u3092\u7c21\u5358\u306b\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002\n<\/p>\n<p><span style=\"font-size: 18pt;\"><strong>COPY <\/strong><strong>\u306e<\/strong><strong>\u30b3\u30cd\u30af\u30b7\u30e7\u30f3\u3092\u7ba1\u7406\u3057\u3066<\/strong><strong> Postgres <\/strong><strong>\u306e\u30b3\u30cd\u30af\u30b7\u30e7\u30f3\u3092\u4f7f\u3044\u679c\u305f\u3055\u306a\u3044\u3088\u3046\u306b\u3059\u308b<\/strong><\/span><\/p>\n<p class=\"c-paragraph-3\">\n    \u591a\u6570\u306eCOPY \u30b3\u30de\u30f3\u30c9\u3092\u540c\u6642\u306b\u5b9f\u884c\u3057\u305f\u5834\u5408\u3001Citus \u306f\u591a\u6570\u306e Postgres \u306e\u30b3\u30cd\u30af\u30b7\u30e7\u30f3\u3067\u30ef\u30fc\u30ab\u30fc \u30ce\u30fc\u30c9\u3092\u3042\u3075\u308c\u3055\u305b\u3066\u3057\u307e\u3046\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002\n<\/p>\n<p class=\"c-paragraph-3\">\n    Citus 9.4 \u4ee5\u964d\u3067\u306f\u3001<a href=\"https:\/\/docs.citusdata.com\/en\/stable\/develop\/api_guc.html#citus-max-adaptive-executor-pool-size-integer\" class=\"c-hyperlink\" aria-label=\"citus.max_adaptive_executor_pool_size: \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u306b\u306f\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">citus.max_adaptive_executor_pool_size<\/a> \u8a2d\u5b9a\u306b\u3088\u308a\u3001\u500b\u3005\u306e COPY \u30b3\u30de\u30f3\u30c9\u306b\u3088\u3063\u3066\u4f5c\u6210\u3055\u308c\u308b Postgres \u306e\u30b3\u30cd\u30af\u30b7\u30e7\u30f3\u6570\u3092\u6e1b\u3089\u3059\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002\u6b21\u306e\u30ea\u30ea\u30fc\u30b9 (Citus 9.5) \u3067\u306f\u3001COPY \u306e\u63a5\u7d9a\u7ba1\u7406\u3092\u5b8c\u5168\u306b\u81ea\u52d5\u3067\u884c\u3044\u307e\u3059\u3002\n<\/p>\n<p><span style=\"font-size: 18pt;\"><strong>t-digest <\/strong><strong>\u306b\u3088\u308b\u30d1\u30fc\u30bb\u30f3\u30bf\u30a4\u30eb\u306e\u8a08\u7b97\u306e\u30b9\u30b1\u30fc\u30eb<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/github.com\/tvondra\/tdigest\" class=\"c-hyperlink\" aria-label=\"t-digest\u62e1\u5f35: GitHub \u3092\u958b\u304f\u306b\u306f\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002\">t-digest\u62e1\u5f35<\/a><u>\u6a5f\u80fd<\/u>\u304b\u3089 Postgres \u3078\u306e\u96c6\u8a08\u6a5f\u80fd\u306f\u3001Citus \u3067\u5206\u6563\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u306b\u306a\u308a\u3001Citus \u4e0a\u3067\u975e\u5e38\u306b\u9ad8\u901f\u3067\u4e26\u5217\u306a<a href=\"https:\/\/docs.citusdata.com\/en\/stable\/develop\/reference_sql.html?highlight=tdigest#percentile-calculations\" class=\"c-hyperlink\" aria-label=\"\u30d1\u30fc\u30bb\u30f3\u30bf\u30a4\u30eb\u8a08\u7b97: \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u306b\u306f\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">\u30d1\u30fc\u30bb\u30f3\u30bf\u30a4\u30eb\u8a08\u7b97<\/a>\u3092\u53ef\u80fd\u306b\u3057\u3001Citus \u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u30e6\u30fc\u30b6\u30fc\u306e\u4e00\u90e8\u306b\u3068\u3063\u3066\u91cd\u8981\u306a\u30cb\u30fc\u30ba\u3092\u6e80\u305f\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u306et-digest\u62e1\u5f35\u6a5f\u80fd\u3092\u4f5c\u6210\u3057 Citus \u3067 t-digest \u3092\u5229\u7528\u53ef\u80fd\u306b\u3059\u308b\u969b\u306b\u5927\u304d\u306a\u52a9\u3051\u306b\u306a\u3063\u305fPostgres \u30b3\u30df\u30c3\u30bf\u30fc\u306e Tomas Vondra \u306b\u611f\u8b1d\u3057\u307e\u3059\u3002\u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u306e t-digest \u62e1\u5f35\u6a5f\u80fd\u306f Hyperscale (Citus) \u3067\u3082\u30b5\u30dd\u30fc\u30c8\u3055\u308c\u3066\u3044\u307e\u3059\u304c\u3001<a href=\"https:\/\/docs.microsoft.com\/azure\/postgresql\/concepts-hyperscale-extensions\" class=\"c-hyperlink\" aria-label=\"Hyperscale (Citus) \u62e1\u5f35\u6a5f\u80fd\u30b5\u30dd\u30fc\u30c8: \u30cf\u30a4\u30d1\u30fc\u30b9\u30b1\u30fc\u30eb (Citus) \u62e1\u5f35\u6a5f\u80fd\u306e\u30b5\u30dd\u30fc\u30c8 \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u306b\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002\">Hyperscale (Citus) \u62e1\u5f35\u6a5f\u80fd\u30b5\u30dd\u30fc\u30c8<\/a>\u306e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u30da\u30fc\u30b8\u3067\u3082\u3001\u3059\u3050\u306bt-digest\u306e\u8aac\u660e\u304c\u8ffd\u52a0\u66f4\u65b0\u3055\u308c\u308b\u4e88\u5b9a\u3067\u3059\u3002<\/p>\n<p class=\"c-paragraph-3\">\n    \u30d1\u30fc\u30bb\u30f3\u30bf\u30a4\u30eb\u306e\u8fd1\u4f3c\u306f\u6709\u7528\u3067\u3057\u3087\u3046\u304b\uff1f \u3082\u3061\u308d\u3093\u3067\u3059\u3002\u79c1\u306e\u30c1\u30fc\u30e0\u30e1\u30a4\u30c8\u306e\u4e00\u4eba\u3001Nils Dijk \u306f\u3001\u3042\u308b\u304a\u5ba2\u69d8\u304c t-digest \u3068 Hyperscale (Citus) \u3067<a href=\"https:\/\/www.citusdata.com\/blog\/2020\/09\/19\/delivering-45x-faster-percentiles\/\" class=\"c-hyperlink\" aria-label=\"Postgres \u306e\u30d1\u30fc\u30bb\u30f3\u30bf\u30a4\u30eb\u8a08\u7b97\u309245\u500d\u6539\u5584\u3057\u305f: 45\u500d\u306b\u3088\u308bPostgres\u30d1\u30fc\u30bb\u30f3\u30bf\u30a4\u30eb\u8a08\u7b97\u306e\u6539\u5584\u306b\u3064\u3044\u3066\u3082\u3063\u3068\u8aad\u3080\u306b\u306f\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\">Postgres \u306e\u30d1\u30fc\u30bb\u30f3\u30bf\u30a4\u30eb\u8a08\u7b97\u309245\u500d\u6539\u5584\u3057\u305f<\/a>\u65b9\u6cd5\u306b\u3064\u3044\u3066\u30d6\u30ed\u30b0\u8a18\u4e8b\u3092\u66f8\u3044\u3066\u3044\u307e\u3059\u3002\u305d\u3057\u3066\u3001Stackify \u30c1\u30fc\u30e0\u306e Matt Watson \u306f\u3001Postgres\u3001t-digest\u3001\u304a\u3088\u3073 Citus \u3092\u4f7f\u7528\u3057\u3066\u5927\u898f\u6a21\u306a <a href=\"https:\/\/stackify.com\/sql-percentile-aggregates-and-rollups-with-postgresql-and-t-digest\/\" class=\"c-hyperlink\" aria-label=\"SQL \u30d1\u30fc\u30bb\u30f3\u30bf\u30a4\u30eb\u96c6\u8a08\u3092\u4f5c\u6210\u3059\u308b: SQL \u30d1\u30fc\u30bb\u30f3\u30bf\u30a4\u30eb\u96c6\u8a08\u306e\u4f5c\u6210\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002\">SQL \u30d1\u30fc\u30bb\u30f3\u30bf\u30a4\u30eb\u96c6\u8a08\u3092\u4f5c\u6210\u3059\u308b<\/a>\u65b9\u6cd5\u306b\u3064\u3044\u3066\u66f8\u3044\u305f\u3068\u3053\u308d\u3067\u3059\u3002\u307e\u305f\u3001Microsoft Azure \u3067<a href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-for-postgresql\/architecting-petabyte-scale-analytics-by-scaling-out-postgres-on\/ba-p\/969685\" class=\"c-hyperlink\" aria-label=\"Citus \u3092\u4f7f\u7528\u3057\u3066\u30da\u30bf\u30d0\u30a4\u30c8\u898f\u6a21\u306e\u5206\u6790\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9: \u30de\u30a4\u30af\u30ed\u30bd\u30d5\u30c8\u306e\u30c6\u30af\u30cb\u30ab\u30eb \u30b3\u30df\u30e5\u30cb\u30c6\u30a3 Web \u30b5\u30a4\u30c8\u306e\u8a73\u7d30\u3092\u8aad\u3080\u306b\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002\">Citus \u3092\u4f7f\u7528\u3057\u3066\u30da\u30bf\u30d0\u30a4\u30c8\u898f\u6a21\u306e\u5206\u6790\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9<\/a>\u3092\u7ba1\u7406\u3059\u308b Windows \u30c7\u30fc\u30bf\u304a\u3088\u3073\u30a4\u30f3\u30c6\u30ea\u30b8\u30a7\u30f3\u30b9 \u30c1\u30fc\u30e0\u3082\u3001Citus \u3067 t-digest \u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002\n<\/p>\n<p><span style=\"font-size: 18pt;\"><strong>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u6539\u5584<\/strong><\/span><\/p>\n<p><span style=\"font-size: 14pt;\"><strong>\u30eb\u30fc\u30bf \u30af\u30a8\u30ea\u3067\u306e CTE \u306e\u843d\u3068\u3057\u8fbc\u307f\u306e\u4fee\u6b63\uff1a<\/strong><\/span><\/p>\n<p class=\"c-paragraph-3\">\n    CTE \u306e\u5909\u66f4\u306f\u30c6\u30fc\u30d6\u30eb\u306e\u5909\u66f4\u306b\u5229\u7528\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3001\u305d\u306e\u5f8c\u306b\u5909\u66f4\u3055\u308c\u305f\u884c\u3092\u5229\u7528\u3057\u3066\u8ffd\u52a0\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3067\u304d\u307e\u3059\u3002\u305f\u3068\u3048\u3070\u3001\u5b8c\u4e86\u3057\u305f TODO \u9805\u76ee\u3092\u524a\u9664\u3059\u308b\u4e00\u65b9\u3067\u3001\u30ab\u30a6\u30f3\u30bf\u3092\u6e1b\u3089\u3059\u3053\u3068\u3082\u3067\u304d\u307e\u3059\uff1a\n<\/p>\n<div style=\"white-space: nowrap; background-color: #000000; padding: 5px; lineheight: 0.1; overflow: auto;\">\n    <span style=\"color: #33cccc;\">\u00a0 WITH<\/span><span style=\"color: #ffffff;\"> deleted_todo<\/span> <span style=\"color: #33cccc;\">AS<\/span><span style=\"color: #ffffff;\"> (<\/span><br \/>\n    <span style=\"color: #33cccc;\">\u00a0 \u00a0 \u00a0 \u00a0 DELETE FROM<\/span><span style=\"color: #ffffff;\"> todo<\/span> <span style=\"color: #33cccc;\">WHERE<\/span><span style=\"color: #ffffff;\"> user_id<\/span> <span style=\"color: #00ccff;\">=<\/span> <span style=\"color: #339966;\">423<\/span> <span style=\"color: #33cccc;\">AND<\/span> <span style=\"color: #ffffff;\">isdone RETURNING<\/span> <span style=\"color: #00ccff;\">*<\/span><br \/>\n    <span style=\"color: #ffffff;\">\u00a0 )<\/span><br \/>\n    <span style=\"color: #33cccc;\">\u00a0 UPDATE<\/span> <span style=\"color: #ffffff;\">users<\/span><br \/>\n    <span style=\"color: #33cccc;\">\u00a0 SET<\/span> <span style=\"color: #ffffff;\">remaining_todos<\/span> <span style=\"color: #00ccff;\">=<\/span> <span style=\"color: #ffffff;\">remainining_todos<\/span> <span style=\"color: #00ccff;\">&#8211;<\/span> <span style=\"color: #ffffff;\">(<\/span><span style=\"color: #33cccc;\">SELECT count<\/span><span style=\"color: #ffffff;\">(<\/span><span style=\"color: #00ccff;\">*<\/span><span style=\"color: #ffffff;\">)<\/span> <span style=\"color: #33cccc;\">FROM<\/span> <span style=\"color: #ffffff;\">deleted_todo)<\/span><br \/>\n    <span style=\"color: #33cccc;\">\u00a0 WHERE<\/span><span style=\"color: #ffffff;\"> user_id<\/span> <span style=\"color: #00ccff;\">=<\/span> <span style=\"color: #339966;\">423<\/span><span style=\"color: #ffffff;\">;<\/span>\n<\/div>\n<p><!--\u4ee5\u524d\u306e\u90e8\u5206\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\n<span style=\"color: #33cccc;\">WITH<\/span> deleted_todo <span style=\"color: #33cccc;\">AS<\/span> (\n\n<span style=\"color: #33cccc;\">DELETE FROM<\/span> todo <span style=\"color: #33cccc;\">WHERE<\/span> user_id <span style=\"color: #00ccff;\">=<\/span> <span style=\"color: #339966;\">423<\/span> <span style=\"color: #33cccc;\">AND<\/span> isdone RETURNING <span style=\"color: #00ccff;\">*<\/span>\n\n)\n\n<span style=\"color: #33cccc;\">UPDATE<\/span> users\n\n<span style=\"color: #33cccc;\">SET<\/span> remaining_todos <span style=\"color: #00ccff;\">=<\/span> remainining_todos <span style=\"color: #00ccff;\">-<\/span> (<span style=\"color: #33cccc;\">SELECT count<\/span>(<span style=\"color: #00ccff;\">*<\/span>) <span style=\"color: #33cccc;\">FROM<\/span> deleted_todo)\n\n<span style=\"color: #33cccc;\">WHERE<\/span> user_id <span style=\"color: #00ccff;\">=<\/span> <span style=\"color: #339966;\">423<\/span>;\n\u3053\u3053\u307e\u3067\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8--><\/p>\n<p class=\"c-paragraph-3\">\n    CTE \u306e\u5909\u66f4\u3092\u4f34\u3046\u30af\u30a8\u30ea\u306b\u3001\u5206\u6563\u5217 (\u305f\u3068\u3048\u3070\u3001\u30e6\u30fc\u30b6\u30fc ID \u3084tenant_id) \u306b\u30d5\u30a3\u30eb\u30bf\u30fc\u304c\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u30011 \u56de\u306e\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u4e0a\u306e\u3084\u308a\u3068\u308a\u3067\u30ef\u30fc\u30ab\u30fc\u306b\u5b8c\u5168\u306b\u59d4\u4efb\u3067\u304d\u308b\u306e\u3067\u3001\u3053\u308c\u3089\u306e\u30af\u30a8\u30ea\u306f\u3088\u308a\u5c0f\u3055\u306a\u30ec\u30a4\u30c6\u30f3\u30b7\u30fc\u3068\u9ad8\u3044\u30b9\u30eb\u30fc\u30d7\u30c3\u30c8\u3067\u5b9f\u884c\u3067\u304d\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002\n<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>\u30d0\u30a4\u30ca\u30ea\u30d7\u30ed\u30c8\u30b3\u30eb\u306e\u8ffd\u52a0\u30b5\u30dd\u30fc\u30c8\uff1a<\/strong><\/span><\/p>\n<p class=\"c-paragraph-3\">\n    Citus 9.4 \u3067\u306f\u3001\u30ef\u30fc\u30ab\u30fc\u3068\u30b3\u30fc\u30c7\u30a3\u30cd\u30fc\u30bf\u30fc\u9593\u306e\u901a\u4fe1\u306b\u3001PostgreSQL \u306e\u30d0\u30a4\u30ca\u30ea\u30d7\u30ed\u30c8\u30b3\u30eb\u3092\u6709\u52b9\u306b\u3067\u304d\u307e\u3059\u3002\n<\/p>\n<p>    \u901a\u5e38\u3001\u5024\u306f\u30c6\u30ad\u30b9\u30c8\u3068\u3057\u3066\u7d4c\u8def\u4e0a\u3092\u9001\u4fe1\u3055\u308c\u3001\u4e00\u90e8\u306e\u30c7\u30fc\u30bf\u306b\u5bfe\u3057\u3066\u306f\u975e\u5e38\u306b\u52b9\u7387\u7684\u3067\u3059\u30029 \u3068\u3044\u3046\u5024\u306e bigint \u578b\u306f\u30c6\u30ad\u30b9\u30c8\u3067 1 \u30d0\u30a4\u30c8\u3057\u304b\u5fc5\u8981\u3068\u3057\u307e\u305b\u3093\u304c\u3001\u30d0\u30a4\u30ca\u30ea\u3067\u306f 8 \u30d0\u30a4\u30c8\u3092\u5fc5\u8981\u3068\u3059\u308b\u3053\u3068\u3092\u8003\u616e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u4e00\u65b9\u3001\u30c6\u30ad\u30b9\u30c8\u5f62\u5f0f\u304c\u30d0\u30a4\u30ca\u30ea\u5f62\u5f0f\u3088\u308a\u3082\u5927\u304d\u3044\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u306a\u3069\u306e\u30c7\u30fc\u30bf\u578b\u3082\u3042\u308a\u307e\u3059\u3002\u305f\u3068\u3048\u3070\u3001PostgreSQL \u306f\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3092\u683c\u7d0d\u3059\u308b\u305f\u3081\u306b 8 \u30d0\u30a4\u30c8\u3092\u4f7f\u7528\u3057\u307e\u3059\u304c\u3001\u30c6\u30ad\u30b9\u30c8\u5f62\u5f0f (\u4f8b: 2020-09-04 09:58:36.788916+02) \u306f 29 \u30d0\u30a4\u30c8\u3067\u3059\u3002\u30af\u30a8\u30ea\u304c\u6570\u767e\u4e07\u884c\u3092\u8fd4\u3059\u5834\u5408\u3001\u591a\u304f\u306e\u4f59\u5206\u306a\u30cd\u30c3\u30c8\u30ef\u30fc\u30af \u30c8\u30e9\u30d5\u30a3\u30c3\u30af\u304c\u767a\u751f\u3059\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/docs.citusdata.com\/en\/stable\/develop\/api_guc.html#citus-enable-binary-protocol-boolean\" class=\"c-hyperlink\" aria-label=\"citus.enable_binary_protocol: \u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u958b\u304d\u307e\u3059\u3002\">citus.enable_binary_protocol<\/a>\u3092\u6709\u52b9\u306b\u3059\u308b\u3068\u3001\u30d0\u30a4\u30ca\u30ea\u30d7\u30ed\u30c8\u30b3\u30eb\u3092\u4f7f\u7528\u3057\u3066\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3067\u304d\u308b\u305f\u3081\u3001\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u30c8\u30e9\u30d5\u30a3\u30c3\u30af\u3092\u524a\u6e1b\u3057\u3001\u30d0\u30a4\u30ca\u30ea\u8868\u73fe\u304c\u30c6\u30ad\u30b9\u30c8\u8868\u73fe(\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3001\u6d6e\u52d5\u5c0f\u6570\u70b9\u578b\u3001t-digest\u306a\u3069)\u3088\u308a\u3082\u306f\u308b\u304b\u306b\u30b3\u30f3\u30d1\u30af\u30c8\u306a\u30c7\u30fc\u30bf\u30bf\u30a4\u30d7\u306b\u306a\u308b\u306e\u3067<a href=\"https:\/\/docs.citusdata.com\/en\/stable\/performance\/performance_tuning.html#binary-protocol\" class=\"c-hyperlink\" aria-label=\"\u30af\u30a8\u30ea\u3092\u9ad8\u901f\u5316: \u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u958b\u304d\u307e\u3059\u3002\">\u30af\u30a8\u30ea\u3092\u9ad8\u901f\u5316<\/a>\u3067\u304d\u307e\u3059\u3002\u30d0\u30a4\u30ca\u30ea \u30d7\u30ed\u30c8\u30b3\u30eb\u306f\u3001\u5834\u5408\u306b\u3088\u3063\u3066\u306f\u30cd\u30c3\u30c8\u30ef\u30fc\u30af \u30c8\u30e9\u30d5\u30a3\u30c3\u30af\u3092\u5897\u3084\u3059\u53ef\u80fd\u6027\u304c\u3042\u308b\u305f\u3081 (\u305f\u3068\u3048\u3070\u3001\u5c0f\u3055\u306a\u6574\u6570)\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u7121\u52b9\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u304c\u3001\u7279\u306b\u30af\u30a8\u30ea\u304c\u591a\u304f\u306e\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3001\u6d6e\u52d5\u5c0f\u6570\u70b9\u578b\u3001\u307e\u305f\u306f\u30c6\u30ad\u30b9\u30c8\u8868\u73fe\u304c\u975e\u5e38\u306b\u9577\u3044\u4ed6\u306e\u30c7\u30fc\u30bf\u578b\u3092\u8fd4\u3059\u5834\u5408\u306f\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5411\u4e0a\u3055\u305b\u307e\u3059\u3002<\/p>\n<p><span style=\"font-size: 18pt;\"><strong>\u5206\u6563\u578b<\/strong><strong> Citus <\/strong><strong>\u30af\u30e9\u30b9\u30bf\u30fc\u3092\u64cd\u4f5c\u3059\u308b\u305f\u3081\u306e\u305d\u306e\u4ed6\u306e\u5236\u5fa1<\/strong><\/span><\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Citus <\/strong><strong>\u306e\u30c0\u30a6\u30f3\u30b0\u30ec\u30fc\u30c9 \u30b9\u30af\u30ea\u30d7\u30c8\uff1a<\/strong><\/span><\/p>\n<p class=\"c-paragraph-3\">\n    \u4ee5\u524d\u306f\u3001Citus \u306e\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9 \u30b9\u30af\u30ea\u30d7\u30c8\u306b\u3088\u3063\u3066\u30b9\u30ad\u30fc\u30de\u304c\u5909\u66f4\u3055\u308c\u3001\u5143\u306b\u623b\u3059\u3053\u3068\u304c\u3067\u304d\u306a\u3044\u305f\u3081\u3001Citus \u62e1\u5f35\u306f\u65b0\u3057\u3044\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u3059\u308b\u3053\u3068\u3057\u304b\u3067\u304d\u307e\u305b\u3093\u3067\u3057\u305f\u3002Citus 9.4\u306e\u6642\u70b9\u3067\u3001\u6211\u3005\u306f\u5404\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u30c0\u30a6\u30f3\u30b0\u30ec\u30fc\u30c9 \u30b9\u30af\u30ea\u30d7\u30c8\u3092\u7528\u610f\u3059\u308b\u3053\u3068\u3092\u7d04\u675f\u3057\u307e\u3057\u305f\u3002\u3064\u307e\u308a\u3001\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u3092\u884c\u3044\u3001\u4f55\u3089\u304b\u306e\u7406\u7531\u3067\u5143\u306b\u623b\u3059\u5fc5\u8981\u304c\u3042\u308b\u5834\u5408\u306f\u3001\u53e4\u3044\u30d0\u30fc\u30b8\u30e7\u30f3\u306e Citus \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3001<a href=\"https:\/\/docs.citusdata.com\/en\/v9.4\/admin_guide\/upgrading_citus.html#step-2-apply-update-in-db\" class=\"c-hyperlink\" aria-label=\"ALTER EXTENSION: \u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u958b\u304d\u307e\u3059\u3002\">ALTER EXTENSION<\/a> \u3092\u5b9f\u884c\u3057\u3066\u30b9\u30ad\u30fc\u30de\u306e\u5909\u66f4\u3092\u5143\u306b\u623b\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\n<\/p>\n<p><span style=\"font-size: 18pt;\"><strong>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u304c\u3059\u3079\u3066\u3067\u3059<\/strong><\/span><\/p>\n<p class=\"c-paragraph-3\">\n    Citus \u30e6\u30fc\u30b6\u306f\u3001\u6700\u3082\u56f0\u96e3\u306a\u30c7\u30fc\u30bf\u554f\u984c\u306e\u3044\u304f\u3064\u304b\u3092\u62b1\u3048\u3066\u3044\u307e\u3059\u3002Citus\u30e6\u30fc\u30b6\u306f\u591a\u304f\u306e\u30c7\u30fc\u30bf\u3092\u6301\u3063\u3066\u3044\u308b\u3060\u3051\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002Citus \u30e6\u30fc\u30b6\u306f\u901a\u5e38\u3001\u5c11\u306a\u3044\u30c7\u30fc\u30bf\u306b\u5bfe\u3059\u308b\u30af\u30a8\u30ea\u3068\u540c\u69d8\u306b\u3001\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u306b\u5bfe\u3059\u308b Postgres \u30af\u30a8\u30ea\u3092<em>\u53ef\u80fd\u306a\u9650\u308a\u9ad8\u901f<\/em>\u306b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u3001\u6025\u901f\u306b\u6210\u9577\u3059\u308b\u4e2d\u306b\u304a\u3044\u3066\u3082\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u30b9\u30e0\u30fc\u30ba\u306b\u52d5\u4f5c\u3057\u7d9a\u3051\u308b\u3053\u3068\u3092\u62c5\u4fdd\u3059\u308b\u76ee\u7684\u3092\u6301\u3063\u3066\u3044\u307e\u3059\u3002\n<\/p>\n<p class=\"c-paragraph-3\">\n    \u3053\u306e\u30ec\u30d9\u30eb\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5b9f\u73fe\u3059\u308b\u306b\u306f\u3001\u30cf\u30fc\u30c9\u30a6\u30a7\u30a2\u3092\u6700\u5927\u9650\u306b\u6d3b\u7528\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u305f\u3081\u30019.4 \u30ea\u30ea\u30fc\u30b9\u306b\u306f\u512a\u308c\u305f\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u6d1e\u5bdf\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u5411\u4e0a\u3001\u65b0\u3057\u3044\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9 \u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u306e\u53ef\u80fd\u6027\u304c\u6e80\u8f09\u3055\u308c\u3066\u3044\u307e\u3059\u3002\n<\/p>\n<p><a href=\"https:\/\/slack.citusdata.com\/\" class=\"c-hyperlink\" aria-label=\"Citus Slack \u306e\u65b0\u3057\u3044 9.4 \u30ea\u30ea\u30fc\u30b9\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002\">Citus Slack<\/a> \u3067\u65b0\u3057\u3044 9.4 \u30ea\u30ea\u30fc\u30b9\u306b\u3064\u3044\u3066\u3054\u5b58\u77e5\u306e\u901a\u308a\u3001\u30d0\u30b0\u3084\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u554f\u984c\u304c\u898b\u3064\u304b\u3063\u305f\u5834\u5408\u306f\u3001<a href=\"https:\/\/github.com\/citusdata\/citus\/issues\" class=\"c-hyperlink\" aria-label=\"GitHub \u3067\u5831\u544a: GitHub \u306e\u30d0\u30b0\u3084\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u554f\u984c\u3092\u5831\u544a\u3059\u308b\u306b\u306f\u3001\u3053\u3053\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002\">GitHub \u3067\u5831\u544a<\/a>\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u3042\u306a\u305f\u306e\u30d5\u30a3\u30fc\u30c9\u30d0\u30c3\u30af\u306f\u3001Citus\u3092\u3055\u3089\u306b\u826f\u304f\u3059\u308b\u306e\u306b\u5f79\u7acb\u3061\u307e\u3059\u3002<\/p>\n<p><span style=\"font-size: 18pt;\"><strong>\u8aad\u3093\u3067\u307f\u3066\u697d\u3057\u3081\u305f\u3067\u3057\u3087\u3046\u304b\uff1f<\/strong><\/span><\/p>\n<p class=\"c-paragraph-3\">\n    \u30c1\u30fc\u30e0\u304b\u3089\u306e\u6295\u7a3f\u3092\u3082\u3063\u3068\u8aad\u307f\u305f\u3051\u308c\u3070\u3001\u6bce\u6708\u306e\u30cb\u30e5\u30fc\u30b9\u30ec\u30bf\u30fc\u306b\u767b\u9332\u3059\u308c\u3070\u3001\u6700\u65b0\u306e\u30b3\u30f3\u30c6\u30f3\u30c4\u304c\u53d7\u4fe1\u30c8\u30ec\u30a4\u306b\u76f4\u63a5\u914d\u4fe1\u3055\u308c\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u203b\u672c\u30d6\u30ed\u30b0\u306f\u3001\u2018\u2019What\u2019s new in the Citus 9.4 extension to Postgres (citusdata.com)\u2018\u2019\u306e\u6284\u8a33\u3067\u3059\u3002 Postgres \u306eCitus \u62e1\u5f35\u6a5f\u80fd\u306e\u6700\u65b0\u30ea\u30ea\u30fc\u30b9 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6,72,5],"tags":[61,62,63,64,66,67,68,69,70,71],"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/posts\/1000"}],"collection":[{"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/comments?post=1000"}],"version-history":[{"count":38,"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/posts\/1000\/revisions"}],"predecessor-version":[{"id":7128,"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/posts\/1000\/revisions\/7128"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/media?parent=1000"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/categories?post=1000"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/ja-jp\/events\/azurebase\/wp-json\/wp\/v2\/tags?post=1000"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}