{"id":25070,"date":"2023-07-18T15:53:30","date_gmt":"2023-07-18T06:53:30","guid":{"rendered":"http:\/\/nori.company\/?p=25070"},"modified":"2023-07-18T15:53:30","modified_gmt":"2023-07-18T06:53:30","slug":"postgresql-14-internal-%ec%b5%9c%ec%a2%85%eb%b3%b8","status":"publish","type":"post","link":"https:\/\/nori.company\/?p=25070","title":{"rendered":"PostgreSQL 14 Internal \ucd5c\uc885\ubcf8"},"content":{"rendered":"<p>PostgreSQL 14\uc758 \ub0b4\ubd80\uad6c\uc870(\uc2a4\ub0c5\uc0f7, \ubc84\ud37c\uce90\uc2dc, WAL, \uc7a0\uae08, \uc9c8\uc758 \uc2e4\ud589, \uac01\uc885 \uc0c9\uc778)\uc5d0 \ub300\ud574 \uc18c\uac1c\ud55c \ubb34\ub8cc \uc774\ubd81\uc758 \ucd5c\uc885\ubcf8\uc774 \uc9c0\ub09c 3\uc6d4 \uc988\uc74c\uc5d0 \ub098\uc654\uae38\ub798 \ub4a4\ub2a6\uac8c\ub098\ub9c8 \uc18c\uac1c\ud574 \ubd05\ub2c8\ub2e4.<\/p>\n<ul>\n<li>PDF \ub2e4\uc6b4\ub85c\ub4dc : https:\/\/ift.tt\/5SQZEap<\/li>\n<li>1\ub144 \uc804 \ud30c\ud2b81 \uacf5\uac1c \uc18c\uc2dd : https:\/\/new\n<p>\ucd9c\ucc98 : <a href=\"https:\/\/news.hada.io\/topic?id=9864\" target=\"_blank\" rel=\"noopener\">GeekNews &#8211; \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4 <\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL 14\uc758 \ub0b4\ubd80\uad6c\uc870(\uc2a4\ub0c5\uc0f7, \ubc84\ud37c\uce90\uc2dc, WAL, \uc7a0\uae08, \uc9c8\uc758 \uc2e4\ud589, \uac01\uc885 \uc0c9\uc778)\uc5d0 \ub300\ud574 \uc18c\uac1c\ud55c \ubb34\ub8cc \uc774\ubd81\uc758 \ucd5c\uc885\ubcf8\uc774 \uc9c0\ub09c 3\uc6d4 \uc988\uc74c\uc5d0 \ub098\uc654\uae38\ub798 \ub4a4\ub2a6\uac8c\ub098\ub9c8&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[138],"tags":[163],"class_list":["post-25070","post","type-post","status-publish","format-standard","hentry","category-it","tag-geeknews-----"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pa3PO4-6wm","jetpack-related-posts":[{"id":28615,"url":"https:\/\/nori.company\/?p=28615","url_meta":{"origin":25070,"position":0},"title":"\ud3ec\uc2a4\ud2b8\uadf8\ub808\uc2a4: \ub2e4\uc74c \uc138\ub300","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 10\uc6d4 12\uc77c","format":false,"excerpt":"1986\ub144\uc5d0 \ucd9c\uc2dc\ub41c \uc778\uae30 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud50c\ub7ab\ud3fc\uc778 PostgreSQL\uc758 \ubbf8\ub798\uc5d0 \ub300\ud55c \uae30\uc0ac \uc800\uc790 James Governor\ub294 \ud3c9\uade0 \uc5f0\ub839\uc774 50\uc138 \uc815\ub3c4\uc778 PostgreSQL\uc758 \uace0\ub839\ud654\ub41c \ud575\uc2ec \uac1c\ubc1c \ucee4\ubba4\ub2c8\ud2f0\ub97c \uac15\uc870 PostgreSQL \ucee4\ubbf8\ud130\uc778 Robert Haas\ub294 2022\ub144\uc5d0 \ucd5c\uc18c\ud55c \ud55c \ubc88\uc740 PostgreSQL \ucee4\ubc0b\uc758 \uc8fc\uc694 \uc800\uc790\uac00 \ub41c \uc0ac\ub78c\uc774 192\uba85... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":28050,"url":"https:\/\/nori.company\/?p=28050","url_meta":{"origin":25070,"position":1},"title":"CloudNativePG &#8211; PostgreSQL\uc744 Kubernetes \ubc29\uc2dd\uc73c\ub85c \uc2e4\ud589\ud558\uae30","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 9\uc6d4 26\uc77c","format":false,"excerpt":"\ub124\uc774\ud2f0\ube0c \uc2a4\ud2b8\ub9ac\ubc0d \ubcf5\uc81c\ub97c \uc0ac\uc6a9\ud558\ub294 Primary\/Standby \uc544\ud0a4\ud14d\ucc98\uc758 PostgreSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud074\ub7ec\uc2a4\ud130 \uc218\uba85\uc8fc\uae30\ub97c \uad00\ub9ac \uc140\ud504 \uce58\uc720, \uace0 \uac00\uc6a9\uc131(HA), \ub864\ub9c1 \uc5c5\ub370\uc774\ud2b8, \uc77d\uae30\uc804\uc6a9 \ubcf5\uc81c\ubcf8\uc758 Scale Up\/Down,.. Automated Failover\ub97c \ube44\ub86f\ud574\uc11c Deploy\/Manage \ub4f1\uc758 \ub9ce\uc740 \uc5c5\ubb34\ub97c \uc790\ub3d9\ud654... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":28808,"url":"https:\/\/nori.company\/?p=28808","url_meta":{"origin":25070,"position":2},"title":"PostgresJs: Node.js\uc640 Deno\ub97c \uc704\ud55c PostgreSQL \ud074\ub77c\uc774\uc5b8\ud2b8","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 10\uc6d4 16\uc77c","format":false,"excerpt":"Postgres.js\ub294 \uac04\ub2e8\ud55c API\ub97c \uac00\uc9c4 Node.js\uc640 Deno\uc6a9 PostgreSQL \ud074\ub77c\uc774\uc5b8\ud2b8\uc785\ub2c8\ub2e4. \uc774 \ud074\ub77c\uc774\uc5b8\ud2b8\ub294 ES6 \ud0dc\uadf8 \ud15c\ud50c\ub9bf \ubb38\uc790\uc5f4\uc744 \uc0ac\uc6a9\ud558\uba70 \ub3d9\uc801 \ucffc\ub9ac\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4. Gitter\uc5d0\uc11c \ucc44\ud305 \ubc0f \ub3c4\uc6c0\uc744 \uc81c\uacf5\ud558\uba70 npm\uc744 \ud1b5\ud574 \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Postgres.js\ub294 SQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\uc2a4\ud134\uc2a4 \uc0dd\uc131... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":27564,"url":"https:\/\/nori.company\/?p=27564","url_meta":{"origin":25070,"position":3},"title":"PostgreSQL 16","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 9\uc6d4 15\uc77c","format":false,"excerpt":"PostgreSQL 16\uc740 \ucffc\ub9ac \ubcd1\ub82c\uc131, \ub300\ub7c9 \ub370\uc774\ud130 \ub85c\ub529 \ubc0f \ub17c\ub9ac\uc801 \ubcf5\uc81c\uac00 \ub208\uc5d0 \ub744\uac8c \uac1c\uc120\ub418\uc5b4 \uc131\ub2a5\uc744 \ud5a5\uc0c1 \ub354 \ub9ce\uc740 SQL\/JSON \ubb38\ubc95, \uc791\uc5c5 \ubd80\ud558\ub97c \uc704\ud55c \uc0c8\ub85c\uc6b4 \ubaa8\ub2c8\ud130\ub9c1 \ud1b5\uacc4, \uadf8\ub9ac\uace0 \uc811\uadfc \uc81c\uc5b4 \uaddc\uce59\uc744 \uc815\uc758\ud558\ub294 \ub370 \ub354 \ud070 \uc720\uc5f0\uc131\uc744 \ub3c4\uc785 \uc131\ub2a5 \uac1c\uc120 \ucffc\ub9ac \ud50c\ub798\ub108\uac00 \uc774\uc81c FULL \ubc0f R... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":28145,"url":"https:\/\/nori.company\/?p=28145","url_meta":{"origin":25070,"position":4},"title":"Lantern &#8211; AI\uc571\uc744 \uc704\ud55c PostgreSQL Vector DB","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 9\uc6d4 28\uc77c","format":false,"excerpt":"\ubca1\ud130 \ub370\uc774\ud130 \uc800\uc7a5, Embedding \uc0dd\uc131, \ubca1\ud130 \uac80\uc0c9\uc744 \uc9c0\uc6d0\ud558\ub294 PostgreSQL \ud655\uc7a5 CLIP \ubaa8\ub378, Hugging Face \ubaa8\ub378, \ucee4\uc2a4\ud140 \ubaa8\ub378\uc5d0 \ub300\ud55c \uc784\ubca0\ub529 \uc0dd\uc131 \uc9c0\uc6d0 pgvector\uc758 \ub370\uc774\ud130 \ud0c0\uc785\uacfc \uc0c1\ud638 \uc5f0\ub3d9 \uc9c0\uc6d0 \ubcd1\ub82c \uc778\ub371\uc2a4 \uc0dd\uc131 \uac00\ub2a5 - DB \uc678\ubd80 \ubc0f \ub2e4\ub978 \uc778\uc2a4\ud134\uc2a4 \uc548\uc5d0 \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud574\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":25066,"url":"https:\/\/nori.company\/?p=25066","url_meta":{"origin":25070,"position":5},"title":"Kanel &#8211; PostgresSQL \uc5d0\uc11c Typescript types \uc0dd\uc131\ud558\uae30","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 7\uc6d4 18\uc77c","format":false,"excerpt":"\uc2e4\ud589\uc911\uc778 PostgreSQL DB\uc5d0\uc11c \uc2a4\ud0a4\ub9c8\ub97c \uc77d\uc5b4\uc11c \ud0c0\uc785\uc744 \uc0dd\uc131\ud558\ub294 Reverse ORM \uac19\uc740 \ub3c4\uad6c ORM\uc744 \uc2eb\uc5b4\ud558\uc9c0\ub9cc \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc811\uadfc \ucf54\ub4dc\uc5d0 \ub300\ud55c \uc778\ud154\ub9ac\uc13c\uc2a4 \ubc0f \ud0c0\uc785 \uccb4\ud0b9\uc744 \uc6d0\ud558\ub294 \uc0ac\ub78c\uc744 \uc704\ud55c \uac83 Postgres \uc811\uc18d \uc815\ubcf4\uc640 DB\ub9cc \uc8fc\uba74 \ub3d9\uc791 $ npx kanel -d postgresql:\/\/localhost:5432\/acm... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/25070","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=25070"}],"version-history":[{"count":1,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/25070\/revisions"}],"predecessor-version":[{"id":25071,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/25070\/revisions\/25071"}],"wp:attachment":[{"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=25070"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=25070"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=25070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}