{"id":26172,"date":"2023-08-14T11:54:24","date_gmt":"2023-08-14T02:54:24","guid":{"rendered":"http:\/\/nori.company\/?p=26172"},"modified":"2023-08-14T11:54:24","modified_gmt":"2023-08-14T02:54:24","slug":"retake-postgres%ec%9a%a9-%ed%95%98%ec%9d%b4%eb%b8%8c%eb%a6%ac%eb%93%9c-%ea%b2%80%ec%83%89-%ec%98%a4%ed%94%88%ec%86%8c%ec%8a%a4","status":"publish","type":"post","link":"https:\/\/nori.company\/?p=26172","title":{"rendered":"Retake &#8211; Postgres\uc6a9 \ud558\uc774\ube0c\ub9ac\ub4dc \uac80\uc0c9 \uc624\ud508\uc18c\uc2a4"},"content":{"rendered":"<ul>\n<li>\ud0a4\uc6cc\ub4dc(\uae30\uc874 \uac80\uc0c9) + \uc2dc\ub9e8\ud2f1 \uc11c\uce58(\ubca1\ud130 \uae30\ubc18 \uac80\uc0c9)\ub97c \ud558\ub098\uc758 SDK\uc5d0\uc11c \ud1b5\ud569\ud558\uc5ec \uc0ac\uc6a9\uac00\ub2a5\ud558\uac8c \ucd94\uac00 \uac00\ub2a5\n<ul>\n<li>query, with_semantic, with_neural \uc744 \ud1b5\ud574 \uac01\uac01 \ub610\ub294 \ud1b5\ud569\ud558\uc5ec \uac80\uc0c9 \uac00\ub2a5<\/li>\n<\/ul>\n<\/li>\n<li>\uc9c1\uc811 Postgres\uc5d0 \uc5f0\uacb0\ud558\uc5ec CDC \uae30\ubc18\uc73c\ub85c \ubcf5\uc81c\ud558\uace0 \uc778\ub371\uc2f1\uc744 \ucc98\ub9ac\n<ul>\n<li>\ub370\uc774\ud130 \ubcc0\uacbd\uc2dc \uc784\ubca0\ub529&#8230;\n<p>\ucd9c\ucc98 : <a href=\"https:\/\/news.hada.io\/topic?id=10341\" target=\"_blank\" rel=\"noopener\">GeekNews &#8211; \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4 <\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\ud0a4\uc6cc\ub4dc(\uae30\uc874 \uac80\uc0c9) + \uc2dc\ub9e8\ud2f1 \uc11c\uce58(\ubca1\ud130 \uae30\ubc18 \uac80\uc0c9)\ub97c \ud558\ub098\uc758 SDK\uc5d0\uc11c \ud1b5\ud569\ud558\uc5ec \uc0ac\uc6a9\uac00\ub2a5\ud558\uac8c \ucd94\uac00 \uac00\ub2a5 query, with_semantic, with_neural \uc744 \ud1b5\ud574 \uac01\uac01 \ub610\ub294&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-26172","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-6O8","jetpack-related-posts":[{"id":28586,"url":"https:\/\/nori.company\/?p=28586","url_meta":{"origin":26172,"position":0},"title":"pg_bm25 &#8211; Postgres\uc5d0\uc11c Elastic \uc218\uc900\uc758 \ud488\uc9c8\uc744 \uc81c\uacf5\ud558\ub294 Full-Text \uac80\uc0c9 \ud655\uc7a5","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 10\uc6d4 11\uc77c","format":false,"excerpt":"Rust \uae30\ubc18\uc758 Postgres \ud655\uc7a5\uc73c\ub85c Full Text \uac80\uc0c9\uc744 \ud5a5\uc0c1\uc2dc\ucf1c\uc90c \ucd5c\uc2e0 \uac80\uc0c9 \uc5d4\uc9c4\ub4e4\uc774 \uc774\uc6a9\ud558\ub294 BM25 \uc54c\uace0\ub9ac\ub4ec(\uac80\uc0c9 \uacb0\uacfc\uc758 \uad00\ub828\uc131 \uc810\uc218\ub97c \uacc4\uc0b0) \uae30\ubc18 \ud604\uc7ac Postgres \uac00 \uc0ac\uc6a9\ud558\ub294 tsvector \uae30\ubc18 \uac80\uc0c9\uc740 2\uac1c\uc758 \ubb38\uc81c\uac00 \uc788\uc74c \uc131\ub2a5 : \ub300\uaddc\ubaa8 \ud14c\uc774\ube14\uc5d0\uc11c\uc758 \uac80\uc0c9\uc774 \ub290\ub9bc \uae30\ub2a5 : \ud37c\uc9c0... \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":27018,"url":"https:\/\/nori.company\/?p=27018","url_meta":{"origin":26172,"position":1},"title":"\uc624\ud504\ub77c\uc778\uc5d0\uc11c \uc218\ubc31\ub9cc \ud398\uc774\uc9c0\ub97c \ud1b5\ud55c &#8216;Wikipedia&#8217; \uc9c4\ub3d9 \uac80\uc0c9","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 9\uc6d4 3\uc77c","format":false,"excerpt":"\uc0c8\ub85c\uc6b4 \ube0c\ub77c\uc6b0\uc800 \uae30\ubc18 \uc704\ud0a4\ubc31\uacfc \uac80\uc0c9 \uc5d4\uc9c4\uc5d0 \ub300\ud55c \uae30\uc0ac, \uc624\ud504\ub77c\uc778 \uac80\uc0c9 \uac00\ub2a5 \uac80\uc0c9 \uc5d4\uc9c4\uc758 \uc2e4\uc2dc\uac04 \uc704\ud0a4\ubc31\uacfc \ud398\uc774\uc9c0 \ubc31\ub9cc \uac1c \uac80\uc0c9 \uae30\ub2a5, \ubaa8\ubc14\uc77c \uae30\uae30\uc5d0\uc11c 10ms\ub9c8\ub2e4 \uacb0\uacfc \ubc18\ud658 \uac80\uc0c9 \uc5d4\uc9c4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc791\uc740 \ud06c\uae30, \ud2b9\ubcc4\ud55c \ucc98\ub9ac \uc5c6\uc774 \ubc31\ub9cc \uac1c\uc758 \uc784\ubca0\ub529\uc744 \uc9c0\uc6d0\ud558\ub294 \uce90\uc8fc\uc5bc \uc0ac\uc6a9 \uc0ac\ub840 \ubb38... \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":27874,"url":"https:\/\/nori.company\/?p=27874","url_meta":{"origin":26172,"position":2},"title":"\uc6d4 $10\uc5d0 \ubb34\uc81c\ud55c Kagi \uac80\uc0c9 \uac00\ub2a5","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 9\uc6d4 22\uc77c","format":false,"excerpt":"Kagi \uac80\uc0c9 \uc5d4\uc9c4\uc774 Professional \ud50c\ub79c\uc5d0 \uc6d4 10\ub2ec\ub7ec \ubb34\uc81c\ud55c \uac80\uc0c9 \uc81c\uacf5 \uc2dc\uc791 \uc0ac\uc6a9\uc790 \ud53c\ub4dc\ubc31\uc5d0 \ub530\ub978 \uac83\uc73c\ub85c, \uae30\uc874 \uad11\uace0 \uc9c0\uc6d0 \uac80\uc0c9\uc5d0\uc11c \uc804\ud658 \uc2dc \uac80\uc0c9 \uc2b5\uad00\uc744 \ubc14\uafb8\ub294 \uac83\uc774 \uc911\uc694\ud558\uae30 \ub54c\ubb38 \uc5f0\uac04 \uacb0\uc81c\uc2dc 10% \ud560\uc778 \uc81c\uacf5 \ubb34\uc81c\ud55c \ubb38\uc11c, \uc624\ub514\uc624, \ube44\ub514\uc624 \uc694\uc57d \uac00\ub2a5\ud55c Universal Summarizer \uc0ac\uc6a9 \ubb34... \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":23065,"url":"https:\/\/nori.company\/?p=23065","url_meta":{"origin":26172,"position":3},"title":"Github \ucf54\ub4dc \uac80\uc0c9\uc744 \uc77c\ubc18\uc801\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 5\uc6d4 9\uc77c","format":false,"excerpt":"\ubbf8\ub9ac\ubcf4\uae30\ub85c \uc81c\uacf5\ub418\ub358 Github code search\uac00 \uc815\uc2dd \uacf5\uac1c\ub428. \uae30\uc874 \ucf54\ub4dc \uac80\uc0c9\ubcf4\ub2e4 \uc57d 2\ubc30 \ube60\ub974\uace0 \uae30\ud638 \uac80\uc0c9, \uc815\uaddc\uc2dd \uac80\uc0c9 \ub4f1 \ub354 \ubcf5\uc7a1\ud55c \uac80\uc0c9 \uc218\ud589 \uac00\ub2a5. \ucf54\ub4dc\ub97c \ud0d0\uc0c9\ud558\ub294 UI \ub610\ud55c \ud06c\uac8c \uac1c\uc120\ud558\uc5ec \uc5f0\uacb0\ub41c \ucf54\ub4dc\ub97c \ucc3e\ub294\uac8c \uc26c\uc6cc\uc9d0. ... \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":23680,"url":"https:\/\/nori.company\/?p=23680","url_meta":{"origin":26172,"position":4},"title":"yt-fts &#8211; \uc720\ud29c\ube0c \ud480\ud14d\uc2a4\ud2b8 \uac80\uc0c9","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 5\uc6d4 31\uc77c","format":false,"excerpt":"\ud2b9\uc815 \uc720\ud29c\ube0c \ucc44\ub110\ub4e4\uc758 \uc804\uccb4 \uc790\ub9c9\ub4e4\uc744 \ub2e4\uc6b4\ub85c\ub4dc\ud574\uc11c SQLite\uc5d0 \uc800\uc7a5\ud6c4 \uac80\uc0c9 \uac00\ub2a5\ud558\uac8c \ud574\uc8fc\ub294 \ucee4\ub9e8\ub4dc \ub77c\uc778 \ub3c4\uad6c \uac80\uc0c9\uacb0\uacfc\ub85c \ud574\ub2f9 \ud0a4\uc6cc\ub4dc\uac00 \ub098\uc624\ub294 \ube44\ub514\uc624\uc758 \ud0c0\uc784\uc2a4\ud0ec\ud504 URL\uc744 \uc81c\uacf5 \ucc44\ub110 \ucd94\uac00 \ubc0f \uc0ad\uc81c \uae30\ub2a5\uc73c\ub85c \uc5ec\ub7ec\uac1c\uc758 \ucc44\ub110 \uad00\ub9ac \uac80\uc0c9\uacb0\uacfc\ub97c CSV\ub85c \uc800\uc7a5 \uac00\ub2a5 ... \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":23619,"url":"https:\/\/nori.company\/?p=23619","url_meta":{"origin":26172,"position":5},"title":"\uad6c\uae00 \uac80\uc0c9 \uacb0\uacfc\uc5d0 ChatGPT \uc2a4\ud0c0\uc77c\uc758 \uc0dd\uc131\ud615 AI \uacb0\uacfc\uac00 \ub178\ucd9c\ub418\uae30 \uc2dc\uc791","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 5\uc6d4 29\uc77c","format":false,"excerpt":"\uad6c\uae00 Search Labs \uc5d0\uc11c SGE(Search Generative Experience)\uc5d0 opt-in \ud55c \uc0ac\uc6a9\uc790\ub4e4 \ub300\uc0c1 (\ubbf8\uad6d\ub0b4\uc5d0\uc11c\ub9cc Waitlist\uc5d0 \ub4f1\ub85d \uac00\ub2a5) \ubaa8\ubc14\uc77c\/\ub370\uc2a4\ud06c\ud0d1\uc5d0\uc11c \ubaa8\ub450 \uc0dd\uc131\ud615 AI\uac00 \ub9cc\ub4e0 \uacb0\uacfc\uac00 \uc0c1\ub2e8\uc5d0 \ub178\ucd9c \uae30\uc874 \uac80\uc0c9 \uacb0\uacfc \uc0c1\ub2e8\uc5d0 \uceec\ub7ec\ud480\ud55c \ubc15\uc2a4\ub85c \ubcf4\uc5ec\uc9c0\uba70, \uc778\ud130\ub137\uc5d0\uc11c \uc218\uc9d1\ud55c \ub2e4\uc591\ud55c \uc815\ubcf4\ub97c \ubcf4\uae30 \uc88b\uac8c \uc815... \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\/26172","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=26172"}],"version-history":[{"count":1,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/26172\/revisions"}],"predecessor-version":[{"id":26173,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/26172\/revisions\/26173"}],"wp:attachment":[{"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=26172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=26172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=26172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}