{"id":28586,"date":"2023-10-11T12:53:18","date_gmt":"2023-10-11T03:53:18","guid":{"rendered":"http:\/\/nori.company\/?p=28586"},"modified":"2023-10-11T12:53:18","modified_gmt":"2023-10-11T03:53:18","slug":"pg_bm25-postgres%ec%97%90%ec%84%9c-elastic-%ec%88%98%ec%a4%80%ec%9d%98-%ed%92%88%ec%a7%88%ec%9d%84-%ec%a0%9c%ea%b3%b5%ed%95%98%eb%8a%94-full-text-%ea%b2%80%ec%83%89-%ed%99%95%ec%9e%a5","status":"publish","type":"post","link":"https:\/\/nori.company\/?p=28586","title":{"rendered":"pg_bm25 &#8211; Postgres\uc5d0\uc11c Elastic \uc218\uc900\uc758 \ud488\uc9c8\uc744 \uc81c\uacf5\ud558\ub294 Full-Text \uac80\uc0c9 \ud655\uc7a5"},"content":{"rendered":"<ul>\n<li>Rust \uae30\ubc18\uc758 Postgres \ud655\uc7a5\uc73c\ub85c Full Text \uac80\uc0c9\uc744 \ud5a5\uc0c1\uc2dc\ucf1c\uc90c<\/li>\n<li>\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<\/li>\n<li>\ud604\uc7ac Postgres \uac00 \uc0ac\uc6a9\ud558\ub294 tsvector \uae30\ubc18 \uac80\uc0c9\uc740 2\uac1c\uc758 \ubb38\uc81c\uac00 \uc788\uc74c\n<ul>\n<li>\uc131\ub2a5 : \ub300\uaddc\ubaa8 \ud14c\uc774\ube14\uc5d0\uc11c\uc758 \uac80\uc0c9\uc774 \ub290\ub9bc<\/li>\n<li>\uae30\ub2a5 : \ud37c\uc9c0&#8230;\n<p>\ucd9c\ucc98 : <a href=\"https:\/\/news.hada.io\/topic?id=11287\" 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>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&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-28586","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-7r4","jetpack-related-posts":[{"id":26172,"url":"https:\/\/nori.company\/?p=26172","url_meta":{"origin":28586,"position":0},"title":"Retake &#8211; Postgres\uc6a9 \ud558\uc774\ube0c\ub9ac\ub4dc \uac80\uc0c9 \uc624\ud508\uc18c\uc2a4","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 8\uc6d4 14\uc77c","format":false,"excerpt":"\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 \ud1b5\ud569\ud558\uc5ec \uac80\uc0c9 \uac00\ub2a5 \uc9c1\uc811 Postgres\uc5d0 \uc5f0\uacb0\ud558\uc5ec CDC \uae30\ubc18\uc73c\ub85c \ubcf5\uc81c\ud558\uace0 \uc778\ub371\uc2f1\uc744 \ucc98\ub9ac \ub370\uc774\ud130 \ubcc0\uacbd\uc2dc \uc784\ubca0\ub529... \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":28586,"position":1},"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":28586,"position":2},"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":29364,"url":"https:\/\/nori.company\/?p=29364","url_meta":{"origin":28586,"position":3},"title":"\ub2f9\uc2e0\uc774 \uc544\ub9c8\ub3c4 SQLite\ub97c \uc0ac\uc6a9\ud574\uc57c \ud558\ub294 \uc774\uc720","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 10\uc6d4 28\uc77c","format":false,"excerpt":"\uc6f9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ub370\uc774\ud130 \uc800\uc7a5\uc5d0 SQLite \uc0ac\uc6a9\uc758 \uc774\uc810\uc5d0 \ub300\ud55c \uae30\uc0ac, MySQL \ubc0f Postgres\uc640 \uac19\uc740 \ub2e4\ub978 \uc194\ub8e8\uc158\uacfc \ube44\uad50 SQLite\ub294 SQL \uae30\ubc18 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub2e8\uc77c \ud30c\uc77c\uc5d0 \uc800\uc7a5\ud558\uc5ec \uac04\ub2e8\ud558\uace0 \uace0\uae09 \uc0ac\uc6a9 \uc0ac\ub840 \ubaa8\ub450\uc5d0 \uac04\ub2e8\ud55c \uc194\ub8e8\uc158 \uc81c\uacf5 SQLite\ub294 \ub2e8\uc77c \ud30c\uc77c \uad6c\uc870\ub85c \uc778\ud55c \uc81c\ub85c \uc9c0\uc5f0... \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":28586,"position":4},"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":31577,"url":"https:\/\/nori.company\/?p=31577","url_meta":{"origin":28586,"position":5},"title":"\ubb34\uc911\ub2e8 Postgres \uc5c5\uadf8\ub808\uc774\ub4dc","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 12\uc6d4 14\uc77c","format":false,"excerpt":"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 \ubc29\uc548 \ubaa8\uc0c9: \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. \ub9ac\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":[]}],"_links":{"self":[{"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/28586","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=28586"}],"version-history":[{"count":1,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/28586\/revisions"}],"predecessor-version":[{"id":28587,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/28586\/revisions\/28587"}],"wp:attachment":[{"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=28586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=28586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=28586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}