{"id":47541,"date":"2026-10-11T20:53:58","date_gmt":"2026-10-11T11:53:58","guid":{"rendered":"https:\/\/jore2.com\/?p=47541"},"modified":"2026-10-11T20:53:58","modified_gmt":"2026-10-11T11:53:58","slug":"tips-21553-why-duckdb-2-0-is-faster","status":"publish","type":"post","link":"https:\/\/jore2.com\/?p=47541","title":{"rendered":"DuckDB 2.0, \uc7ac\uadc0 CTE\uc640 \ube44\ub3d9\uae30 I\/O\ub85c \uc131\ub2a5 \uac1c\uc120"},"content":{"rendered":"<div class=\"jore2-editor-byline\">\n<p><strong>\uc774\uac00\uc740<\/strong><\/p>\n<\/div>\n<p>DuckDB \ud504\ub85c\uc81d\ud2b8\uac00 2.0 \ubc84\uc804\uc758 \uc54c\ud30c \ub9b4\ub9ac\uc2a4\ub97c \uacf5\uac1c\ud558\uba70 \uc8fc\uc694 \uc131\ub2a5 \uac1c\uc120 \uc0ac\ud56d\uc744 \ubc1c\ud45c\ud588\uc2b5\ub2c8\ub2e4. \uc774\ubc88 \uc5c5\ub370\uc774\ud2b8\ub294 \ub370\uc774\ud130 \ud30c\uc774\ud504\ub77c\uc778\uacfc \ud14c\uc774\ube14 \ubaa8\ub378\ub9c1\uc744 \ud558\ub294 \uac1c\ubc1c\uc790\ub4e4\uc5d0\uac8c \uc2e4\uc9c8\uc801\uc778 \uc18d\ub3c4 \ud5a5\uc0c1\uc744 \uc81c\uacf5\ud558\ub294 \ub370 \ucd08\uc810\uc744 \ub9de\ucdc4\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ud575\uc2ec \ubcc0\ud654 \uc911 \ud558\ub098\ub294 \uc7ac\uadc0 \uacf5\ud1b5 \ud14c\uc774\ube14 \ud45c\ud604\uc2dd \ucc98\ub9ac \ubc29\uc2dd\uc785\ub2c8\ub2e4. MotherDuck \ube14\ub85c\uadf8\uc5d0 \ub530\ub974\uba74 \ud2b9\uc815 \ubca4\uce58\ub9c8\ud06c \ud658\uacbd\uc5d0\uc11c \uc7ac\uadc0 CTE \ucffc\ub9ac \uc2e4\ud589 \uc18d\ub3c4\uac00 \uae30\uc874 1.5.5 \ubc84\uc804 \ub300\ube44 \ucd5c\ub300 90\ubc30\uae4c\uc9c0 \ud5a5\uc0c1\ub41c \uac83\uc73c\ub85c \ub098\ud0c0\ub0ac\uc2b5\ub2c8\ub2e4. \uc774\ub294 \ubc18\ubcf5\uc801\uc778 \ud574\uc2dc \ud14c\uc774\ube14 \uc7ac\uad6c\ucd95 \uc791\uc5c5\uc744 \uc81c\uac70\ud558\uc5ec \ubd88\ud544\uc694\ud55c \uc5f0\uc0b0\uc744 \uc904\uc778 \uacb0\uacfc\ub85c \ubd84\uc11d\ub429\ub2c8\ub2e4.<\/p>\n<p>\uc6d0\uaca9 \uc2a4\ud1a0\ub9ac\uc9c0 \uc811\uadfc \ubc29\uc2dd\uc5d0\ub3c4 \ud070 \ubcc0\ud654\uac00 \uc0dd\uacbc\uc2b5\ub2c8\ub2e4. DuckDB 2.0\uc740 \ube44\ub3d9\uae30 I\/O \uc544\ud0a4\ud14d\ucc98\ub97c \ub3c4\uc785\ud588\uc2b5\ub2c8\ub2e4. Amazon S3\uc5d0 \uc800\uc7a5\ub41c 2.2GB \uaddc\ubaa8\uc758 Parquet \ud30c\uc77c\uc744 \uc77d\ub294 \ud14c\uc2a4\ud2b8\uc5d0\uc11c \ucc98\ub9ac \uc18d\ub3c4\uac00 \uc57d 2.4\ubc30 \uc99d\uac00\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774\uc804 \ubc84\uc804\uc5d0\uc11c\ub294 \ub124\ud2b8\uc6cc\ud06c \ub300\uae30\uc640 CPU \ub514\ucf54\ub529 \uc791\uc5c5\uc774 \uc21c\ucc28\uc801\uc73c\ub85c \uc774\ub8e8\uc5b4\uc838 \uc790\uc6d0\uc774 \ub0ad\ube44\ub418\uc5c8\uc9c0\ub9cc, \uc0c8 \ubc84\uc804\uc5d0\uc11c\ub294 \ub2e4\uc6b4\ub85c\ub4dc \uc804\uc6a9 \uc2a4\ub808\ub4dc \ud480\uacfc \uacc4\uc0b0\uc6a9 \uc6cc\ucee4 \uc2a4\ub808\ub4dc\ub97c \ubd84\ub9ac\ud574 \ubcd1\ub82c\uc131\uc744 \ub192\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub370\uc774\ud130 \ud0c0\uc785 \ucc98\ub9ac \ud6a8\uc728\ub3c4 \uac1c\uc120\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc0c8\ub85c\uc6b4 VARIANT \ud0c0\uc785\uc740 \uae30\uc874 JSON \ud14d\uc2a4\ud2b8 \ud615\uc2dd\ubcf4\ub2e4 \uc57d 6\ubc30 \ube60\ub978 \uc870\ud68c \uc131\ub2a5\uc744 \ubcf4\uc600\uc2b5\ub2c8\ub2e4. \uc774\ub294 \uad6c\uc870\ud654\ub41c \ub370\uc774\ud130\ub97c \ub354 \ud6a8\uc728\uc801\uc73c\ub85c \uc800\uc7a5\ud558\uace0 \uac80\uc0c9\ud560 \uc218 \uc788\uac8c \ud574\uc90d\ub2c8\ub2e4.<\/p>\n<p>\ub2e4\ub9cc \uc774\ub7ec\ud55c \uc218\uce58\ub4e4\uc740 \ub2e8\uc77c M5 \ub178\ud2b8\ubd81\uacfc \uac00\uc815\uc6a9 \uc778\ud130\ub137 \ud658\uacbd\uc744 \uae30\ubc18\uc73c\ub85c \ud55c \uce21\uc815\uac12\uc785\ub2c8\ub2e4. \ud074\ub77c\uc6b0\ub4dc \ucef4\ud4e8\ud305 \ud658\uacbd\uc774\ub098 \ub2e4\ub978 \ud558\ub4dc\uc6e8\uc5b4 \uad6c\uc131\uc5d0\uc11c\ub294 \uacb0\uacfc\uac00 \ub2ec\ub77c\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c \ud604\uc7ac\uae4c\uc9c0 \ub3c5\ub9bd\uc801\uc778 \uc81c3\uc790 \ubca4\uce58\ub9c8\ud06c \uac80\uc99d\uc744 \uac70\uce58\uc9c0 \uc54a\uc740 \uc0c1\ud0dc\uc774\ubbc0\ub85c, \uc2e4\uc81c \ud504\ub85c\ub355\uc158 \uc6cc\ud06c\ub85c\ub4dc \uc801\uc6a9 \uc804 \uc790\uccb4 \ud14c\uc2a4\ud2b8\uac00 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n<p>DuckDB 2.0 \uc815\uc2dd \ubc84\uc804\uc740 2026\ub144 10\uc6d4 21\uc77c \ucd9c\uc2dc\ub420 \uc608\uc815\uc785\ub2c8\ub2e4. \uc774\ud6c4 11\uc6d4 18\uc77c\uc5d0\ub294 2.0.1 \ud328\uce58\uac00 \uacc4\ud68d\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ubc88 \ub9b4\ub9ac\uc2a4\ub294 v1.5 \ubc30\ud3ec \uc774\ud6c4 1\ub9cc \uac74 \uc774\uc0c1\uc758 \ucee4\ubc0b\uc774 \ubc18\uc601\ub41c \ub300\uaddc\ubaa8 \uc5c5\ub370\uc774\ud2b8\ub85c, \uc11c\ubc84\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c\uc11c\uc758 \uae30\ub2a5\uc744 \uac15\ud654\ud558\ub294 \ubc29\ud5a5\uc744 \uc81c\uc2dc\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DuckDB 2.0 \uc54c\ud30c \ubc84\uc804\uc774 \uacf5\uac1c\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc7ac\uadc0 CTE \ucffc\ub9ac \uc18d\ub3c4\uac00 \ucd5c\ub300 90\ubc30 \ube68\ub77c\uc9c0\uace0, S3 \ub370\uc774\ud130 \uc77d\uae30 \uc2dc \ube44\ub3d9\uae30 I\/O \ub3c4\uc785\uc73c\ub85c \ub300\uae30 \uc2dc\uac04\uc774 \uc904\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"author":4,"featured_media":47540,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jore2_quality_policy":"people-first-v2","footnotes":""},"categories":[387],"tags":[16938,16474,31297,4159,31298],"class_list":["post-47541","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-it","tag-duckdb","tag-16474","tag-i-o","tag-4159","tag-cte"],"featured_image_urls":{"full":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/10\/duckdb20-96b85ab729.png",1600,865,false],"thumbnail":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/10\/duckdb20-96b85ab729-150x150.png",150,150,true],"medium":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/10\/duckdb20-96b85ab729-300x162.png",300,162,true],"medium_large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/10\/duckdb20-96b85ab729-768x415.png",640,346,true],"large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/10\/duckdb20-96b85ab729-1024x554.png",640,346,true],"1536x1536":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/10\/duckdb20-96b85ab729-1536x830.png",1536,830,true],"2048x2048":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/10\/duckdb20-96b85ab729.png",1600,865,false],"morenews-large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/10\/duckdb20-96b85ab729-825x575.png",825,575,true],"morenews-medium":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/10\/duckdb20-96b85ab729-590x410.png",590,410,true]},"author_info":{"info":["\uc774\uac00\uc740"]},"category_info":"<a href=\"https:\/\/jore2.com\/?cat=387\" rel=\"category\">IT&amp;\uc0dd\ud65c\uafc0\ud301<\/a>","tag_info":"IT&amp;\uc0dd\ud65c\uafc0\ud301","comment_count":"0","_links":{"self":[{"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/posts\/47541","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=47541"}],"version-history":[{"count":0,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/posts\/47541\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/media\/47540"}],"wp:attachment":[{"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=47541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=47541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=47541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}