{"id":49249,"date":"2026-11-04T18:15:05","date_gmt":"2026-11-04T09:15:05","guid":{"rendered":"https:\/\/jore2.com\/?p=49249"},"modified":"2026-11-04T18:15:05","modified_gmt":"2026-11-04T09:15:05","slug":"tips-23027-the-internals-of-postgresql","status":"publish","type":"post","link":"https:\/\/jore2.com\/?p=49249","title":{"rendered":"PostgreSQL \ub0b4\ubd80 \uad6c\uc870 \ubb38\uc11c, 2026\ub144 6\uc6d4 \ube44\ub3d9\uae30 I\/O \uc139\uc158 \uc5c5\ub370\uc774\ud2b8"},"content":{"rendered":"
\n

\uc774\uac00\uc740<\/strong><\/p>\n<\/div>\n

Hironobu Suzuki\uac00 \uc6b4\uc601\ud558\ub294 InterDB \ud504\ub85c\uc81d\ud2b8\uc758 ‘The Internals of PostgreSQL’ \ubb38\uc11c\ub294 2026\ub144 9\uc6d4 26\uc77c\ub85c \uacf5\uac1c 11\uc8fc\ub144\uc744 \ub9de\uc774\ud588\ub2e4. \uc774 \uae30\uc220 \ud574\uc124\uc11c\ub294 2015\ub144 9\uc6d4 26\uc77c\uc5d0 \ucc98\uc74c \uc138\uc0c1\uc5d0 \ub098\uc654\ub2e4.<\/p>\n

\ucd5c\uadfc \uac00\uc7a5 \ub208\uc5d0 \ub744\ub294 \ubcc0\uacbd \uc0ac\ud56d\uc740 2026\ub144 6\uc6d4 28\uc77c\uc5d0 \uac8c\uc2dc\ub41c 8.5\uc7a5 ‘Asynchronous I\/O in PostgreSQL’\uc774\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5d4\uc9c4\uc774 \ub514\uc2a4\ud06c\uc640 \ud1b5\uc2e0\ud558\ub294 \ubc29\uc2dd \uc911 \ud558\ub098\uc778 \ube44\ub3d9\uae30 \uc785\ucd9c\ub825 \ucc98\ub9ac \uba54\ucee4\ub2c8\uc998\uc744 \uc0c1\uc138\ud788 \ub2e4\ub8ec\ub2e4.<\/p>\n

\uadf8\ubcf4\ub2e4 \uc55e\uc120 2026\ub144 5\uc6d4 1\uc77c\uc5d0\ub294 12\uc7a5 ‘Logical Replication’\uc758 \ubca0\ud0c0 \ubc84\uc804\uc774 \uacf5\uac1c\ub418\uc5c8\ub2e4. \ub17c\ub9ac\uc801 \ubcf5\uc81c\ub294 \ud14c\uc774\ube14 \ub2e8\uc704\uc758 \ub370\uc774\ud130\ub97c \ub2e4\ub978 \uc11c\ubc84\ub85c \uc804\uc1a1\ud558\ub294 \uae30\ub2a5\uc744 \uc758\ubbf8\ud55c\ub2e4. \uc544\uc9c1 \ubca0\ud0c0 \ub2e8\uacc4\uc774\ubbc0\ub85c \ucd5c\uc885 \uc644\uc131\ubcf8\uc740 \uc544\ub2c8\ub2e4.<\/p>\n

\ubb38\uc11c \uac31\uc2e0 \uc774\ub825\uc740 \uafb8\uc900\ud558\ub2e4. 2024\ub144 12\uc6d4 14\uc77c\uc5d0\ub294 11.2.4\uc808\uc5d0 \ucda9\ub3cc \uad00\ub828 \ub0b4\uc6a9\uc744 \ucd94\uac00\ud588\ub2e4. \uc774\ub7ec\ud55c \uc218\uc815 \uc0ac\ud56d\ub4e4\uc740 PostgreSQL\uc758 \uc9c4\ud654\ud558\ub294 \uc544\ud0a4\ud14d\ucc98\ub97c \ub530\ub77c\uc7a1\uae30 \uc704\ud55c \ub178\ub825\uc758 \uacb0\uacfc\ubb3c\uc774\ub2e4.<\/p>\n

\uc800\uc790 Hironobu Suzuki\ub294 \ud604\uc7ac \uc77c\ubcf8\uc5d0\uc11c \uac74\uac15 \ubc0f \uac1c\uc778 \uc0ac\uc815\uc73c\ub85c \uc778\ud55c \uc77c\uc2dc\uc801\uc778 \uccb4\ub958\ub97c \ub9c8\uce58\uace0 \ud68c\ubcf5 \uc0c1\ud0dc\uc5d0 \uc788\ub2e4. \uadf8\ub294 \uc720\ub7fd, \ub0a8\ubc18\uad6c, \ub3d9\ub0a8\uc544\uc2dc\uc544 \uc9c0\uc5ed\uc5d0\uc11c\uc758 \ud574\uc678 \uadfc\ubb34 \uae30\ud68c\ub97c \ucc3e\uace0 \uc788\ub2e4.<\/p>\n

\ube44\uc790 \uc2a4\ud3f0\uc11c\uc2ed\uc744 \uc81c\uacf5\ud558\ub294 \uc9c1\ucc45\uc774\ub098 \ub514\uc9c0\ud138 \ub178\ub9c8\ub4dc \uc0dd\ud65c\uc744 \uc9c0\uc6d0\ud558\ub294 \uc6d0\uaca9 \uadfc\ubb34 \ud615\ud0dc\ub97c \uc120\ud638\ud55c\ub2e4. \ucc44\uc6a9 \uc911\uc778 \ud300\uc740 \uc774\uba54\uc77c(hironobu@interdb.jp \ub610\ub294 interdb.mx@gmail.com)\uc774\ub098 DM\uc73c\ub85c \uc5f0\ub77d\ud560 \uc218 \uc788\ub2e4.<\/p>\n

\ud574\ub2f9 \ubb38\uc11c\ub294 Hacker News\uc5d0\uc11c \uc8fc\uae30\uc801\uc73c\ub85c \uc7ac\uc870\uba85\ub41c\ub2e4. 2025\ub144 3\uc6d4 \uc2a4\ub808\ub4dc\uc5d0\uc11c\ub294 Jepsen \ubcf4\uace0\uc11c\uc640 \uc5f0\uacc4\ud558\uc5ec SSI \uad6c\ud604\uc5d0 \ub300\ud55c \uad00\uc2ec\uc774 \uc5b8\uae09\ub418\uae30\ub3c4 \ud588\ub2e4. Hot Update \uacbd\ub85c\uc640 zHeap \uad6c\ud604 \ub178\ud2b8\uac00 \ud575\uc2ec \uc77d\uae30 \uac70\ub9ac\ub85c \uc81c\uc2dc\ub418\uc5c8\ub2e4.<\/p>\n

\ucd08\ubcf4 \uac1c\ubc1c\uc790\uc5d0\uac8c\ub294 AI \ucc57\ubd07\uacfc\uc758 \ub300\ud654\uac00 \uc720\uc0ac\ud55c \ud559\uc2b5 \uacbd\ud5d8\uc744 \uc81c\uacf5\ud560 \uc218 \uc788\ub2e4\ub294 \uc758\uacac\ub3c4 \ucee4\ubba4\ub2c8\ud2f0\uc5d0 \ub4f1\uc7a5\ud588\ub2e4. \ud558\uc9c0\ub9cc \uacf5\uc2dd \ubb38\uc11c\uc758 \uccb4\uacc4\uc801\uc778 \uad6c\uc870\ud654\ub294 \uc5ec\uc804\ud788 \uace0\uc720\ud55c \uac00\uce58\ub97c \uc9c0\ub2cc\ub2e4.<\/p>\n

\ub2e4\uc74c \uc8fc\uc694 \uc5c5\ub370\uc774\ud2b8 \uc77c\uc815\uc740 \uba85\uc2dc\ub418\uc9c0 \uc54a\uc558\ub2e4. \ub2e4\ub9cc 11\uc8fc\ub144 \uae30\ub150 \uc2dc\uc810 \uc774\ud6c4\uc5d0\ub3c4 \uc0c8\ub85c\uc6b4 PostgreSQL \ub9b4\ub9ac\uc2a4\uc5d0 \ub9de\ucdb0 \ub0b4\uc6a9\uc774 \ubcf4\uac15\ub420 \uac00\ub2a5\uc131\uc774 \ub192\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"

Hironobu Suzuki\uc758 PostgreSQL \ub0b4\ubd80 \ud574\uc124\uc11c\uac00 2026\ub144 6\uc6d4 28\uc77c \ube44\ub3d9\uae30 I\/O \uc7a5\uc744 \ucd94\uac00\ud558\uba70 11\uc8fc\ub144\uc744 \ub9de\uc558\ub2e4. \ucd5c\uc2e0 \uae30\ub2a5 \ubc18\uc601\uacfc \uc800\uc790\uc758 \ud65c\ub3d9 \ud604\ud669\uc744 \ud655\uc778\ud55c\ub2e4.<\/p>\n","protected":false},"author":4,"featured_media":49248,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jore2_quality_policy":"people-first-v2","footnotes":""},"categories":[387],"tags":[32576,32575,24126,11466,16474],"class_list":["post-49249","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-it","tag-hironobu-suzuki","tag-interdb","tag-postgresql","tag-11466","tag-16474"],"featured_image_urls":{"full":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/11\/title3.png",1998,716,false],"thumbnail":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/11\/title3-150x150.png",150,150,true],"medium":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/11\/title3-300x108.png",300,108,true],"medium_large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/11\/title3-768x275.png",640,229,true],"large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/11\/title3-1024x367.png",640,229,true],"1536x1536":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/11\/title3-1536x550.png",1536,550,true],"2048x2048":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/11\/title3.png",1998,716,false],"morenews-large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/11\/title3-825x575.png",825,575,true],"morenews-medium":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/11\/title3-590x410.png",590,410,true]},"author_info":{"info":["\uc774\uac00\uc740"]},"category_info":"IT&\uc0dd\ud65c\uafc0\ud301<\/a>","tag_info":"IT&\uc0dd\ud65c\uafc0\ud301","comment_count":"0","_links":{"self":[{"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/posts\/49249","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=49249"}],"version-history":[{"count":0,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/posts\/49249\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/media\/49248"}],"wp:attachment":[{"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=49249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=49249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=49249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}