{"id":46154,"date":"2026-09-02T14:01:59","date_gmt":"2026-09-02T05:01:59","guid":{"rendered":"https:\/\/jore2.com\/?p=46154"},"modified":"2026-09-02T14:01:59","modified_gmt":"2026-09-02T05:01:59","slug":"tips-19446-io-uring-without-readahead","status":"publish","type":"post","link":"https:\/\/jore2.com\/?p=46154","title":{"rendered":"Turso io_uring \ubc31\uc5d4\ub4dc\uc5d0 \ub9ac\ub4dc\uc5b4\ud5e4\ub4dc \ub3c4\uc785\uc73c\ub85c \ub514\uc2a4\ud06c \uc694\uccad 19\ub9cc \uac74\uc5d0\uc11c 1\ub9cc 6\ucc9c \uac74\uc73c\ub85c \uac10\uc18c"},"content":{"rendered":"<div class=\"jore2-editor-byline\">\n<p><strong>JORE2 \ud3b8\uc9d1\ud300<\/strong> <span>\uacf5\uac1c \uc790\ub8cc\ub97c \ubc14\ud0d5\uc73c\ub85c \uc791\uc131\ud588\uc73c\uba70, \ud655\uc778 \uc790\ub8cc\ub97c \ud568\uaed8 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/span><\/p>\n<\/div>\n<p>Turso \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 io_uring \ubc31\uc5d4\ub4dc\uc5d0 \ub9ac\ub4dc\uc5b4\ud5e4\ub4dc \uae30\ub2a5\uc774 \ub3c4\uc785\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc774 \ubcc0\uacbd\uc740 io_uring\uacfc O_DIRECT \ud50c\ub798\uadf8\ub97c \ud568\uaed8 \uc0ac\uc6a9\ud560 \ub54c \ubc1c\uc0dd\ud558\ub358 \uc131\ub2a5 \ubcd1\ubaa9\uc744 \ud574\uacb0\ud558\uae30 \uc704\ud574 \uc9c4\ud589\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uae30\uc874 \ubc29\uc2dd\uc5d0\uc11c\ub294 \ucee4\ub110\uc758 \uc790\ub3d9 \ub9ac\ub4dc\uc5b4\ud5e4\ub4dc\uac00 \ube44\ud65c\uc131\ud654\ub418\uc5b4 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc774 \uc9c1\uc811 \ud398\uc774\uc9c0\ub97c \ud558\ub098\uc529 \uc694\uccad\ud574\uc57c \ud588\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ubca4\uce58\ub9c8\ud06c \uacb0\uacfc TPC-H Q6 \ucffc\ub9ac \uc2e4\ud589 \uc2dc \ub514\uc2a4\ud06c \uc694\uccad \uc218\uac00 \uc57d 19\ub9cc 6\ucc9c \uac74\uc5d0\uc11c \uc57d 1\ub9cc 6\ucc9c \uac74\uc73c\ub85c \uc904\uc5c8\uc2b5\ub2c8\ub2e4. \ub9ac\ub4dc\uc5b4\ud5e4\ub4dc\uac00 \ud65c\uc131\ud654\ub418\uba74 Turso\ub294 \uc21c\ucc28\uc801 \uc811\uadfc \ud328\ud134\uc744 \uac10\uc9c0\ud569\ub2c8\ub2e4. \ud398\uc774\uc9c0 100\uc774 \ud544\uc694\ud560 \ub54c 100\ubd80\ud130 131\uae4c\uc9c0 32\uac1c \ud398\uc774\uc9c0\ub97c \ud55c \ubc88\uc5d0 \uc81c\ucd9c\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub807\uac8c \ud558\uba74 \uc5ec\ub7ec \uc77d\uae30 \uc694\uccad\uc774 \ub3d9\uc2dc\uc5d0 \ucc98\ub9ac\ub418\uc5b4 \ub300\uae30 \uc2dc\uac04\uc774 \ub2e8\ucd95\ub429\ub2c8\ub2e4.<\/p>\n<p>O_DIRECT\ub97c \uc0ac\uc6a9\ud558\uba74 \ucee4\ub110 \ud398\uc774\uc9c0 \uce90\uc2dc\ub97c \uac70\uce58\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\uac00 \ub514\uc2a4\ud06c\uc5d0\uc11c \ud504\ub85c\uc138\uc2a4 \ubc84\ud37c\ub85c \uc9c1\uc811 \ubcf5\uc0ac\ub429\ub2c8\ub2e4. \uc774 \uacfc\uc815\uc5d0\uc11c CPU \uce90\uc2dc \ubbf8\uc2a4\uac00 \uc99d\uac00\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ud558\uc9c0\ub9cc \ub9ac\ub4dc\uc5b4\ud5e4\ub4dc\ub97c \ud1b5\ud574 \uc694\uccad\uc744 \ubcd1\ud569\ud558\uba74 \uc804\uccb4\uc801\uc778 I\/O \ud6a8\uc728\uc774 \uac1c\uc120\ub429\ub2c8\ub2e4. io_uring\uc758 SQ \ud3f4\ub9c1 \uc2a4\ub808\ub4dc\ub294 CPU \uc0ac\uc774\ud074\uc758 65%\ub97c \ucc28\uc9c0\ud560 \uc815\ub3c4\ub85c \uc790\uc6d0\uc744 \uc18c\ubaa8\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774 \ucd5c\uc801\ud654\ub294 \ud2b9\uc815 \uc870\uac74\uc5d0\uc11c \uac00\uc7a5 \ud6a8\uacfc\uc801\uc785\ub2c8\ub2e4. Alex Miller\ub294 \uc774 \ub9ac\ub4dc\uc5b4\ud5e4\ub4dc\uac00 \ubb3c\ub9ac\uc801 \uc21c\uc11c\uc5d0 \uae30\ubc18\ud55c \uc608\uce21\uc774\ub77c\uace0 \uc9c0\uc801\ud588\uc2b5\ub2c8\ub2e4. B-tree \ud398\uc774\uc9c0\uac00 \ud30c\uc77c \ub0b4\uc5d0\uc11c \ub17c\ub9ac\uc801 \uc21c\uc11c\uc640 \uc77c\uce58\ud558\ub294 \ud074\ub7ec\uc2a4\ud130\ub9c1 \uc0c1\ud0dc\uc77c \ub54c\ub9cc \uc131\ub2a5\uc774 \ud5a5\uc0c1\ub429\ub2c8\ub2e4.<\/p>\n<p>TPC-H \ubca4\uce58\ub9c8\ud06c\ub294 \ub370\uc774\ud130\uac00 \ud55c \ubc88 \uc0dd\uc131\ub41c \ud6c4 \uc5c5\ub370\uc774\ud2b8\ub418\uc9c0 \uc54a\uc544 \ud30c\uc77c\uc774 \uc798 \uc815\ub82c\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc7a5\uae30\uc801\uc778 \uc6cc\ud06c\ub85c\ub4dc\uc5d0\uc11c\ub294 \uc0c1\ud669\uc774 \ub2e4\ub985\ub2c8\ub2e4. \ub370\uc774\ud130\uac00 \uacc4\uc18d \ucd94\uac00\ub418\uace0 \uc0ad\uc81c\ub418\uba74 \ud30c\uc77c\uc774 \ub2e8\ud3b8\ud654\ub429\ub2c8\ub2e4. \ubb3c\ub9ac\uc801 \uc21c\uc11c\uac00 \uae68\uc9c0\uba74 \ub9ac\ub4dc\uc5b4\ud5e4\ub4dc\uc758 \uc608\uce21\uc774 \uc2e4\ud328\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub610\ud55c \uc784\ubca0\ub514\ub4dc \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ub2e4\ub978 \uc11c\ube44\uc2a4\uc640 \ud558\ub4dc\uc6e8\uc5b4\ub97c \uacf5\uc720\ud558\ub294 \ud658\uacbd\uc5d0\uc11c\ub294 \ucee4\ub110 \uce90\uc2dc \uad00\ub9ac\uc758 \uc911\uc694\uc131\uc774 \ubd80\uac01\ub429\ub2c8\ub2e4. \ucee4\ub110\uc740 \uc804\uccb4 \uc2dc\uc2a4\ud15c \uba54\ubaa8\ub9ac \uc0c1\ud0dc\ub97c \ud30c\uc545\ud558\uace0 \uc555\ub825 \uc2dc \uc790\uc6d0\uc744 \ubc18\ud658\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ud604\uc7ac\ub85c\uc11c\ub294 \ud074\ub7ec\uc2a4\ud130\ub9c1\ub41c \ub370\uc774\ud130\uc14b\uacfc \uc804\uc6a9 \ud558\ub4dc\uc6e8\uc5b4 \ud658\uacbd\uc5d0\uc11c io_uring \ub9ac\ub4dc\uc5b4\ud5e4\ub4dc\uc758 \uc774\uc810\uc774 \uba85\ud655\ud569\ub2c8\ub2e4. \ub2e8\ud3b8\ud654\ub41c \ub370\uc774\ud130\ub098 \uc790\uc6d0 \uacbd\uc7c1\uc774 \uc2ec\ud55c \ud658\uacbd\uc5d0\uc11c\uc758 \uc131\ub2a5 \uc800\ud558 \uac00\ub2a5\uc131\uc740 \uc5ec\uc804\ud788 \uac80\uc99d\uc774 \ud544\uc694\ud55c \ubd80\ubd84\uc785\ub2c8\ub2e4.<\/p>\n<aside class=\"jore2-source-notes\" aria-label=\"\uae30\uc0ac \ud655\uc778 \uc790\ub8cc\">\n<h2>\ud655\uc778\ud55c \uc790\ub8cc<\/h2>\n<ul>\n<li><a href=\"https:\/\/frn.sh\/io-uring\/\" target=\"_blank\" rel=\"noopener noreferrer\">frn.sh<\/a><\/li>\n<li><a href=\"https:\/\/news.ycombinator.com\/item?id=49521623\" target=\"_blank\" rel=\"noopener noreferrer\">news.ycombinator.com<\/a><\/li>\n<li><a href=\"https:\/\/zeli.app\/story\/49521623\" target=\"_blank\" rel=\"noopener noreferrer\">zeli.app<\/a><\/li>\n<\/ul>\n<\/aside>\n","protected":false},"excerpt":{"rendered":"<p>Turso\uc758 io_uring \ubc31\uc5d4\ub4dc\uc5d0 \ub9ac\ub4dc\uc5b4\ud5e4\ub4dc \uae30\ub2a5\uc774 \ucd94\uac00\ub418\uba74\uc11c TPC-H Q6 \ubca4\uce58\ub9c8\ud06c\uc5d0\uc11c \ub514\uc2a4\ud06c \uc694\uccad \uc218\uac00 \ub300\ud3ed \uc904\uc5c8\uc2b5\ub2c8\ub2e4. O_DIRECT \uc0ac\uc6a9 \uc2dc \ubc1c\uc0dd\ud558\ub294 \uc131\ub2a5 \uc800\ud558 \ubb38\uc81c\ub97c \ud574\uacb0\ud55c \uad6c\uccb4\uc801\uc778 \uc218\uce58\uc640 \ud55c\uacc4\ub97c \uc9da\uc5b4\ubd05\ub2c8\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":46153,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jore2_quality_policy":"people-first-v2","footnotes":""},"categories":[387],"tags":[15633,29774,29776,29772,29775,29773],"class_list":["post-46154","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-it","tag-io-uring","tag-o-direct","tag-tpc-h","tag-turso","tag-29775","tag-29773"],"featured_image_urls":{"full":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/09\/tips-19446-io-uring-without-readahead.png",1200,630,false],"thumbnail":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/09\/tips-19446-io-uring-without-readahead-150x150.png",150,150,true],"medium":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/09\/tips-19446-io-uring-without-readahead-300x158.png",300,158,true],"medium_large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/09\/tips-19446-io-uring-without-readahead-768x403.png",640,336,true],"large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/09\/tips-19446-io-uring-without-readahead-1024x538.png",640,336,true],"1536x1536":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/09\/tips-19446-io-uring-without-readahead.png",1200,630,false],"2048x2048":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/09\/tips-19446-io-uring-without-readahead.png",1200,630,false],"morenews-large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/09\/tips-19446-io-uring-without-readahead-825x575.png",825,575,true],"morenews-medium":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/09\/tips-19446-io-uring-without-readahead-590x410.png",590,410,true]},"author_info":{"info":["jore"]},"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\/46154","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=46154"}],"version-history":[{"count":0,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/posts\/46154\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/media\/46153"}],"wp:attachment":[{"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=46154"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=46154"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=46154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}