{"id":31577,"date":"2023-12-14T10:51:22","date_gmt":"2023-12-14T01:51:22","guid":{"rendered":"http:\/\/nori.company\/?p=31577"},"modified":"2023-12-14T10:51:22","modified_gmt":"2023-12-14T01:51:22","slug":"%eb%ac%b4%ec%a4%91%eb%8b%a8-postgres-%ec%97%85%ea%b7%b8%eb%a0%88%ec%9d%b4%eb%93%9c","status":"publish","type":"post","link":"https:\/\/nori.company\/?p=31577","title":{"rendered":"\ubb34\uc911\ub2e8 Postgres \uc5c5\uadf8\ub808\uc774\ub4dc"},"content":{"rendered":"<h2>Postgres \uc5c5\uadf8\ub808\uc774\ub4dc\ub97c \uc704\ud55c \uc900\ube44<\/h2>\n<ul>\n<li>\n<strong>\ub9ac\uc2a4\ud06c \ud3c9\uac00<\/strong>: \uc5c5\uadf8\ub808\uc774\ub4dc \uacfc\uc815\uc5d0\uc11c \ubc1c\uc0dd\ud560 \uc218 \uc788\ub294 \ub9ac\uc2a4\ud06c \ubaa9\ub85d \uc791\uc131 \ubc0f \uc911\uc694\ub3c4\uc5d0 \ub530\ub978 \uc815\ub82c.<\/li>\n<li>\n<strong>\ub9ac\uc2a4\ud06c \ud574\uacb0 \ubc29\uc548 \ubaa8\uc0c9<\/strong>: \ub9ac\uc2a4\ud06c\ub97c \uc644\uc804\ud788 \uc81c\uac70\ud558\uac70\ub098 \uc2dc\uac04\uc5d0 \uac78\uccd0 \ubd84\uc0b0\uc2dc\ud0ac \uc218 \uc788\ub294 \ud574\uacb0\ucc45 \uace0\ub824.<\/li>\n<li>\n<strong>\ub9ac\uc2a4&#8230;<\/p>\n<p>\ucd9c\ucc98 : <a href=\"https:\/\/news.hada.io\/topic?id=12325\" target=\"_blank\" rel=\"noopener\">GeekNews &#8211; \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4 <\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Postgres \uc5c5\uadf8\ub808\uc774\ub4dc\ub97c \uc704\ud55c \uc900\ube44 \ub9ac\uc2a4\ud06c \ud3c9\uac00: \uc5c5\uadf8\ub808\uc774\ub4dc \uacfc\uc815\uc5d0\uc11c \ubc1c\uc0dd\ud560 \uc218 \uc788\ub294 \ub9ac\uc2a4\ud06c \ubaa9\ub85d \uc791\uc131 \ubc0f \uc911\uc694\ub3c4\uc5d0 \ub530\ub978 \uc815\ub82c. \ub9ac\uc2a4\ud06c \ud574\uacb0&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-31577","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-8dj","jetpack-related-posts":[{"id":28346,"url":"https:\/\/nori.company\/?p=28346","url_meta":{"origin":31577,"position":0},"title":"Pgroll: Postgres\ub97c \uc704\ud55c \uc81c\ub85c \ub2e4\uc6b4\ud0c0\uc784, \ub418\ub3cc\ub9b4 \uc218 \uc788\ub294 \uc2a4\ud0a4\ub9c8 \ub9c8\uc774\uadf8\ub808\uc774\uc158","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 10\uc6d4 5\uc77c","format":false,"excerpt":"\uc774 \uae30\uc0ac\uc5d0\uc11c\ub294 PostgreSQL\uc744 \uc704\ud55c \uc548\uc804\ud558\uace0 \ub418\ub3cc\ub9b4 \uc218 \uc788\ub294 \uc2a4\ud0a4\ub9c8 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc744 \uc704\ud574 \uc124\uacc4\ub41c \uc0c8\ub85c\uc6b4 \uba85\ub839 \uc904 \ub3c4\uad6c\uc778 pgroll\uc744 \uc18c\uac1c\ud569\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\ud0a4\ub9c8 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc740 \uc2dc\uc2a4\ud15c \uc5c5\ub370\uc774\ud2b8\uc5d0 \ud544\uc218\uc801\uc774\uc9c0\ub9cc, \uc7a0\uc7ac\uc801\uc778 \ud30c\uad34\uc801 \ubcc0\ud654, \ubcf5\uc7a1\ud55c \ub2e4\ub2e8\uacc4 \ud504\ub85c\uc138\uc2a4, \uc608\uae30\uce58 \uc54a\uc740 \ub370\uc774... \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":30812,"url":"https:\/\/nori.company\/?p=30812","url_meta":{"origin":31577,"position":1},"title":"River &#8211; Go + Postgres \uc6a9 \ube60\ub974\uace0 \ub2e8\ub2e8\ud55c Job Queue","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 11\uc6d4 29\uc77c","format":false,"excerpt":"\uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ub370\uc774\ud130\uc640 \uc791\uc5c5 \ub300\uae30\uc5f4\uc5d0 \ub3d9\uc77c\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4(Postgres)\ub97c \uc0ac\uc6a9\ud558\ub3c4\ub85d \uad8c\uc7a5. \uc758\uc874\uc131 \ucd5c\uc18c\ud654 \ub2e4\ub978 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubcc0\uacbd\uacfc \ud568\uaed8 \ud2b8\ub79c\uc7ad\uc158 \ubc29\uc2dd\uc73c\ub85c \uc791\uc5c5\uc744 \ud050\uc5d0 \ub300\uae30\uc2dc\ud0b4\uc73c\ub85c\uc368 \ubd84\uc0b0 \uc2dc\uc2a4\ud15c \uc804\uccb4 \ud074\ub798\uc2a4\uc758 \ubb38\uc81c\ub97c \ubc29\uc9c0\ud560 \uc218 \uc788\uc74c Transactional enqueueing : \uc791\uc5c5\uc740 \ud2b8\ub79c\uc7ad\uc158\uc774 \ucee4\ubc0b... \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":26775,"url":"https:\/\/nori.company\/?p=26775","url_meta":{"origin":31577,"position":2},"title":"LLM \uae30\ubc18\uc758 \uc2dc\uc2a4\ud15c &#038; \uc81c\ud488 \uad6c\ucd95 \ud328\ud134\ub4e4","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 8\uc6d4 28\uc77c","format":false,"excerpt":"7\uac00\uc9c0 \ud575\uc2ec \ud328\ud134\uc744 \"\uc131\ub2a5 \ud5a5\uc0c1 vs. \ube44\uc6a9\/\ub9ac\uc2a4\ud06c \uac10\uc18c\" \ubc0f \"\ub370\uc774\ud130 \uce5c\ud654 vs \uc0ac\uc6a9\uc790 \uce5c\ud654\" \ub85c \uc815\ub9ac Evals: \uc131\ub2a5 \uce21\uc815 RAG(Retrieval-Augmented Generation): \ucd5c\uc2e0, \uc678\ubd80 \uc9c0\uc2dd\uc744 \ucd94\uac00 Fine-tuning: \ud2b9\uc815 \uc791\uc5c5\uc744 \ub354 \uc798 \uc218\ud589\ud558\uae30 \uc704\ud574 Caching: \ub808\uc774\ud134\uc2dc \ubc0f... \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":27950,"url":"https:\/\/nori.company\/?p=27950","url_meta":{"origin":31577,"position":3},"title":"Postgres\uc5d0\uc11c \ubcc0\ud654\ub97c \ud3ec\ucc29\ud558\ub294 \ubc29\ubc95\ub4e4","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 9\uc6d4 24\uc77c","format":false,"excerpt":"\uae30\uc0ac\ub294 Postgres \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubcc0\ud654\ub97c \ud3ec\ucc29\ud558\ub294 \ub2e4\uc591\ud55c \ubc29\ubc95\uc5d0 \ub300\ud574 \ub17c\uc758\ud569\ub2c8\ub2e4. Sequin\uc774\ub77c\ub294 \ud68c\uc0ac\ub294 Salesforce\uc640 HubSpot\uacfc \uac19\uc740 \uc81c3\uc790 API\ub85c\ubd80\ud130 \ub370\uc774\ud130\ub97c \ub3d9\uae30\ud654\ud558\uc5ec \uac1c\ubc1c\uc790\ub4e4\uc774 \uadf8\ub4e4\uc758 Postgres \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc5ec API \ub370\uc774\ud130\ub97c \uad6c\ucd95\ud558\uac8c \ud569\ub2c8\ub2e4. Postgres\ub294 \ud14c\uc774\ube14 \ubcc0\ud654\uc5d0 \uae30... \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":28008,"url":"https:\/\/nori.company\/?p=28008","url_meta":{"origin":31577,"position":4},"title":"Postgres \ud050 \uae30\uc220 \uc120\ud0dd","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 9\uc6d4 25\uc77c","format":false,"excerpt":"\"Postgres \ud050 \uae30\uc220 \uc0ac\uc6a9\uc758 \uc7a5\uc810\uc5d0 \ub300\ud55c \uae30\uc0ac, \ub2e4\ub978 '\ud655\uc7a5 \uac00\ub2a5\ud55c' \ud050 \uae30\uc220\ub4e4\uc5d0 \ube44\ud574 \uc6b0\uc6d4\ud558\ub2e4\ub294 \uc8fc\uc7a5\" \"Postgres \ud050 \uae30\uc220\uc774 \uc8fc\ub958\uac00 \uc544\ub2cc \uc774\uc720: \ub2e4\ub978 \ud050 \uae30\uc220\ub4e4\uc774 \ub354 \ud070 \ud655\uc7a5\uc131\uc744 \uc81c\uacf5\ud55c\ub2e4\ub294 \uc77c\ubc18\uc801\uc778 \uc0dd\uac01\" \"webapp.io\uc640 \uac19\uc740 \ud68c\uc0ac\ub4e4\uc774 \uc6b4\uc601\uc758 \ub2e8\uc21c\uc131, \uc720\uc9c0 \ubcf4\uc218\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":23816,"url":"https:\/\/nori.company\/?p=23816","url_meta":{"origin":31577,"position":5},"title":"Apple, iOS 17 \uacf5\uac1c","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 6\uc6d4 6\uc77c","format":false,"excerpt":"\uc804\ud654, \ud398\uc774\uc2a4\ud0c0\uc784, \uba54\uc2dc\uc9c0 \uc571\uc758 \ub300\ub300\uc801\uc778 \uc5c5\uadf8\ub808\uc774\ub4dc \ub9de\ucda4\ud615 \uc5f0\ub77d\ucc98 \ud3ec\uc2a4\ud130 \uae30\ub2a5: \uc804\ud654 \uac78\ub54c \uc0c1\ub300\ubc29\uc5d0\uac8c \ubcf4\uc774\ub294 \ubaa8\uc2b5\uc744 \uc0ac\uc6a9\uc790\ud654 \uac00\ub2a5. \ubbf8\ubaa8\uc9c0 + \ud0c0\uc774\ud3ec\uadf8\ub798\ud53c. \uc368\ub4dc\ud30c\ud2f0 \ud1b5\ud654\uc571\uc5d0\ub3c4 \uc0ac\uc6a9\uac00\ub2a5 \uc2e4\uc2dc\uac04 \uc74c\uc131 \uba54\uc2dc\uc9c0 \uae30\ub2a5\uc73c\ub85c \uc0c1\ub300\ubc29\uc774 \ub0a8\uae30\ub294 \uc74c\uc131 \uba54\uc2dc\uc9c0\ub97c \uc2e4\uc2dc\uac04 \uc804\uc0ac\ubb38(\ubc1b\uc544\uc4f0\uae30)\ub85c \ubcfc \uc218 \uc788... \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\/31577","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=31577"}],"version-history":[{"count":1,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/31577\/revisions"}],"predecessor-version":[{"id":31578,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/31577\/revisions\/31578"}],"wp:attachment":[{"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=31577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=31577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=31577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}