{"id":108209,"date":"2025-05-09T09:01:25","date_gmt":"2025-05-09T05:31:25","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2\/"},"modified":"2025-05-09T09:01:25","modified_gmt":"2025-05-09T05:31:25","slug":"can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2\/","title":{"rendered":"\u0622\u06cc\u0627 PostgreSQL \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0645\u0648\u062a\u0648\u0631 \u062c\u0633\u062a\u062c\u0648 \u0628\u0627\u0634\u062f\u061f \u0628\u0644\u0647 \u060c \u0634\u0645\u0627 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0646\u06cc\u0627\u0632\u06cc \u0628\u0647 Elasticsearch \u0646\u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f"},"content":{"rendered":"<div data-article-id=\"2470291\" id=\"article-body\">\n<p><\/p>\n<p><strong>Leapcell: \u0628\u0647\u062a\u0631\u06cc\u0646 \u0645\u06cc\u0632\u0628\u0627\u0646\u06cc \u0648\u0628 \u0628\u062f\u0648\u0646 \u0633\u0631\u0648\u0631<\/strong><\/p>\n<p>\u0634\u0627\u062e\u0635 \u0645\u0639\u06a9\u0648\u0633 \u0627\u0632 \u0641\u0646\u0627\u0648\u0631\u06cc \u0645\u0648\u062a\u0648\u0631 \u062c\u0633\u062a\u062c\u0648 \u0633\u0631\u0686\u0634\u0645\u0647 \u0645\u06cc \u06af\u06cc\u0631\u062f \u0648 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0633\u0646\u06af \u0628\u0646\u0627\u06cc \u0645\u0648\u062a\u0648\u0631\u0647\u0627\u06cc \u062c\u0633\u062a\u062c\u0648 \u062f\u0631 \u0646\u0638\u0631 \u06af\u0631\u0641\u062a\u0647 \u0634\u0648\u062f. \u0628\u0627 \u062a\u0634\u06a9\u0631 \u0627\u0632 \u0641\u0646\u0627\u0648\u0631\u06cc \u0634\u0627\u062e\u0635 \u0645\u0639\u06a9\u0648\u0633 \u060c \u0645\u0648\u062a\u0648\u0631\u0647\u0627\u06cc \u062c\u0633\u062a\u062c\u0648 \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0647 \u0637\u0648\u0631 \u0645\u0624\u062b\u0631 \u0639\u0645\u0644\u06cc\u0627\u062a\u06cc \u0645\u0627\u0646\u0646\u062f \u062c\u0633\u062a\u062c\u0648\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0648 \u062d\u0630\u0641 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u0646\u062f. \u0642\u0628\u0644 \u0627\u0632 \u062a\u0648\u0636\u06cc\u062d \u062f\u0631 \u0641\u0647\u0631\u0633\u062a \u0645\u0639\u06a9\u0648\u0633 \u060c \u0627\u0628\u062a\u062f\u0627 \u0634\u0627\u062e\u0635 \u067e\u06cc\u0634 \u0631\u0648 \u0645\u0631\u0628\u0648\u0637 \u0631\u0627 \u0645\u0639\u0631\u0641\u06cc \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u0648 \u0627\u06cc\u0646 \u062f\u0648 \u0631\u0627 \u0628\u0627 \u0647\u0645 \u0645\u0642\u0627\u06cc\u0633\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2\/#%D8%B4%D8%A7%D8%AE%D8%B5_%D8%B1%D9%88_%D8%A8%D9%87_%D8%AC%D9%84%D9%88\" >\u0634\u0627\u062e\u0635 \u0631\u0648 \u0628\u0647 \u062c\u0644\u0648<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2\/#%D8%B4%D8%A7%D8%AE%D8%B5_%D9%85%D8%B9%DA%A9%D9%88%D8%B3\" >\u0634\u0627\u062e\u0635 \u0645\u0639\u06a9\u0648\u0633<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2\/#%D8%B4%D8%A7%D8%AE%D8%B5_%D8%AC%DB%8C%D9%86_%D8%AF%D8%B1_postgresql\" >\u0634\u0627\u062e\u0635 \u062c\u06cc\u0646 \u062f\u0631 postgresql<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2\/#%D9%86%D9%85%D8%A7%DB%8C_%DA%A9%D9%84%DB%8C\" >\u0646\u0645\u0627\u06cc \u06a9\u0644\u06cc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/nabfollower.com\/blog\/can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2\/#%D8%B3%D8%A7%D8%AE%D8%AA%D8%A7%D8%B1_%D8%B4%D8%A7%D8%AE%D8%B5_%D8%AC%DB%8C%D9%86\" >\u0633\u0627\u062e\u062a\u0627\u0631 \u0634\u0627\u062e\u0635 \u062c\u06cc\u0646<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nabfollower.com\/blog\/can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2\/#%D8%B3%D8%A7%D8%AE%D8%AA_%D9%81%DB%8C%D8%B2%DB%8C%DA%A9%DB%8C\" >\u0633\u0627\u062e\u062a \u0641\u06cc\u0632\u06cc\u06a9\u06cc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/nabfollower.com\/blog\/can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2\/#%D8%B3%D8%A7%D8%AE%D8%AA%D8%A7%D8%B1_%D9%85%D9%86%D8%B7%D9%82%DB%8C\" >\u0633\u0627\u062e\u062a\u0627\u0631 \u0645\u0646\u0637\u0642\u06cc<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/nabfollower.com\/blog\/can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2\/#%D8%A8%D8%A7%D8%B2%DB%8C%D8%A7%D8%A8%DB%8C_%D9%85%D8%AA%D9%86_%DA%A9%D8%A7%D9%85%D9%84\" >\u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0645\u062a\u0646 \u06a9\u0627\u0645\u0644<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/nabfollower.com\/blog\/can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2\/#%D9%85%D8%AB%D8%A7%D9%84\" >\u0645\u062b\u0627\u0644<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/nabfollower.com\/blog\/can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2\/#%D9%85%D8%B4%DA%A9%D9%84_%D8%B3%D8%B1%D8%B9%D8%AA_%D8%A8%D9%87_%D8%B1%D9%88%D8%B2%D8%B1%D8%B3%D8%A7%D9%86%DB%8C_%D8%A2%D9%87%D8%B3%D8%AA%D9%87\" >\u0645\u0634\u06a9\u0644 \u0633\u0631\u0639\u062a \u0628\u0647 \u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0622\u0647\u0633\u062a\u0647<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/nabfollower.com\/blog\/can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2\/#%D8%AC%D8%B3%D8%AA%D8%AC%D9%88%DB%8C_%D9%85%D8%B3%D8%A7%D8%A8%D9%82%D9%87_%D8%AC%D8%B2%D8%A6%DB%8C\" >\u062c\u0633\u062a\u062c\u0648\u06cc \u0645\u0633\u0627\u0628\u0642\u0647 \u062c\u0632\u0626\u06cc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/nabfollower.com\/blog\/can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2\/#%D9%81%D8%B1%D8%A7%D9%88%D8%A7%D9%86%DB%8C_%DA%A9%D9%84%D9%85%D8%A7%D8%AA_%DA%A9%D9%84%DB%8C%D8%AF%DB%8C\" >\u0641\u0631\u0627\u0648\u0627\u0646\u06cc \u06a9\u0644\u0645\u0627\u062a \u06a9\u0644\u06cc\u062f\u06cc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/nabfollower.com\/blog\/can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2\/#%D9%85%D8%AD%D8%AF%D9%88%D8%AF_%DA%A9%D8%B1%D8%AF%D9%86_%D9%86%D8%AA%D8%A7%DB%8C%D8%AC_%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88\" >\u0645\u062d\u062f\u0648\u062f \u06a9\u0631\u062f\u0646 \u0646\u062a\u0627\u06cc\u062c \u067e\u0631\u0633 \u0648 \u062c\u0648<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/nabfollower.com\/blog\/can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2\/#%D8%B1%D9%88%D8%B4_%D9%81%D8%B4%D8%B1%D8%AF%D9%87_%D8%B3%D8%A7%D8%B2%DB%8C\" >\u0631\u0648\u0634 \u0641\u0634\u0631\u062f\u0647 \u0633\u0627\u0632\u06cc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/nabfollower.com\/blog\/can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2\/#%F0%9F%9A%80_%D8%A8%D8%A7_%D8%B2%D8%A8%D8%A7%D9%86_%D9%85%D9%88%D8%B1%D8%AF_%D8%B9%D9%84%D8%A7%D9%82%D9%87_%D8%AE%D9%88%D8%AF_%D8%A8%D8%B3%D8%A7%D8%B2%DB%8C%D8%AF\" >\ud83d\ude80 \u0628\u0627 \u0632\u0628\u0627\u0646 \u0645\u0648\u0631\u062f \u0639\u0644\u0627\u0642\u0647 \u062e\u0648\u062f \u0628\u0633\u0627\u0632\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/nabfollower.com\/blog\/can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2\/#%F0%9F%8C%8D_%D9%BE%D8%B1%D9%88%DA%98%D9%87_%D9%87%D8%A7%DB%8C_%D9%86%D8%A7%D9%85%D8%AD%D8%AF%D9%88%D8%AF_%D8%B1%D8%A7_%D8%A8%D9%87_%D8%B5%D9%88%D8%B1%D8%AA_%D8%B1%D8%A7%DB%8C%DA%AF%D8%A7%D9%86_%D9%85%D8%B3%D8%AA%D9%82%D8%B1_%DA%A9%D9%86%DB%8C%D8%AF\" >\ud83c\udf0d \u067e\u0631\u0648\u0698\u0647 \u0647\u0627\u06cc \u0646\u0627\u0645\u062d\u062f\u0648\u062f \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0631\u0627\u06cc\u06af\u0627\u0646 \u0645\u0633\u062a\u0642\u0631 \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/nabfollower.com\/blog\/can-postgresql-be-a-search-engine-yes-you-might-not-need-elasticsearch-3bi2\/#%E2%9A%A1_%D9%BE%D8%B1%D8%AF%D8%A7%D8%AE%D8%AA_%D8%A8%D9%87_%D8%B9%D9%86%D9%88%D8%A7%D9%86_%D8%B4%D9%85%D8%A7_%D8%8C_%D8%A8%D8%AF%D9%88%D9%86_%D9%87%D8%B2%DB%8C%D9%86%D9%87_%D9%87%D8%A7%DB%8C_%D9%BE%D9%86%D9%87%D8%A7%D9%86\" >\u26a1 \u067e\u0631\u062f\u0627\u062e\u062a \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0634\u0645\u0627 \u060c \u0628\u062f\u0648\u0646 \u0647\u0632\u06cc\u0646\u0647 \u0647\u0627\u06cc \u067e\u0646\u0647\u0627\u0646<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D8%B4%D8%A7%D8%AE%D8%B5_%D8%B1%D9%88_%D8%A8%D9%87_%D8%AC%D9%84%D9%88\"><\/span>\n<p>  \u0634\u0627\u062e\u0635 \u0631\u0648 \u0628\u0647 \u062c\u0644\u0648<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062f\u0631 \u06cc\u06a9 \u0645\u0648\u062a\u0648\u0631 \u062c\u0633\u062a\u062c\u0648 \u060c \u062c\u062f\u0648\u0644 \u062c\u0644\u0648 \u0627\u0632 \u0634\u0646\u0627\u0633\u0647 \u0633\u0646\u062f \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06a9\u0644\u0645\u0647 \u06a9\u0644\u06cc\u062f\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f \u0648 \u062c\u062f\u0648\u0644 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0645\u0648\u0642\u0639\u06cc\u062a \u0647\u0631 \u06a9\u0644\u0645\u0647 \u0631\u0627 \u062f\u0631 \u0633\u0646\u062f \u062b\u0628\u062a \u0645\u06cc \u06a9\u0646\u062f. \u0647\u0646\u06af\u0627\u0645 \u062c\u0633\u062a\u062c\u0648 \u060c \u0633\u06cc\u0633\u062a\u0645 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u06a9\u0644\u0645\u0647 \u0631\u0627 \u062f\u0631 \u0647\u0631 \u0633\u0646\u062f \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u062c\u062f\u0648\u0644 \u0627\u0633\u06a9\u0646 \u0645\u06cc \u06a9\u0646\u062f \u062a\u0627 \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u062a\u0645\u0627\u0645 \u0627\u0633\u0646\u0627\u062f \u062d\u0627\u0648\u06cc \u06a9\u0644\u0645\u0647 \u06a9\u0644\u06cc\u062f\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648 \u067e\u06cc\u062f\u0627 \u0634\u0648\u062f.<\/p>\n<p>\u0633\u0627\u062e\u062a\u0627\u0631 \u062c\u062f\u0648\u0644 \u0631\u0648 \u0628\u0647 \u062c\u0644\u0648 \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0627 \u0646\u0645\u0648\u062f\u0627\u0631 \u062c\u0639\u0628\u0647 \u0632\u06cc\u0631 \u0646\u0634\u0627\u0646 \u062f\u0627\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>+---------------------+\n|     Forward Index Table      |\n+---------------------+\n|  Document ID  |  Position Information |\n+---------------------+\n|   Doc1   |  word1@3 |\n|          |  word2@7 |\n+---------------------+\n|   Doc2   |  word1@2 |\n|          |  word3@5 |\n+---------------------+\n|   Doc3   |  word2@4 |\n|          |  word4@6 |\n+---------------------+\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0631\u0648\u0634 \u0633\u0627\u0632\u0645\u0627\u0646 \u062f\u0631 \u0647\u0646\u06af\u0627\u0645 \u0633\u0627\u062e\u062a \u0634\u0627\u062e\u0635 \u0627\u0632 \u0633\u0627\u062e\u062a\u0627\u0631 \u0646\u0633\u0628\u062a\u0627\u064b \u0633\u0627\u062f\u0647 \u0627\u06cc \u0628\u0631\u062e\u0648\u0631\u062f\u0627\u0631 \u0627\u0633\u062a \u0648 \u0633\u0627\u062e\u062a \u0622\u0646 \u0631\u0627\u062d\u062a \u0627\u0633\u062a \u0648 \u0646\u06af\u0647\u062f\u0627\u0631\u06cc \u0622\u0646 \u0646\u06cc\u0632 \u0622\u0633\u0627\u0646 \u0627\u0633\u062a. \u0627\u0632 \u0622\u0646\u062c\u0627 \u06a9\u0647 \u0627\u06cc\u0646 \u0634\u0627\u062e\u0635 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0627\u0633\u0646\u0627\u062f \u0633\u0627\u062e\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u060c \u062f\u0631 \u0635\u0648\u0631\u062a \u0627\u0636\u0627\u0641\u0647 \u0634\u062f\u0646 \u06cc\u06a9 \u0633\u0646\u062f \u062c\u062f\u06cc\u062f \u060c \u0641\u0642\u0637 \u06cc\u06a9 \u0628\u0644\u0648\u06a9 \u0634\u0627\u062e\u0635 \u062c\u062f\u06cc\u062f \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0633\u0646\u062f \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u0634\u0648\u062f \u0648 \u0628\u0647 \u0627\u0646\u062a\u0647\u0627\u06cc \u067e\u0631\u0648\u0646\u062f\u0647 \u0641\u0647\u0631\u0633\u062a \u0627\u0635\u0644\u06cc \u067e\u06cc\u0648\u0633\u062a \u0645\u06cc \u0634\u0648\u062f. \u062f\u0631 \u0635\u0648\u0631\u062a \u062d\u0630\u0641 \u0633\u0646\u062f\u06cc \u060c \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0634\u0627\u062e\u0635 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0634\u0645\u0627\u0631\u0647 \u0633\u0646\u062f \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0645\u0633\u062a\u0642\u06cc\u0645\u0627\u064b \u067e\u06cc\u062f\u0627 \u0648 \u062d\u0630\u0641 \u06a9\u0631\u062f. \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644 \u060c \u062f\u0631 \u0647\u0646\u06af\u0627\u0645 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u060c \u0628\u0631\u0627\u06cc \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u0627\u0632 \u0639\u062f\u0645 \u0648\u062c\u0648\u062f \u062d\u0630\u0641 \u060c \u0628\u0627\u06cc\u062f \u062a\u0645\u0627\u0645 \u0627\u0633\u0646\u0627\u062f \u0627\u0633\u06a9\u0646 \u0634\u0648\u0646\u062f \u060c \u06a9\u0647 \u0628\u0627\u0639\u062b \u0627\u0641\u0632\u0627\u06cc\u0634 \u0632\u0645\u0627\u0646 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0645\u06cc \u0634\u0648\u062f \u0648 \u0645\u0646\u062c\u0631 \u0628\u0647 \u0628\u0627\u0632\u062f\u0647 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u06a9\u0645 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<p>\u0627\u06af\u0631\u0686\u0647 \u0627\u0635\u0644 \u06a9\u0627\u0631 \u062c\u062f\u0648\u0644 \u0631\u0648 \u0628\u0647 \u062c\u0644\u0648 \u0628\u0633\u06cc\u0627\u0631 \u0633\u0627\u062f\u0647 \u0627\u0633\u062a \u060c \u0627\u0645\u0627 \u0631\u0627\u0646\u062f\u0645\u0627\u0646 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0622\u0646 \u0628\u0633\u06cc\u0627\u0631 \u06a9\u0645 \u0627\u0633\u062a \u0648 \u0627\u0631\u0632\u0634 \u0639\u0645\u0644\u06cc \u06a9\u0645\u06cc \u062f\u0627\u0631\u062f \u0645\u06af\u0631 \u0627\u06cc\u0646\u06a9\u0647 \u062f\u0631 \u0645\u0648\u0642\u0639\u06cc\u062a \u0647\u0627\u06cc \u062e\u0627\u0635 \u0628\u0627\u0634\u062f.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D8%B4%D8%A7%D8%AE%D8%B5_%D9%85%D8%B9%DA%A9%D9%88%D8%B3\"><\/span>\n<p>  \u0634\u0627\u062e\u0635 \u0645\u0639\u06a9\u0648\u0633<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062c\u062f\u0648\u0644 \u0645\u0639\u06a9\u0648\u0633 \u0627\u0632 \u06a9\u0644\u0645\u0627\u062a \u06cc\u0627 \u0627\u0635\u0637\u0644\u0627\u062d\u0627\u062a \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06a9\u0644\u0645\u0627\u062a \u06a9\u0644\u06cc\u062f\u06cc \u0628\u0631\u0627\u06cc \u0646\u0645\u0627\u06cc\u0647 \u0633\u0627\u0632\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f \u060c \u0648 \u0648\u0631\u0648\u062f\u06cc \u0647\u0627\u06cc \u0636\u0628\u0637 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u06a9\u0644\u0645\u0627\u062a \u06a9\u0644\u06cc\u062f\u06cc \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u062c\u062f\u0648\u0644 \u060c \u062a\u0645\u0627\u0645 \u0627\u0633\u0646\u0627\u062f\u06cc \u0631\u0627 \u06a9\u0647 \u0627\u06cc\u0646 \u06a9\u0644\u0645\u0647 \u06cc\u0627 \u0627\u0635\u0637\u0644\u0627\u062d \u062f\u0631 \u0622\u0646 \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f \u060c \u0636\u0628\u0637 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p>\u0633\u0627\u062e\u062a\u0627\u0631 \u062c\u062f\u0648\u0644 \u0645\u0639\u06a9\u0648\u0633 \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0627 \u0646\u0645\u0648\u062f\u0627\u0631 \u062c\u0639\u0628\u0647 \u0632\u06cc\u0631 \u0646\u0634\u0627\u0646 \u062f\u0627\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>+---------------------+\n|     Inverted Index Table      |\n+---------------------+\n|  Keyword   |  Document List |\n+---------------------+\n|  word1    |  Doc1,Doc2 |\n+---------------------+\n|  word2    |  Doc1,Doc3 |\n+---------------------+\n|  word3    |  Doc2      |\n+---------------------+\n|  word4    |  Doc3      |\n+---------------------+\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u0632 \u0622\u0646\u062c\u0627 \u06a9\u0647 \u062a\u0639\u062f\u0627\u062f \u0627\u0633\u0646\u0627\u062f \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0647\u0631 \u06a9\u0644\u0645\u0647 \u06cc\u0627 \u0627\u0635\u0637\u0644\u0627\u062d \u0628\u0647 \u0635\u0648\u0631\u062a \u067e\u0648\u06cc\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u0645\u06cc \u06a9\u0646\u062f \u060c \u0627\u06cc\u062c\u0627\u062f \u0648 \u0646\u06af\u0647\u062f\u0627\u0631\u06cc \u0627\u0632 \u062c\u062f\u0648\u0644 \u0645\u0639\u06a9\u0648\u0633 \u0646\u0633\u0628\u062a\u0627\u064b \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0627\u0633\u062a. \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644 \u060c \u0647\u0646\u06af\u0627\u0645 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u060c \u0627\u0632 \u0622\u0646\u062c\u0627 \u06a9\u0647 \u062a\u0645\u0627\u0645 \u0627\u0633\u0646\u0627\u062f \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u06a9\u0644\u0645\u0647 \u06a9\u0644\u06cc\u062f\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0647 \u0637\u0648\u0631 \u0647\u0645 \u0632\u0645\u0627\u0646 \u0628\u062f\u0633\u062a \u0622\u0648\u0631\u0646\u062f \u060c \u0631\u0627\u0646\u062f\u0645\u0627\u0646 \u0628\u0627\u0644\u0627\u062a\u0631 \u0627\u0632 \u062c\u062f\u0648\u0644 \u062c\u0644\u0648 \u0627\u0633\u062a. \u062f\u0631 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u06a9\u0627\u0645\u0644 \u0645\u062a\u0646 \u060c \u067e\u0627\u0633\u062e \u0633\u0631\u06cc\u0639 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u06cc\u06a9 \u0639\u0645\u0644\u06a9\u0631\u062f \u0645\u0647\u0645 \u0627\u0633\u062a. \u0627\u06af\u0631\u0686\u0647 \u062a\u0623\u0633\u06cc\u0633 \u0634\u0627\u062e\u0635 \u0646\u0633\u0628\u062a\u0627\u064b \u06a9\u0646\u062f \u0627\u0633\u062a \u0632\u06cc\u0631\u0627 \u062f\u0631 \u067e\u0633 \u0632\u0645\u06cc\u0646\u0647 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u0634\u0648\u062f \u060c \u0627\u0645\u0627 \u0628\u0631 \u06a9\u0627\u0631\u0622\u06cc\u06cc \u06a9\u0644 \u0645\u0648\u062a\u0648\u0631 \u062c\u0633\u062a\u062c\u0648 \u062a\u0623\u062b\u06cc\u0631 \u0646\u0645\u06cc \u06af\u0630\u0627\u0631\u062f.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D8%B4%D8%A7%D8%AE%D8%B5_%D8%AC%DB%8C%D9%86_%D8%AF%D8%B1_postgresql\"><\/span>\n<p>  \u0634\u0627\u062e\u0635 \u062c\u06cc\u0646 \u062f\u0631 postgresql<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"%D9%86%D9%85%D8%A7%DB%8C_%DA%A9%D9%84%DB%8C\"><\/span>\n<p>  \u0646\u0645\u0627\u06cc \u06a9\u0644\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u062c\u06cc\u0646 \u0645\u062e\u0641\u0641 \u0634\u0627\u062e\u0635 \u0645\u0639\u06a9\u0648\u0633 \u062a\u0639\u0645\u06cc\u0645 \u06cc\u0627\u0641\u062a\u0647 \u060c \u06cc\u0639\u0646\u06cc \u0634\u0627\u062e\u0635 \u0628\u0647 \u0627\u0635\u0637\u0644\u0627\u062d \u0645\u0639\u06a9\u0648\u0633 \u0627\u0633\u062a. \u0645\u0642\u0627\u062f\u06cc\u0631 \u0627\u0646\u0648\u0627\u0639 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0641\u0631\u0622\u06cc\u0646\u062f \u0622\u0646 \u0627\u0633\u062a \u0627\u062a\u0645\u06cc \u0646\u06cc\u0633\u062a \u0628\u0644\u06a9\u0647 \u0627\u0632 \u0639\u0646\u0627\u0635\u0631\u06cc \u062a\u0634\u06a9\u06cc\u0644 \u0634\u062f\u0647 \u0627\u0633\u062a \u06a9\u0647 \u0645\u0627 \u0622\u0646 \u0631\u0627 \u0627\u0646\u0648\u0627\u0639 \u06a9\u0627\u0645\u067e\u0648\u0632\u06cc\u062a \u0645\u06cc \u0646\u0627\u0645\u06cc\u0645. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644 \u060c \u062f\u0631 (<code>hank<\/code>\u0628\u0627 <code>15:3 21:4<\/code>) \u060c \u0627\u06cc\u0646 \u0628\u062f\u0627\u0646 \u0645\u0639\u0646\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0647\u0646\u06a9 \u062f\u0631 \u0645\u0648\u0642\u0639\u06cc\u062a \u0647\u0627\u06cc 15: 3 \u0648 21: 4 \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f. \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0628\u0647 \u0645\u0627 \u06a9\u0645\u06a9 \u0645\u06cc \u06a9\u0646\u062f \u062a\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0646\u0645\u0648\u0646\u0647 \u0647\u0627\u06cc \u062e\u0627\u0635 \u060c \u062f\u0631\u06a9 \u0648\u0627\u0636\u062d \u062a\u0631\u06cc \u0627\u0632 \u0634\u0627\u062e\u0635 \u062c\u06cc\u0646 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D8%B3%D8%A7%D8%AE%D8%AA%D8%A7%D8%B1_%D8%B4%D8%A7%D8%AE%D8%B5_%D8%AC%DB%8C%D9%86\"><\/span>\n<p>  \u0633\u0627\u062e\u062a\u0627\u0631 \u0634\u0627\u062e\u0635 \u062c\u06cc\u0646<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"%D8%B3%D8%A7%D8%AE%D8%AA_%D9%81%DB%8C%D8%B2%DB%8C%DA%A9%DB%8C\"><\/span>\n<p>  \u0633\u0627\u062e\u062a \u0641\u06cc\u0632\u06cc\u06a9\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0630\u062e\u06cc\u0631\u0647 \u0641\u06cc\u0632\u06cc\u06a9\u06cc \u0634\u0627\u062e\u0635 \u062c\u06cc\u0646 \u062d\u0627\u0648\u06cc \u0645\u062d\u062a\u0648\u0627\u06cc \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n<ol>\n<li>\u0648\u0631\u0648\u062f: \u06cc\u06a9 \u0639\u0646\u0635\u0631 \u062f\u0631 \u0634\u0627\u062e\u0635 \u062c\u06cc\u0646 \u060c \u06a9\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0645\u0648\u0642\u0639\u06cc\u062a \u06a9\u0644\u0645\u0647 \u062f\u0631 \u0646\u0638\u0631 \u06af\u0631\u0641\u062a\u0647 \u0634\u0648\u062f \u0648 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u06a9\u0644\u06cc\u062f \u062f\u0631\u06a9 \u0634\u0648\u062f.<\/li>\n<li>\u062f\u0631\u062e\u062a \u0648\u0631\u0648\u062f\u06cc: \u06cc\u06a9 \u062f\u0631\u062e\u062a B \u0633\u0627\u062e\u062a\u0647 \u0634\u062f\u0647 \u062f\u0631 \u0648\u0631\u0648\u062f\u06cc.<\/li>\n<li>\u0644\u06cc\u0633\u062a \u0627\u0631\u0633\u0627\u0644: \u0644\u06cc\u0633\u062a\u06cc \u0627\u0632 \u0645\u0648\u0642\u0639\u06cc\u062a \u0647\u0627\u06cc \u0641\u06cc\u0632\u06cc\u06a9\u06cc (Heap CTID \u060c \u0634\u0645\u0627\u0631\u0647 \u0631\u062f\u06cc\u0641 \u062c\u062f\u0648\u0644 \u062c\u062f\u0648\u0644) \u06a9\u0647 \u062f\u0631 \u0622\u0646 \u06cc\u06a9 \u0648\u0631\u0648\u062f\u06cc \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f.<\/li>\n<li>\u0627\u0631\u0633\u0627\u0644 \u062f\u0631\u062e\u062a: \u06cc\u06a9 \u062f\u0631\u062e\u062a B \u0633\u0627\u062e\u062a\u0647 \u0634\u062f\u0647 \u062f\u0631 \u0644\u06cc\u0633\u062a \u0645\u0631\u062a\u0628\u0637 \u0628\u0627 \u0645\u0648\u0642\u0639\u06cc\u062a \u0647\u0627\u06cc \u0641\u06cc\u0632\u06cc\u06a9\u06cc (Heap CTID \u060c \u0634\u0645\u0627\u0631\u0647 \u0631\u062f\u06cc\u0641 \u062c\u062f\u0648\u0644 \u062c\u062f\u0648\u0644) \u06a9\u0647 \u062f\u0631 \u0622\u0646 \u06cc\u06a9 \u0648\u0631\u0648\u062f\u06cc \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f. \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u06a9\u0644\u06cc\u062f \u062f\u0631\u062e\u062a \u0627\u0631\u0633\u0627\u0644 CTID \u0627\u0633\u062a \u0648 \u06a9\u0644\u06cc\u062f \u062f\u0631\u062e\u062a \u0648\u0631\u0648\u062f\u06cc \u0645\u0642\u062f\u0627\u0631 \u0633\u062a\u0648\u0646 \u0641\u0647\u0631\u0633\u062a \u0628\u0646\u062f\u06cc \u0634\u062f\u0647 \u0627\u0633\u062a.<\/li>\n<li>\u0644\u06cc\u0633\u062a \u062f\u0631 \u0627\u0646\u062a\u0638\u0627\u0631: \u06cc\u06a9 \u0644\u06cc\u0633\u062a \u0645\u0631\u062a\u0628\u0637 \u0628\u0627 \u0630\u062e\u06cc\u0631\u0647 \u0645\u0648\u0642\u062a \u0627\u0632 \u062a\u0648\u067e\u0644 \u0647\u0627\u06cc \u0634\u0627\u062e\u0635 \u060c \u06a9\u0647 \u0628\u0631\u0627\u06cc \u0639\u0645\u0644\u06cc\u0627\u062a \u062f\u0631\u062c \u062f\u0631 \u062d\u0627\u0644\u062a FastUpdate \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/li>\n<\/ol>\n<p>\u0627\u0632 \u0645\u0648\u0627\u0631\u062f \u0641\u0648\u0642 \u0645\u06cc \u062a\u0648\u0627\u0646 \u062f\u0631\u06cc\u0627\u0641\u062a \u06a9\u0647 \u0634\u0627\u062e\u0635 \u062c\u06cc\u0646 \u0639\u0645\u062f\u062a\u0627\u064b \u0627\u0632 \u062f\u0631\u062e\u062a \u0648\u0631\u0648\u062f\u06cc \u0648 \u062f\u0631\u062e\u062a \u0627\u0631\u0633\u0627\u0644 (\u06cc\u0627 \u0644\u06cc\u0633\u062a \u0627\u0631\u0633\u0627\u0644) \u062a\u0634\u06a9\u06cc\u0644 \u0634\u062f\u0647 \u0627\u0633\u062a \u060c \u062c\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0631\u062e\u062a \u0648\u0631\u0648\u062f\u06cc \u062f\u0631\u062e\u062a \u0633\u0627\u062e\u062a\u0627\u0631 \u0627\u0635\u0644\u06cc \u0634\u0627\u062e\u0635 \u062c\u06cc\u0646 \u0627\u0633\u062a \u0648 \u062f\u0631\u062e\u062a \u0627\u0631\u0633\u0627\u0644 \u062f\u0631\u062e\u062a \u06a9\u0645\u06a9\u06cc \u0627\u0633\u062a.<\/p>\n<p>\u062f\u0631\u062e\u062a \u0648\u0631\u0648\u062f \u0634\u0628\u06cc\u0647 \u0628\u0647 \u062f\u0631\u062e\u062a B+\u0627\u0633\u062a \u0648 \u062f\u0631\u062e\u062a \u0627\u0631\u0633\u0627\u0644 \u0634\u0628\u06cc\u0647 \u0628\u0647 \u062f\u0631\u062e\u062a B \u0627\u0633\u062a.<\/p>\n<p>\u0639\u0644\u0627\u0648\u0647 \u0628\u0631 \u0627\u06cc\u0646 \u060c \u0647\u0645 \u062f\u0631\u062e\u062a \u0648\u0631\u0648\u062f\u06cc \u0648 \u0647\u0645 \u062f\u0631\u062e\u062a \u0627\u0631\u0633\u0627\u0644 \u0628\u0647 \u0635\u0648\u0631\u062a \u0645\u0646\u0638\u0645 \u0628\u0627 \u062a\u0648\u062c\u0647 \u0628\u0647 \u06a9\u0644\u06cc\u062f \u0633\u0627\u0632\u0645\u0627\u0646\u062f\u0647\u06cc \u0645\u06cc \u0634\u0648\u0646\u062f.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"%D8%B3%D8%A7%D8%AE%D8%AA%D8%A7%D8%B1_%D9%85%D9%86%D8%B7%D9%82%DB%8C\"><\/span>\n<p>  \u0633\u0627\u062e\u062a\u0627\u0631 \u0645\u0646\u0637\u0642\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0627\u0632 \u0646\u0638\u0631 \u0645\u0646\u0637\u0642\u06cc \u060c \u0634\u0627\u062e\u0635 \u062c\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0631\u0627\u0628\u0637\u0647 \u062f\u0631 \u0646\u0638\u0631 \u06af\u0631\u0641\u062a\u0647 \u0634\u0648\u062f \u060c \u0648 \u0627\u06cc\u0646 \u0631\u0627\u0628\u0637\u0647 \u062f\u0627\u0631\u0627\u06cc \u062f\u0648 \u0633\u0627\u062e\u062a\u0627\u0631 \u0627\u0633\u062a:<\/p>\n<p>\u0646\u0645\u0627\u06cc\u0647 \u06a9\u0631\u062f\u0646 \u0641\u0642\u0637 \u06cc\u06a9 \u0633\u062a\u0648\u0646 \u0627\u0632 \u062c\u062f\u0648\u0644 \u067e\u0627\u06cc\u0647<br \/>| \u06a9\u0644\u06cc\u062f | \u0627\u0631\u0632\u0634 |<br \/>| &#8212;&#8211; | &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; |<br \/>| key1 | \u0644\u06cc\u0633\u062a \u0627\u0631\u0633\u0627\u0644 (\u06cc\u0627 \u0627\u0631\u0633\u0627\u0644 \u062f\u0631\u062e\u062a) |<br \/>| key2 | \u0644\u06cc\u0633\u062a \u0627\u0631\u0633\u0627\u0644 (\u06cc\u0627 \u0627\u0631\u0633\u0627\u0644 \u062f\u0631\u062e\u062a) |<br \/>| \u2026 | \u2026 |<\/p>\n<p>\u0646\u0645\u0627\u06cc\u0647 \u0633\u0627\u0632\u06cc \u0686\u0646\u062f\u06cc\u0646 \u0633\u062a\u0648\u0646 \u0627\u0632 \u062c\u062f\u0648\u0644 \u067e\u0627\u06cc\u0647 (\u06a9\u0627\u0645\u067e\u0648\u0632\u06cc\u062a \u060c \u0634\u0627\u062e\u0635 \u0686\u0646\u062f \u0633\u062a\u0648\u0646\u06cc)<br \/>| column_id | \u06a9\u0644\u06cc\u062f | \u0627\u0631\u0632\u0634 |<br \/>| &#8212;&#8212;&#8212;&#8211; | &#8212;&#8211; | &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;- |<br \/>| \u0633\u062a\u0648\u0646 1 \u0634\u0645\u0627\u0631\u0647 | key1 | \u0644\u06cc\u0633\u062a \u0627\u0631\u0633\u0627\u0644 (\u06cc\u0627 \u0627\u0631\u0633\u0627\u0644 \u062f\u0631\u062e\u062a) |<br \/>| \u0633\u062a\u0648\u0646 2 \u0634\u0645\u0627\u0631\u0647 | key1 | \u0644\u06cc\u0633\u062a \u0627\u0631\u0633\u0627\u0644 (\u06cc\u0627 \u0627\u0631\u0633\u0627\u0644 \u062f\u0631\u062e\u062a) |<br \/>| \u0633\u062a\u0648\u0646 3 \u0634\u0645\u0627\u0631\u0647 | key1 | \u0644\u06cc\u0633\u062a \u0627\u0631\u0633\u0627\u0644 (\u06cc\u0627 \u0627\u0631\u0633\u0627\u0644 \u062f\u0631\u062e\u062a) |<br \/>| \u2026 | \u2026 | \u2026 |<\/p>\n<p>\u0627\u0632 \u0627\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0645\u0634\u0627\u0647\u062f\u0647 \u06a9\u0631\u062f \u06a9\u0647 \u062f\u0631 \u0632\u06cc\u0631 \u0627\u06cc\u0646 \u0633\u0627\u062e\u062a\u0627\u0631 \u060c \u0628\u0631\u0627\u06cc \u0647\u0645\u0627\u0646 \u06a9\u0644\u06cc\u062f \u062f\u0631 \u0633\u062a\u0648\u0646 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u062c\u062f\u0648\u0644 \u067e\u0627\u06cc\u0647 \u060c \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u06a9\u0644\u06cc\u062f \u0645\u062a\u0641\u0627\u0648\u062a \u062f\u0631 \u0634\u0627\u062e\u0635 \u062c\u06cc\u0646 \u0646\u06cc\u0632 \u062f\u0631\u0645\u0627\u0646 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D8%A8%D8%A7%D8%B2%DB%8C%D8%A7%D8%A8%DB%8C_%D9%85%D8%AA%D9%86_%DA%A9%D8%A7%D9%85%D9%84\"><\/span>\n<p>  \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0645\u062a\u0646 \u06a9\u0627\u0645\u0644<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0642\u0633\u0645\u062a \u0627\u0635\u0644\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u062c\u06cc\u0646 \u062a\u0633\u0631\u06cc\u0639 \u062f\u0631 \u062c\u0633\u062a\u062c\u0648\u06cc \u0645\u062a\u0646 \u06a9\u0627\u0645\u0644 \u0627\u0633\u062a. \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u060c \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0645\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0646\u0645\u0648\u0646\u0647 \u0627\u06cc \u0627\u0632 \u062c\u0633\u062a\u062c\u0648\u06cc \u0645\u062a\u0646 \u06a9\u0627\u0645\u0644 \u060c \u0634\u0627\u062e\u0635 \u062c\u06cc\u0646 \u0631\u0627 \u0645\u0639\u0631\u0641\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f.<\/p>\n<p>\u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f \u060c \u0648 doc_tsv \u0627\u0632 \u0646\u0648\u0639 \u062c\u0633\u062a\u062c\u0648\u06cc \u0645\u062a\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0639\u0646\u0627\u0635\u0631 \u062a\u06a9\u0631\u0627\u0631\u06cc \u0631\u0627 \u0645\u0631\u062a\u0628 \u0648 \u0627\u0632 \u0628\u06cc\u0646 \u0628\u0628\u0631\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"n\">pg_study<\/span><span class=\"o\">=#<\/span> <span class=\"k\">create<\/span> <span class=\"k\">table<\/span> <span class=\"n\">ts<\/span><span class=\"p\">(<\/span><span class=\"n\">doc<\/span> <span class=\"nb\">text<\/span><span class=\"p\">,<\/span> <span class=\"n\">doc_tsv<\/span> <span class=\"n\">tsvector<\/span><span class=\"p\">);<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span>\n\n<span class=\"n\">pg_study<\/span><span class=\"o\">=#<\/span> <span class=\"k\">insert<\/span> <span class=\"k\">into<\/span> <span class=\"n\">ts<\/span><span class=\"p\">(<\/span><span class=\"n\">doc<\/span><span class=\"p\">)<\/span> <span class=\"k\">values<\/span>\n  <span class=\"p\">(<\/span><span class=\"s1\">'Can a sheet slitter slit sheets?'<\/span><span class=\"p\">),<\/span> \n  <span class=\"p\">(<\/span><span class=\"s1\">'How many sheets could a sheet slitter slit?'<\/span><span class=\"p\">),<\/span>\n  <span class=\"p\">(<\/span><span class=\"s1\">'I slit a sheet, a sheet I slit.'<\/span><span class=\"p\">),<\/span>\n  <span class=\"p\">(<\/span><span class=\"s1\">'Upon a slitted sheet I sit.'<\/span><span class=\"p\">),<\/span> \n  <span class=\"p\">(<\/span><span class=\"s1\">'Whoever slit the sheets is a good sheet slitter.'<\/span><span class=\"p\">),<\/span> \n  <span class=\"p\">(<\/span><span class=\"s1\">'I am a sheet slitter.'<\/span><span class=\"p\">),<\/span>\n  <span class=\"p\">(<\/span><span class=\"s1\">'I slit sheets.'<\/span><span class=\"p\">),<\/span>\n  <span class=\"p\">(<\/span><span class=\"s1\">'I am the sleekest sheet slitter that ever slit sheets.'<\/span><span class=\"p\">),<\/span>\n  <span class=\"p\">(<\/span><span class=\"s1\">'She slits the sheet she sits on.'<\/span><span class=\"p\">);<\/span>\n<span class=\"k\">INSERT<\/span> <span class=\"mi\">0<\/span> <span class=\"mi\">9<\/span>\n\n<span class=\"n\">pg_study<\/span><span class=\"o\">=#<\/span> <span class=\"k\">update<\/span> <span class=\"n\">ts<\/span> <span class=\"k\">set<\/span> <span class=\"n\">doc_tsv<\/span> <span class=\"o\">=<\/span> <span class=\"n\">to_tsvector<\/span><span class=\"p\">(<\/span><span class=\"n\">doc<\/span><span class=\"p\">);<\/span>\n<span class=\"k\">UPDATE<\/span> <span class=\"mi\">9<\/span>\n\n<span class=\"n\">pg_study<\/span><span class=\"o\">=#<\/span> <span class=\"k\">create<\/span> <span class=\"k\">index<\/span> <span class=\"k\">on<\/span> <span class=\"n\">ts<\/span> <span class=\"k\">using<\/span> <span class=\"n\">gin<\/span><span class=\"p\">(<\/span><span class=\"n\">doc_tsv<\/span><span class=\"p\">);<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">INDEX<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0633\u0627\u062e\u062a\u0627\u0631 \u0627\u06cc\u0646 \u0634\u0627\u062e\u0635 \u062c\u06cc\u0646 \u0628\u0647 \u0634\u0631\u062d \u0632\u06cc\u0631 \u0627\u0633\u062a. \u0645\u0631\u0628\u0639 \u0647\u0627\u06cc \u0633\u06cc\u0627\u0647 \u0634\u0645\u0627\u0631\u0647 \u0647\u0627\u06cc \u0645\u0631\u062a\u0628 \u0647\u0633\u062a\u0646\u062f \u0648 \u0633\u0641\u06cc\u062f\u06cc \u06a9\u0644\u0645\u0627\u062a \u0647\u0633\u062a\u0646\u062f. \u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 \u0627\u06cc\u0646 \u06cc\u06a9 \u0644\u06cc\u0633\u062a \u062a\u06a9 \u0645\u0631\u062a\u0628\u0637 \u0627\u0633\u062a \u060c \u06a9\u0647 \u0628\u0627 \u0644\u06cc\u0633\u062a \u0645\u0636\u0627\u0639\u0641 B-Tree \u0645\u062a\u0641\u0627\u0648\u062a \u0627\u0633\u062a:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>+--------+     +--------+     +--------+\n|  sheet |----&gt;|  slit  |----&gt;| slitter|\n+--------+     +--------+     +--------+\n   |             |             |\n   v             v             v\n+--------+   +--------+   +--------+\n| (0,10) |   | (0,10) |   | (0,10) |\n+--------+   +--------+   +--------+\n   |             |             |\n   v             v             v\n+--------+   +--------+   +--------+\n| (0,11) |   | (0,11) |   | (0,11) |\n+--------+   +--------+   +--------+\n   |             |             |\n   v             v             v\n   ...           ...           ...\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0628\u06cc\u0627\u06cc\u06cc\u062f \u0628\u0647 \u0645\u062b\u0627\u0644 \u062f\u06cc\u06af\u0631\u06cc \u0646\u06af\u0627\u0647 \u06a9\u0646\u06cc\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"n\">pg_study<\/span><span class=\"o\">=#<\/span> <span class=\"k\">select<\/span> <span class=\"n\">ctid<\/span><span class=\"p\">,<\/span><span class=\"n\">doc<\/span><span class=\"p\">,<\/span> <span class=\"n\">doc_tsv<\/span> <span class=\"k\">from<\/span> <span class=\"n\">ts<\/span><span class=\"p\">;<\/span>\n  <span class=\"n\">ctid<\/span>  <span class=\"o\">|<\/span>                          <span class=\"n\">doc<\/span>                           <span class=\"o\">|<\/span>                         <span class=\"n\">doc_tsv<\/span>\n<span class=\"c1\">--------+--------------------------------------------------------+---------------------------------------------------------<\/span>\n <span class=\"p\">(<\/span><span class=\"mi\">0<\/span><span class=\"p\">,<\/span><span class=\"mi\">10<\/span><span class=\"p\">)<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Can<\/span> <span class=\"n\">a<\/span> <span class=\"n\">sheet<\/span> <span class=\"n\">slitter<\/span> <span class=\"n\">slit<\/span> <span class=\"n\">sheets<\/span><span class=\"o\">?<\/span>                       <span class=\"o\">|<\/span> <span class=\"s1\">'sheet'<\/span><span class=\"p\">:<\/span><span class=\"mi\">3<\/span><span class=\"p\">,<\/span><span class=\"mi\">6<\/span> <span class=\"s1\">'slit'<\/span><span class=\"p\">:<\/span><span class=\"mi\">5<\/span> <span class=\"s1\">'slitter'<\/span><span class=\"p\">:<\/span><span class=\"mi\">4<\/span>\n <span class=\"p\">(<\/span><span class=\"mi\">0<\/span><span class=\"p\">,<\/span><span class=\"mi\">11<\/span><span class=\"p\">)<\/span> <span class=\"o\">|<\/span> <span class=\"n\">How<\/span> <span class=\"n\">many<\/span> <span class=\"n\">sheets<\/span> <span class=\"n\">could<\/span> <span class=\"n\">a<\/span> <span class=\"n\">sheet<\/span> <span class=\"n\">slitter<\/span> <span class=\"n\">slit<\/span><span class=\"o\">?<\/span>            <span class=\"o\">|<\/span> <span class=\"s1\">'could'<\/span><span class=\"p\">:<\/span><span class=\"mi\">4<\/span> <span class=\"s1\">'mani'<\/span><span class=\"p\">:<\/span><span class=\"mi\">2<\/span> <span class=\"s1\">'sheet'<\/span><span class=\"p\">:<\/span><span class=\"mi\">3<\/span><span class=\"p\">,<\/span><span class=\"mi\">6<\/span> <span class=\"s1\">'slit'<\/span><span class=\"p\">:<\/span><span class=\"mi\">8<\/span> <span class=\"s1\">'slitter'<\/span><span class=\"p\">:<\/span><span class=\"mi\">7<\/span>\n <span class=\"p\">(<\/span><span class=\"mi\">0<\/span><span class=\"p\">,<\/span><span class=\"mi\">12<\/span><span class=\"p\">)<\/span> <span class=\"o\">|<\/span> <span class=\"n\">I<\/span> <span class=\"n\">slit<\/span> <span class=\"n\">a<\/span> <span class=\"n\">sheet<\/span><span class=\"p\">,<\/span> <span class=\"n\">a<\/span> <span class=\"n\">sheet<\/span> <span class=\"n\">I<\/span> <span class=\"n\">slit<\/span><span class=\"p\">.<\/span>                        <span class=\"o\">|<\/span> <span class=\"s1\">'sheet'<\/span><span class=\"p\">:<\/span><span class=\"mi\">4<\/span><span class=\"p\">,<\/span><span class=\"mi\">6<\/span> <span class=\"s1\">'slit'<\/span><span class=\"p\">:<\/span><span class=\"mi\">2<\/span><span class=\"p\">,<\/span><span class=\"mi\">8<\/span>\n <span class=\"p\">(<\/span><span class=\"mi\">0<\/span><span class=\"p\">,<\/span><span class=\"mi\">13<\/span><span class=\"p\">)<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Upon<\/span> <span class=\"n\">a<\/span> <span class=\"n\">slitted<\/span> <span class=\"n\">sheet<\/span> <span class=\"n\">I<\/span> <span class=\"n\">sit<\/span><span class=\"p\">.<\/span>                            <span class=\"o\">|<\/span> <span class=\"s1\">'sheet'<\/span><span class=\"p\">:<\/span><span class=\"mi\">4<\/span> <span class=\"s1\">'sit'<\/span><span class=\"p\">:<\/span><span class=\"mi\">6<\/span> <span class=\"s1\">'slit'<\/span><span class=\"p\">:<\/span><span class=\"mi\">3<\/span> <span class=\"s1\">'upon'<\/span><span class=\"p\">:<\/span><span class=\"mi\">1<\/span>\n <span class=\"p\">(<\/span><span class=\"mi\">0<\/span><span class=\"p\">,<\/span><span class=\"mi\">14<\/span><span class=\"p\">)<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Whoever<\/span> <span class=\"n\">slit<\/span> <span class=\"n\">the<\/span> <span class=\"n\">sheets<\/span> <span class=\"k\">is<\/span> <span class=\"n\">a<\/span> <span class=\"n\">good<\/span> <span class=\"n\">sheet<\/span> <span class=\"n\">slitter<\/span><span class=\"p\">.<\/span>       <span class=\"o\">|<\/span> <span class=\"s1\">'good'<\/span><span class=\"p\">:<\/span><span class=\"mi\">7<\/span> <span class=\"s1\">'sheet'<\/span><span class=\"p\">:<\/span><span class=\"mi\">4<\/span><span class=\"p\">,<\/span><span class=\"mi\">8<\/span> <span class=\"s1\">'slit'<\/span><span class=\"p\">:<\/span><span class=\"mi\">2<\/span> <span class=\"s1\">'slitter'<\/span><span class=\"p\">:<\/span><span class=\"mi\">9<\/span> <span class=\"s1\">'whoever'<\/span><span class=\"p\">:<\/span><span class=\"mi\">1<\/span>\n <span class=\"p\">(<\/span><span class=\"mi\">0<\/span><span class=\"p\">,<\/span><span class=\"mi\">15<\/span><span class=\"p\">)<\/span> <span class=\"o\">|<\/span> <span class=\"n\">I<\/span> <span class=\"n\">am<\/span> <span class=\"n\">a<\/span> <span class=\"n\">sheet<\/span> <span class=\"n\">slitter<\/span><span class=\"p\">.<\/span>                                  <span class=\"o\">|<\/span> <span class=\"s1\">'sheet'<\/span><span class=\"p\">:<\/span><span class=\"mi\">4<\/span> <span class=\"s1\">'slitter'<\/span><span class=\"p\">:<\/span><span class=\"mi\">5<\/span>\n <span class=\"p\">(<\/span><span class=\"mi\">0<\/span><span class=\"p\">,<\/span><span class=\"mi\">16<\/span><span class=\"p\">)<\/span> <span class=\"o\">|<\/span> <span class=\"n\">I<\/span> <span class=\"n\">slit<\/span> <span class=\"n\">sheets<\/span><span class=\"p\">.<\/span>                                         <span class=\"o\">|<\/span> <span class=\"s1\">'sheet'<\/span><span class=\"p\">:<\/span><span class=\"mi\">3<\/span> <span class=\"s1\">'slit'<\/span><span class=\"p\">:<\/span><span class=\"mi\">2<\/span>\n <span class=\"p\">(<\/span><span class=\"mi\">0<\/span><span class=\"p\">,<\/span><span class=\"mi\">17<\/span><span class=\"p\">)<\/span> <span class=\"o\">|<\/span> <span class=\"n\">I<\/span> <span class=\"n\">am<\/span> <span class=\"n\">the<\/span> <span class=\"n\">sleekest<\/span> <span class=\"n\">sheet<\/span> <span class=\"n\">slitter<\/span> <span class=\"n\">that<\/span> <span class=\"n\">ever<\/span> <span class=\"n\">slit<\/span> <span class=\"n\">sheets<\/span><span class=\"p\">.<\/span> <span class=\"o\">|<\/span> <span class=\"s1\">'ever'<\/span><span class=\"p\">:<\/span><span class=\"mi\">8<\/span> <span class=\"s1\">'sheet'<\/span><span class=\"p\">:<\/span><span class=\"mi\">5<\/span><span class=\"p\">,<\/span><span class=\"mi\">10<\/span> <span class=\"s1\">'sleekest'<\/span><span class=\"p\">:<\/span><span class=\"mi\">4<\/span> <span class=\"s1\">'slit'<\/span><span class=\"p\">:<\/span><span class=\"mi\">9<\/span> <span class=\"s1\">'slitter'<\/span><span class=\"p\">:<\/span><span class=\"mi\">6<\/span>\n <span class=\"p\">(<\/span><span class=\"mi\">0<\/span><span class=\"p\">,<\/span><span class=\"mi\">18<\/span><span class=\"p\">)<\/span> <span class=\"o\">|<\/span> <span class=\"n\">She<\/span> <span class=\"n\">slits<\/span> <span class=\"n\">the<\/span> <span class=\"n\">sheet<\/span> <span class=\"n\">she<\/span> <span class=\"n\">sits<\/span> <span class=\"k\">on<\/span><span class=\"p\">.<\/span>                       <span class=\"o\">|<\/span> <span class=\"s1\">'sheet'<\/span><span class=\"p\">:<\/span><span class=\"mi\">4<\/span> <span class=\"s1\">'sit'<\/span><span class=\"p\">:<\/span><span class=\"mi\">6<\/span> <span class=\"s1\">'slit'<\/span><span class=\"p\">:<\/span><span class=\"mi\">2<\/span>\n<span class=\"p\">(<\/span><span class=\"mi\">9<\/span> <span class=\"k\">rows<\/span><span class=\"p\">)<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u0632 \u0628\u0627\u0644\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u062f\u06cc\u062f \u06a9\u0647 \u0648\u0631\u0642 \u060c \u0634\u06a9\u0627\u0641 \u0648 \u0628\u0631\u0634 \u062f\u0631 \u0686\u0646\u062f\u06cc\u0646 \u0631\u062f\u06cc\u0641 \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f \u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0686\u0646\u062f\u06cc\u0646 \u0645\u0648\u0631\u062f \u0648\u062c\u0648\u062f \u062e\u0648\u0627\u0647\u062f \u062f\u0627\u0634\u062a. \u062f\u0631 \u0627\u06cc\u0646 \u062d\u0627\u0644\u062a \u060c \u06cc\u06a9 \u0644\u06cc\u0633\u062a TID \u062a\u0648\u0644\u06cc\u062f \u0645\u06cc \u0634\u0648\u062f \u0648 \u06cc\u06a9 \u062f\u0631\u062e\u062a B \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0628\u0631\u0627\u06cc \u0622\u0646 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<p>\u0628\u06cc\u0627\u0646\u06cc\u0647 \u0632\u06cc\u0631 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u062f\u0631\u06cc\u0627\u0628\u062f \u06a9\u0647 \u0686\u0646\u062f \u0631\u062f\u06cc\u0641 \u06a9\u0644\u0645\u0647 \u062f\u0631 \u0622\u0646 \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"n\">pg_study<\/span><span class=\"o\">=#<\/span> <span class=\"k\">select<\/span> <span class=\"p\">(<\/span><span class=\"k\">unnest<\/span><span class=\"p\">(<\/span><span class=\"n\">doc_tsv<\/span><span class=\"p\">)).<\/span><span class=\"n\">lexeme<\/span><span class=\"p\">,<\/span> <span class=\"k\">count<\/span><span class=\"p\">(<\/span><span class=\"o\">*<\/span><span class=\"p\">)<\/span> <span class=\"k\">from<\/span> <span class=\"n\">ts<\/span>\n<span class=\"k\">group<\/span> <span class=\"k\">by<\/span> <span class=\"mi\">1<\/span> <span class=\"k\">order<\/span> <span class=\"k\">by<\/span> <span class=\"mi\">2<\/span> <span class=\"k\">desc<\/span><span class=\"p\">;<\/span>\n  <span class=\"n\">lexeme<\/span>  <span class=\"o\">|<\/span> <span class=\"k\">count<\/span>\n<span class=\"c1\">----------+-------<\/span>\n <span class=\"n\">sheet<\/span>    <span class=\"o\">|<\/span>     <span class=\"mi\">9<\/span>\n <span class=\"n\">slit<\/span>     <span class=\"o\">|<\/span>     <span class=\"mi\">8<\/span>\n <span class=\"n\">slitter<\/span>  <span class=\"o\">|<\/span>     <span class=\"mi\">5<\/span>\n <span class=\"n\">sit<\/span>      <span class=\"o\">|<\/span>     <span class=\"mi\">2<\/span>\n <span class=\"n\">upon<\/span>     <span class=\"o\">|<\/span>     <span class=\"mi\">1<\/span>\n <span class=\"n\">mani<\/span>     <span class=\"o\">|<\/span>     <span class=\"mi\">1<\/span>\n <span class=\"n\">whoever<\/span>  <span class=\"o\">|<\/span>     <span class=\"mi\">1<\/span>\n <span class=\"n\">sleekest<\/span> <span class=\"o\">|<\/span>     <span class=\"mi\">1<\/span>\n <span class=\"n\">good<\/span>     <span class=\"o\">|<\/span>     <span class=\"mi\">1<\/span>\n <span class=\"n\">could<\/span>    <span class=\"o\">|<\/span>     <span class=\"mi\">1<\/span>\n <span class=\"n\">ever<\/span>     <span class=\"o\">|<\/span>     <span class=\"mi\">1<\/span>\n<span class=\"p\">(<\/span><span class=\"mi\">11<\/span> <span class=\"k\">rows<\/span><span class=\"p\">)<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D9%85%D8%AB%D8%A7%D9%84\"><\/span>\n<p>  \u0645\u062b\u0627\u0644<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u067e\u0631\u0633 \u0648 \u062c\u0648 \u0632\u06cc\u0631 \u0686\u06af\u0648\u0646\u0647 \u0627\u062c\u0631\u0627 \u0645\u06cc \u0634\u0648\u062f\u061f<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"o\">\/\/<\/span> <span class=\"n\">Since<\/span> <span class=\"n\">the<\/span> <span class=\"n\">amount<\/span> <span class=\"k\">of<\/span> <span class=\"k\">data<\/span> <span class=\"k\">is<\/span> <span class=\"n\">small<\/span> <span class=\"n\">here<\/span><span class=\"p\">,<\/span> <span class=\"k\">full<\/span> <span class=\"k\">table<\/span> <span class=\"n\">scan<\/span> <span class=\"k\">is<\/span> <span class=\"n\">disabled<\/span>\n<span class=\"n\">pg_study<\/span><span class=\"o\">=#<\/span> <span class=\"k\">set<\/span> <span class=\"n\">enable_seqscan<\/span> <span class=\"k\">TO<\/span> <span class=\"k\">off<\/span><span class=\"p\">;<\/span>\n<span class=\"k\">SET<\/span>\n\n<span class=\"n\">pg_study<\/span><span class=\"o\">=#<\/span> <span class=\"k\">explain<\/span><span class=\"p\">(<\/span><span class=\"n\">costs<\/span> <span class=\"k\">off<\/span><span class=\"p\">)<\/span>                                 \n<span class=\"k\">select<\/span> <span class=\"n\">doc<\/span> <span class=\"k\">from<\/span> <span class=\"n\">ts<\/span> <span class=\"k\">where<\/span> <span class=\"n\">doc_tsv<\/span> <span class=\"o\">@@<\/span> <span class=\"n\">to_tsquery<\/span><span class=\"p\">(<\/span><span class=\"s1\">'many &amp; slitter'<\/span><span class=\"p\">);<\/span>\n                             <span class=\"n\">QUERY<\/span> <span class=\"n\">PLAN<\/span>\n<span class=\"c1\">---------------------------------------------------------------------<\/span>\n <span class=\"n\">Bitmap<\/span> <span class=\"n\">Heap<\/span> <span class=\"n\">Scan<\/span> <span class=\"k\">on<\/span> <span class=\"n\">ts<\/span>\n   <span class=\"k\">Recheck<\/span> <span class=\"n\">Cond<\/span><span class=\"p\">:<\/span> <span class=\"p\">(<\/span><span class=\"n\">doc_tsv<\/span> <span class=\"o\">@@<\/span> <span class=\"n\">to_tsquery<\/span><span class=\"p\">(<\/span><span class=\"s1\">'many &amp; slitter'<\/span><span class=\"p\">::<\/span><span class=\"nb\">text<\/span><span class=\"p\">))<\/span>\n   <span class=\"o\">-&gt;<\/span>  <span class=\"n\">Bitmap<\/span> <span class=\"k\">Index<\/span> <span class=\"n\">Scan<\/span> <span class=\"k\">on<\/span> <span class=\"n\">ts_doc_tsv_idx<\/span>\n         <span class=\"k\">Index<\/span> <span class=\"n\">Cond<\/span><span class=\"p\">:<\/span> <span class=\"p\">(<\/span><span class=\"n\">doc_tsv<\/span> <span class=\"o\">@@<\/span> <span class=\"n\">to_tsquery<\/span><span class=\"p\">(<\/span><span class=\"s1\">'many &amp; slitter'<\/span><span class=\"p\">::<\/span><span class=\"nb\">text<\/span><span class=\"p\">))<\/span>\n<span class=\"p\">(<\/span><span class=\"mi\">4<\/span> <span class=\"k\">rows<\/span><span class=\"p\">)<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u0628\u062a\u062f\u0627 \u0647\u0631 \u06a9\u0644\u0645\u0647 (\u06a9\u0644\u06cc\u062f \u067e\u0631\u0633 \u0648 \u062c\u0648) \u0631\u0627 \u0627\u0632 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u06a9\u0646\u06cc\u062f: \u0645\u0627\u0646\u06cc \u0648 \u0628\u0631\u0634. \u0627\u06cc\u0646 \u062a\u0648\u0633\u0637 \u06cc\u06a9 API \u0648\u06cc\u0698\u0647 \u062a\u06a9\u0645\u06cc\u0644 \u0645\u06cc \u0634\u0648\u062f \u060c \u06a9\u0647 \u0627\u0633\u062a\u0631\u0627\u062a\u0698\u06cc \u0647\u0627\u06cc \u0627\u0646\u0648\u0627\u0639 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0648 \u0627\u067e\u0631\u0627\u062a\u0648\u0631\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0646\u0638\u0631 \u0645\u06cc \u06af\u06cc\u0631\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"n\">pg_study<\/span><span class=\"o\">=#<\/span> <span class=\"k\">select<\/span> <span class=\"n\">amop<\/span><span class=\"p\">.<\/span><span class=\"n\">amopopr<\/span><span class=\"p\">::<\/span><span class=\"n\">regoperator<\/span><span class=\"p\">,<\/span> <span class=\"n\">amop<\/span><span class=\"p\">.<\/span><span class=\"n\">amopstrategy<\/span>\n<span class=\"k\">from<\/span> <span class=\"n\">pg_opclass<\/span> <span class=\"n\">opc<\/span><span class=\"p\">,<\/span> <span class=\"n\">pg_opfamily<\/span> <span class=\"n\">opf<\/span><span class=\"p\">,<\/span> <span class=\"n\">pg_am<\/span> <span class=\"n\">am<\/span><span class=\"p\">,<\/span> <span class=\"n\">pg_amop<\/span> <span class=\"n\">amop<\/span>\n<span class=\"k\">where<\/span> <span class=\"n\">opc<\/span><span class=\"p\">.<\/span><span class=\"n\">opcname<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'tsvector_ops'<\/span>\n<span class=\"k\">and<\/span> <span class=\"n\">opf<\/span><span class=\"p\">.<\/span><span class=\"n\">oid<\/span> <span class=\"o\">=<\/span> <span class=\"n\">opc<\/span><span class=\"p\">.<\/span><span class=\"n\">opcfamily<\/span>\n<span class=\"k\">and<\/span> <span class=\"n\">am<\/span><span class=\"p\">.<\/span><span class=\"n\">oid<\/span> <span class=\"o\">=<\/span> <span class=\"n\">opf<\/span><span class=\"p\">.<\/span><span class=\"n\">opfmethod<\/span>\n<span class=\"k\">and<\/span> <span class=\"n\">amop<\/span><span class=\"p\">.<\/span><span class=\"n\">amopfamily<\/span> <span class=\"o\">=<\/span> <span class=\"n\">opc<\/span><span class=\"p\">.<\/span><span class=\"n\">opcfamily<\/span>\n<span class=\"k\">and<\/span> <span class=\"n\">am<\/span><span class=\"p\">.<\/span><span class=\"n\">amname<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'gin'<\/span>\n<span class=\"k\">and<\/span> <span class=\"n\">amop<\/span><span class=\"p\">.<\/span><span class=\"n\">amoplefttype<\/span> <span class=\"o\">=<\/span> <span class=\"n\">opc<\/span><span class=\"p\">.<\/span><span class=\"n\">opcintype<\/span><span class=\"p\">;<\/span>\n        <span class=\"n\">amopopr<\/span>        <span class=\"o\">|<\/span> <span class=\"n\">amopstrategy<\/span>\n<span class=\"c1\">-----------------------+--------------<\/span>\n <span class=\"o\">@@<\/span><span class=\"p\">(<\/span><span class=\"n\">tsvector<\/span><span class=\"p\">,<\/span><span class=\"n\">tsquery<\/span><span class=\"p\">)<\/span>  <span class=\"o\">|<\/span>            <span class=\"mi\">1<\/span>\n <span class=\"o\">@@@<\/span><span class=\"p\">(<\/span><span class=\"n\">tsvector<\/span><span class=\"p\">,<\/span><span class=\"n\">tsquery<\/span><span class=\"p\">)<\/span> <span class=\"o\">|<\/span>            <span class=\"mi\">2<\/span>\n<span class=\"p\">(<\/span><span class=\"mi\">2<\/span> <span class=\"k\">rows<\/span><span class=\"p\">)<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u062f\u0631 \u062f\u0631\u062e\u062a B \u062d\u0627\u0648\u06cc \u06a9\u0644\u0645\u0627\u062a \u060c \u0644\u06cc\u0633\u062a \u0647\u0627\u06cc TID \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u062f\u0648 \u06a9\u0644\u06cc\u062f \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n<p>\u0645\u0627\u0646\u06cc: (0\u060c2)<br \/>\u0628\u0631\u0634: (0\u060c1) \u060c (0\u060c2) \u060c (1\u060c2) \u060c (1\u060c3) \u060c (2\u060c2)<\/p>\n<p>\u062f\u0631 \u0622\u062e\u0631 \u060c \u0628\u0631\u0627\u06cc \u0647\u0631 \u06cc\u06a9 \u0627\u0632 \u0622\u0646\u0647\u0627 \u06a9\u0647 \u067e\u06cc\u062f\u0627 \u0634\u062f\u0647 \u0627\u0633\u062a \u060c \u0628\u0647 \u0646\u0648\u0628\u0647 \u062e\u0648\u062f \u0628\u0627 \u0639\u0645\u0644\u06a9\u0631\u062f \u0642\u0648\u0627\u0645 \u062a\u0645\u0627\u0633 \u0628\u06af\u06cc\u0631\u06cc\u062f. \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0642\u0648\u0627\u0645 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u062a\u0639\u06cc\u06cc\u0646 \u06a9\u0646\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u0631\u062f\u06cc\u0641 \u0628\u0647 TID \u0628\u0627 \u0634\u0631\u0627\u06cc\u0637 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u0637\u0627\u0628\u0642\u062a \u062f\u0627\u0631\u062f \u06cc\u0627 \u062e\u06cc\u0631. \u0627\u0632 \u0622\u0646\u062c\u0627 \u06a9\u0647 \u06a9\u0644\u0645\u0627\u062a \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u062a\u0648\u0633\u0637 \u0648 \u0628\u0647 \u0647\u0645 \u0648\u0635\u0644 \u0634\u062f\u0647 \u0627\u0646\u062f \u0648 \u0631\u062f\u06cc\u0641 \u0628\u0631\u06af\u0634\u062a\u06cc \u0641\u0642\u0637 (0\u060c2) \u0627\u0633\u062a.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>       |      |         |  consistency\n       |      |         |    function\n  TID  | mani | slitter | slit &amp; slitter\n-------+------+---------+----------------\n (0,1) |    f |       T |              f \n (0,2) |    T |       T |              T\n (1,2) |    f |       T |              f\n (1,3) |    f |       T |              f\n (2,2) |    f |       T |              f\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0646\u062a\u06cc\u062c\u0647 \u0627\u06cc\u0646 \u0627\u0633\u062a:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"n\">pg_study<\/span><span class=\"o\">=#<\/span> <span class=\"k\">select<\/span> <span class=\"n\">doc<\/span> <span class=\"k\">from<\/span> <span class=\"n\">ts<\/span> <span class=\"k\">where<\/span> <span class=\"n\">doc_tsv<\/span> <span class=\"o\">@@<\/span> <span class=\"n\">to_tsquery<\/span><span class=\"p\">(<\/span><span class=\"s1\">'many &amp; slitter'<\/span><span class=\"p\">);<\/span>\n                     <span class=\"n\">doc<\/span>\n<span class=\"c1\">---------------------------------------------<\/span>\n <span class=\"n\">How<\/span> <span class=\"n\">many<\/span> <span class=\"n\">sheets<\/span> <span class=\"n\">could<\/span> <span class=\"n\">a<\/span> <span class=\"n\">sheet<\/span> <span class=\"n\">slitter<\/span> <span class=\"n\">slit<\/span><span class=\"o\">?<\/span>\n<span class=\"p\">(<\/span><span class=\"mi\">1<\/span> <span class=\"k\">row<\/span><span class=\"p\">)<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D9%85%D8%B4%DA%A9%D9%84_%D8%B3%D8%B1%D8%B9%D8%AA_%D8%A8%D9%87_%D8%B1%D9%88%D8%B2%D8%B1%D8%B3%D8%A7%D9%86%DB%8C_%D8%A2%D9%87%D8%B3%D8%AA%D9%87\"><\/span>\n<p>  \u0645\u0634\u06a9\u0644 \u0633\u0631\u0639\u062a \u0628\u0647 \u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0622\u0647\u0633\u062a\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u062f\u0631\u062c \u06cc\u0627 \u0628\u0647 \u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u0634\u0627\u062e\u0635 GIN \u0628\u0633\u06cc\u0627\u0631 \u06a9\u0646\u062f \u0627\u0633\u062a. \u0627\u0632 \u0622\u0646\u062c\u0627 \u06a9\u0647 \u0647\u0631 \u0631\u062f\u06cc\u0641 \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u062d\u0627\u0648\u06cc \u0628\u0633\u06cc\u0627\u0631\u06cc \u0627\u0632 \u0639\u0646\u0627\u0635\u0631 \u06a9\u0644\u0645\u0647 \u0627\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0646\u0645\u0627\u06cc\u0647 \u0634\u0648\u0646\u062f. \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u060c \u0647\u0646\u06af\u0627\u0645 \u0627\u0641\u0632\u0648\u062f\u0646 \u06cc\u0627 \u0628\u0647 \u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u06cc\u06a9 \u0631\u062f\u06cc\u0641 \u060c \u0628\u0627\u06cc\u062f \u062f\u0631\u062e\u062a \u0634\u0627\u062e\u0635 \u0631\u0627 \u0632\u06cc\u0627\u062f \u0628\u0647 \u0631\u0648\u0632 \u06a9\u0646\u06cc\u0645.<\/p>\n<p>\u0627\u0632 \u0637\u0631\u0641 \u062f\u06cc\u06af\u0631 \u060c \u0627\u06af\u0631 \u0686\u0646\u062f\u06cc\u0646 \u0631\u062f\u06cc\u0641 \u0628\u0647 \u0637\u0648\u0631 \u0647\u0645\u0632\u0645\u0627\u0646 \u0628\u0647 \u0631\u0648\u0632 \u0634\u0648\u0646\u062f \u060c \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0631\u062e\u06cc \u0627\u0632 \u0639\u0646\u0627\u0635\u0631 \u06a9\u0644\u0645\u0647 \u0622\u0646\u0647\u0627 \u06cc\u06a9\u0633\u0627\u0646 \u0628\u0627\u0634\u062f \u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0647\u0632\u06cc\u0646\u0647 \u06a9\u0644 \u06a9\u0645\u062a\u0631 \u0627\u0632 \u0647\u0632\u06cc\u0646\u0647 \u0628\u0647 \u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0627\u0633\u0646\u0627\u062f \u062a\u0648\u0633\u0637 \u0631\u062f\u06cc\u0641 \u0627\u0633\u062a.<\/p>\n<p>\u0634\u0627\u062e\u0635 GIN \u062f\u0627\u0631\u0627\u06cc \u06cc\u06a9 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc FastUpdate \u0627\u0633\u062a \u06a9\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0647\u0646\u06af\u0627\u0645 \u0627\u06cc\u062c\u0627\u062f \u0641\u0647\u0631\u0633\u062a \u0645\u0634\u062e\u0635 \u06a9\u0646\u06cc\u0645 \u0648 \u0628\u0639\u062f\u0627\u064b \u0622\u0646 \u0631\u0627 \u0628\u0647 \u0631\u0648\u0632 \u06a9\u0646\u06cc\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"n\">pg_study<\/span><span class=\"o\">=#<\/span> <span class=\"k\">create<\/span> <span class=\"k\">index<\/span> <span class=\"k\">on<\/span> <span class=\"n\">ts<\/span> <span class=\"k\">using<\/span> <span class=\"n\">gin<\/span><span class=\"p\">(<\/span><span class=\"n\">doc_tsv<\/span><span class=\"p\">)<\/span> <span class=\"k\">with<\/span> <span class=\"p\">(<\/span><span class=\"n\">fastupdate<\/span> <span class=\"o\">=<\/span> <span class=\"k\">true<\/span><span class=\"p\">);<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">INDEX<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u067e\u0633 \u0627\u0632 \u0641\u0639\u0627\u0644 \u06a9\u0631\u062f\u0646 \u0627\u06cc\u0646 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u060c \u0628\u0647 \u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0647\u0627 \u062f\u0631 \u06cc\u06a9 \u0644\u06cc\u0633\u062a \u0645\u062c\u0632\u0627 \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u062c\u0645\u0639 \u0645\u06cc \u0634\u0648\u0646\u062f. \u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0627\u06cc\u0646 \u0644\u06cc\u0633\u062a \u0628\u0647 \u0627\u0646\u062f\u0627\u0632\u0647 \u06a9\u0627\u0641\u06cc \u0628\u0632\u0631\u06af \u06cc\u0627 \u062f\u0631 \u0647\u0646\u06af\u0627\u0645 \u062e\u0644\u0627\u0621 (\u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0632\u0628\u0627\u0644\u0647) \u0628\u0627\u0634\u062f \u060c \u062a\u0645\u0627\u0645 \u0628\u0647 \u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0647\u0627\u06cc \u0627\u0646\u0628\u0627\u0634\u062a\u0647 \u0634\u062f\u0647 \u0628\u0644\u0627\u0641\u0627\u0635\u0644\u0647 \u0631\u0648\u06cc \u0634\u0627\u062e\u0635 \u06a9\u0627\u0631 \u0645\u06cc \u0634\u0648\u0646\u062f. \u0644\u06cc\u0633\u062a &#8220;\u0628\u0647 \u0627\u0646\u062f\u0627\u0632\u0647 \u06a9\u0627\u0641\u06cc \u0628\u0632\u0631\u06af&#8221; \u062a\u0648\u0633\u0637 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc &#8220;gin_pending_list_limit&#8221; \u06cc\u0627 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc \u0628\u0627 \u0647\u0645\u06cc\u0646 \u0646\u0627\u0645 \u0647\u0646\u06af\u0627\u0645 \u0627\u06cc\u062c\u0627\u062f \u0634\u0627\u062e\u0635 \u062a\u0639\u06cc\u06cc\u0646 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D8%AC%D8%B3%D8%AA%D8%AC%D9%88%DB%8C_%D9%85%D8%B3%D8%A7%D8%A8%D9%82%D9%87_%D8%AC%D8%B2%D8%A6%DB%8C\"><\/span>\n<p>  \u062c\u0633\u062a\u062c\u0648\u06cc \u0645\u0633\u0627\u0628\u0642\u0647 \u062c\u0632\u0626\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u06a9\u0647 \u0628\u0627 \u0634\u06a9\u0627\u0641 \u0634\u0631\u0648\u0639 \u0645\u06cc \u0634\u0648\u062f \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0646\u06cc\u062f<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"n\">pg_study<\/span><span class=\"o\">=#<\/span> <span class=\"k\">select<\/span> <span class=\"n\">doc<\/span> <span class=\"k\">from<\/span> <span class=\"n\">ts<\/span> <span class=\"k\">where<\/span> <span class=\"n\">doc_tsv<\/span> <span class=\"o\">@@<\/span> <span class=\"n\">to_tsquery<\/span><span class=\"p\">(<\/span><span class=\"s1\">'slit:*'<\/span><span class=\"p\">);<\/span>\n                          <span class=\"n\">doc<\/span>\n<span class=\"c1\">--------------------------------------------------------<\/span>\n <span class=\"n\">Can<\/span> <span class=\"n\">a<\/span> <span class=\"n\">sheet<\/span> <span class=\"n\">slitter<\/span> <span class=\"n\">slit<\/span> <span class=\"n\">sheets<\/span><span class=\"o\">?<\/span>\n <span class=\"n\">How<\/span> <span class=\"n\">many<\/span> <span class=\"n\">sheets<\/span> <span class=\"n\">could<\/span> <span class=\"n\">a<\/span> <span class=\"n\">sheet<\/span> <span class=\"n\">slitter<\/span> <span class=\"n\">slit<\/span><span class=\"o\">?<\/span>\n <span class=\"n\">I<\/span> <span class=\"n\">slit<\/span> <span class=\"n\">a<\/span> <span class=\"n\">sheet<\/span><span class=\"p\">,<\/span> <span class=\"n\">a<\/span> <span class=\"n\">sheet<\/span> <span class=\"n\">I<\/span> <span class=\"n\">slit<\/span><span class=\"p\">.<\/span>\n <span class=\"n\">Upon<\/span> <span class=\"n\">a<\/span> <span class=\"n\">slitted<\/span> <span class=\"n\">sheet<\/span> <span class=\"n\">I<\/span> <span class=\"n\">sit<\/span><span class=\"p\">.<\/span>\n <span class=\"n\">Whoever<\/span> <span class=\"n\">slit<\/span> <span class=\"n\">the<\/span> <span class=\"n\">sheets<\/span> <span class=\"k\">is<\/span> <span class=\"n\">a<\/span> <span class=\"n\">good<\/span> <span class=\"n\">sheet<\/span> <span class=\"n\">slitter<\/span><span class=\"p\">.<\/span>\n <span class=\"n\">I<\/span> <span class=\"n\">am<\/span> <span class=\"n\">a<\/span> <span class=\"n\">sheet<\/span> <span class=\"n\">slitter<\/span><span class=\"p\">.<\/span>\n <span class=\"n\">I<\/span> <span class=\"n\">slit<\/span> <span class=\"n\">sheets<\/span><span class=\"p\">.<\/span>\n <span class=\"n\">I<\/span> <span class=\"n\">am<\/span> <span class=\"n\">the<\/span> <span class=\"n\">sleekest<\/span> <span class=\"n\">sheet<\/span> <span class=\"n\">slitter<\/span> <span class=\"n\">that<\/span> <span class=\"n\">ever<\/span> <span class=\"n\">slit<\/span> <span class=\"n\">sheets<\/span><span class=\"p\">.<\/span>\n <span class=\"n\">She<\/span> <span class=\"n\">slits<\/span> <span class=\"n\">the<\/span> <span class=\"n\">sheet<\/span> <span class=\"n\">she<\/span> <span class=\"n\">sits<\/span> <span class=\"k\">on<\/span><span class=\"p\">.<\/span>\n<span class=\"p\">(<\/span><span class=\"mi\">9<\/span> <span class=\"k\">rows<\/span><span class=\"p\">)<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u0632 \u0627\u06cc\u0646 \u0634\u0627\u062e\u0635 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0631\u0627\u06cc \u062a\u0633\u0631\u06cc\u0639 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"n\">pg_study<\/span><span class=\"o\">=#<\/span> <span class=\"k\">explain<\/span> <span class=\"p\">(<\/span><span class=\"n\">costs<\/span> <span class=\"k\">off<\/span><span class=\"p\">)<\/span>\n<span class=\"k\">select<\/span> <span class=\"n\">doc<\/span> <span class=\"k\">from<\/span> <span class=\"n\">ts<\/span> <span class=\"k\">where<\/span> <span class=\"n\">doc_tsv<\/span> <span class=\"o\">@@<\/span> <span class=\"n\">to_tsquery<\/span><span class=\"p\">(<\/span><span class=\"s1\">'slit:*'<\/span><span class=\"p\">);<\/span>\n                    <span class=\"n\">QUERY<\/span> <span class=\"n\">PLAN<\/span>\n<span class=\"c1\">---------------------------------------------------<\/span>\n <span class=\"n\">Seq<\/span> <span class=\"n\">Scan<\/span> <span class=\"k\">on<\/span> <span class=\"n\">ts<\/span>\n   <span class=\"n\">Filter<\/span><span class=\"p\">:<\/span> <span class=\"p\">(<\/span><span class=\"n\">doc_tsv<\/span> <span class=\"o\">@@<\/span> <span class=\"n\">to_tsquery<\/span><span class=\"p\">(<\/span><span class=\"s1\">'slit:*'<\/span><span class=\"p\">::<\/span><span class=\"nb\">text<\/span><span class=\"p\">))<\/span>\n<span class=\"p\">(<\/span><span class=\"mi\">2<\/span> <span class=\"k\">rows<\/span><span class=\"p\">)<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D9%81%D8%B1%D8%A7%D9%88%D8%A7%D9%86%DB%8C_%DA%A9%D9%84%D9%85%D8%A7%D8%AA_%DA%A9%D9%84%DB%8C%D8%AF%DB%8C\"><\/span>\n<p>  \u0641\u0631\u0627\u0648\u0627\u0646\u06cc \u06a9\u0644\u0645\u0627\u062a \u06a9\u0644\u06cc\u062f\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u0631\u062e\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062a\u0648\u0644\u06cc\u062f \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"n\">fts<\/span><span class=\"o\">=#<\/span> <span class=\"k\">alter<\/span> <span class=\"k\">table<\/span> <span class=\"n\">mail_messages<\/span> <span class=\"k\">add<\/span> <span class=\"k\">column<\/span> <span class=\"n\">tsv<\/span> <span class=\"n\">tsvector<\/span><span class=\"p\">;<\/span>\n<span class=\"n\">fts<\/span><span class=\"o\">=#<\/span> <span class=\"k\">update<\/span> <span class=\"n\">mail_messages<\/span> <span class=\"k\">set<\/span> <span class=\"n\">tsv<\/span> <span class=\"o\">=<\/span> <span class=\"n\">to_tsvector<\/span><span class=\"p\">(<\/span><span class=\"n\">body_plain<\/span><span class=\"p\">);<\/span>\n<span class=\"n\">fts<\/span><span class=\"o\">=#<\/span> <span class=\"k\">create<\/span> <span class=\"k\">index<\/span> <span class=\"k\">on<\/span> <span class=\"n\">mail_messages<\/span> <span class=\"k\">using<\/span> <span class=\"n\">gin<\/span><span class=\"p\">(<\/span><span class=\"n\">tsv<\/span><span class=\"p\">);<\/span>\n<span class=\"n\">fts<\/span><span class=\"o\">=#<\/span> <span class=\"err\">\\<\/span><span class=\"n\">timing<\/span> <span class=\"k\">on<\/span>\n\n<span class=\"c1\">-- A total of 466125 pieces of data<\/span>\n<span class=\"n\">fts<\/span><span class=\"o\">=#<\/span> <span class=\"k\">select<\/span> <span class=\"k\">count<\/span><span class=\"p\">(<\/span><span class=\"o\">*<\/span><span class=\"p\">)<\/span> <span class=\"k\">from<\/span> <span class=\"n\">mail_messages<\/span><span class=\"p\">;<\/span>\n <span class=\"k\">count<\/span>\n<span class=\"c1\">--------<\/span>\n <span class=\"mi\">356125<\/span>\n<span class=\"p\">(<\/span><span class=\"mi\">1<\/span> <span class=\"k\">row<\/span><span class=\"p\">)<\/span>\n\n<span class=\"c1\">-- Here, instead of using unnest to count the number of times a word appears in a row, because the amount of data is relatively large, we use the ts_stat function to calculate<\/span>\n<span class=\"n\">fts<\/span><span class=\"o\">=#<\/span> <span class=\"k\">select<\/span> <span class=\"n\">word<\/span><span class=\"p\">,<\/span> <span class=\"n\">ndoc<\/span>\n<span class=\"n\">fts<\/span><span class=\"o\">-#<\/span> <span class=\"k\">from<\/span> <span class=\"n\">ts_stat<\/span><span class=\"p\">(<\/span><span class=\"s1\">'select tsv from mail_messages'<\/span><span class=\"p\">)<\/span>\n<span class=\"n\">fts<\/span><span class=\"o\">-#<\/span> <span class=\"k\">order<\/span> <span class=\"k\">by<\/span> <span class=\"n\">ndoc<\/span> <span class=\"k\">desc<\/span> <span class=\"k\">limit<\/span> <span class=\"mi\">3<\/span><span class=\"p\">;<\/span>\n <span class=\"n\">word<\/span>  <span class=\"o\">|<\/span>  <span class=\"n\">ndoc<\/span>  \n<span class=\"c1\">-------+--------<\/span>\n <span class=\"n\">wrote<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">231174<\/span>\n <span class=\"n\">use<\/span>   <span class=\"o\">|<\/span> <span class=\"mi\">173833<\/span>\n <span class=\"n\">would<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">157169<\/span>\n<span class=\"p\">(<\/span><span class=\"mi\">3<\/span> <span class=\"k\">rows<\/span><span class=\"p\">)<\/span>\n\n<span class=\"nb\">Time<\/span><span class=\"p\">:<\/span> <span class=\"mi\">11556<\/span><span class=\"p\">.<\/span><span class=\"mi\">976<\/span> <span class=\"n\">ms<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644 \u060c \u0645\u0627 \u06a9\u0644\u0645\u0647 \u0627\u06cc \u0631\u0627 \u06a9\u0647 \u0628\u0647 \u0646\u062f\u0631\u062a \u062f\u0631 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0627\u06cc\u0645\u06cc\u0644 \u0645\u0627\u0646\u0646\u062f &#8220;\u062e\u0627\u0644 \u06a9\u0648\u0628\u06cc&#8221; \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f \u060c \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u06cc \u06a9\u0646\u06cc\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"n\">fts<\/span><span class=\"o\">=#<\/span> <span class=\"k\">select<\/span> <span class=\"n\">word<\/span><span class=\"p\">,<\/span> <span class=\"n\">ndoc<\/span> <span class=\"k\">from<\/span> <span class=\"n\">ts_stat<\/span><span class=\"p\">(<\/span><span class=\"s1\">'select tsv from mail_messages'<\/span><span class=\"p\">)<\/span> <span class=\"k\">where<\/span> <span class=\"n\">word<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'tattoo'<\/span><span class=\"p\">;<\/span>\n  <span class=\"n\">word<\/span>  <span class=\"o\">|<\/span> <span class=\"n\">ndoc<\/span> \n<span class=\"c1\">--------+------<\/span>\n <span class=\"n\">tattoo<\/span> <span class=\"o\">|<\/span>    <span class=\"mi\">2<\/span>\n<span class=\"p\">(<\/span><span class=\"mi\">1<\/span> <span class=\"k\">row<\/span><span class=\"p\">)<\/span>\n\n<span class=\"nb\">Time<\/span><span class=\"p\">:<\/span> <span class=\"mi\">11236<\/span><span class=\"p\">.<\/span><span class=\"mi\">340<\/span> <span class=\"n\">ms<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u062a\u0639\u062f\u0627\u062f \u062f\u0641\u0639\u0627\u062a \u062f\u0648 \u06a9\u0644\u0645\u0647 \u062f\u0631 \u06cc\u06a9 \u0631\u062f\u06cc\u0641 \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f. \u0641\u0642\u0637 \u06cc\u06a9 \u0631\u062f\u06cc\u0641 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u062f\u0631 \u0647\u0645\u0627\u0646 \u0632\u0645\u0627\u0646 \u0646\u0648\u0634\u062a \u0648 \u062e\u0627\u0644 \u06a9\u0648\u0628\u06cc \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"n\">fts<\/span><span class=\"o\">=#<\/span> <span class=\"k\">select<\/span> <span class=\"k\">count<\/span><span class=\"p\">(<\/span><span class=\"o\">*<\/span><span class=\"p\">)<\/span> <span class=\"k\">from<\/span> <span class=\"n\">mail_messages<\/span> <span class=\"k\">where<\/span> <span class=\"n\">tsv<\/span> <span class=\"o\">@@<\/span> <span class=\"n\">to_tsquery<\/span><span class=\"p\">(<\/span><span class=\"s1\">'wrote &amp; tattoo'<\/span><span class=\"p\">);<\/span>\n <span class=\"k\">count<\/span> \n<span class=\"c1\">-------<\/span>\n     <span class=\"mi\">1<\/span>\n<span class=\"p\">(<\/span><span class=\"mi\">1<\/span> <span class=\"k\">row<\/span><span class=\"p\">)<\/span>\n\n<span class=\"nb\">Time<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">550<\/span> <span class=\"n\">ms<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0628\u06cc\u0627\u06cc\u06cc\u062f \u0628\u0628\u06cc\u0646\u06cc\u0645 \u06a9\u0647 \u0686\u06af\u0648\u0646\u0647 \u0627\u062c\u0631\u0627 \u0645\u06cc \u0634\u0648\u062f. \u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u062f\u0631 \u0628\u0627\u0644\u0627 \u0630\u06a9\u0631 \u0634\u062f \u060c \u0627\u06af\u0631 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u0644\u06cc\u0633\u062a \u0647\u0627\u06cc TID \u062f\u0648 \u06a9\u0644\u0645\u0647 \u0631\u0627 \u0628\u062f\u0633\u062a \u0622\u0648\u0631\u06cc\u0645 \u060c \u0628\u0627\u0632\u062f\u0647 \u062c\u0633\u062a\u062c\u0648 \u06a9\u0627\u0645\u0644\u0627\u064b \u06a9\u0645 \u0627\u0633\u062a: \u0632\u06cc\u0631\u0627 \u0645\u0627 \u0628\u0627\u06cc\u062f \u0628\u06cc\u0634 \u0627\u0632 200\u060c000 \u0645\u0642\u062f\u0627\u0631 \u0631\u0627 \u0637\u06cc \u06a9\u0646\u06cc\u0645 \u0648 \u0641\u0642\u0637 \u06cc\u06a9 \u0645\u0642\u062f\u0627\u0631 \u06af\u0631\u0641\u062a\u0647 \u0645\u06cc \u0634\u0648\u062f. \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644 \u060c \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0622\u0645\u0627\u0631\u06cc \u060c \u0627\u0644\u06af\u0648\u0631\u06cc\u062a\u0645 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u062f\u0627\u0646\u062f \u06a9\u0647 &#8220;\u0646\u0648\u0634\u062a&#8221; \u0628\u0647 \u0637\u0648\u0631 \u0645\u06a9\u0631\u0631 \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f \u060c \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 &#8220;\u062e\u0627\u0644 \u06a9\u0648\u0628\u06cc&#8221; \u0628\u0647 \u0646\u062f\u0631\u062a \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f. \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u060c \u062c\u0633\u062a\u062c\u0648\u06cc \u06a9\u0644\u0645\u0647 \u0627\u06cc \u06a9\u0647 \u0627\u063a\u0644\u0628 \u0645\u0648\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0642\u0631\u0627\u0631 \u0646\u0645\u06cc \u06af\u06cc\u0631\u062f \u0627\u062c\u0631\u0627 \u0645\u06cc \u0634\u0648\u062f \u060c \u0648 \u0633\u067e\u0633 \u0628\u0631\u0631\u0633\u06cc \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u0622\u06cc\u0627 &#8220;\u0646\u0648\u0634\u062a&#8221; \u062f\u0631 \u062f\u0648 \u0631\u062f\u06cc\u0641 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0634\u062f\u0647 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06cc\u0627 \u062e\u06cc\u0631. \u0628\u0647 \u0627\u06cc\u0646 \u062a\u0631\u062a\u06cc\u0628 \u060c \u0646\u062a\u06cc\u062c\u0647 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0647 \u0633\u0631\u0639\u062a \u0628\u062f\u0633\u062a \u0622\u0648\u0631\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"n\">fts<\/span><span class=\"o\">=#<\/span> <span class=\"k\">select<\/span> <span class=\"k\">count<\/span><span class=\"p\">(<\/span><span class=\"o\">*<\/span><span class=\"p\">)<\/span> <span class=\"k\">from<\/span> <span class=\"n\">mail_messages<\/span> <span class=\"k\">where<\/span> <span class=\"n\">tsv<\/span> <span class=\"o\">@@<\/span> <span class=\"n\">to_tsquery<\/span><span class=\"p\">(<\/span><span class=\"s1\">'wrote &amp; tattoo'<\/span><span class=\"p\">);<\/span>\n <span class=\"k\">count<\/span> \n<span class=\"c1\">-------<\/span>\n     <span class=\"mi\">1<\/span>\n<span class=\"p\">(<\/span><span class=\"mi\">1<\/span> <span class=\"k\">row<\/span><span class=\"p\">)<\/span>\n\n<span class=\"nb\">Time<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">419<\/span> <span class=\"n\">ms<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D9%85%D8%AD%D8%AF%D9%88%D8%AF_%DA%A9%D8%B1%D8%AF%D9%86_%D9%86%D8%AA%D8%A7%DB%8C%D8%AC_%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88\"><\/span>\n<p>  \u0645\u062d\u062f\u0648\u062f \u06a9\u0631\u062f\u0646 \u0646\u062a\u0627\u06cc\u062c \u067e\u0631\u0633 \u0648 \u062c\u0648<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u06cc\u06a9\u06cc \u0627\u0632 \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u0634\u0627\u062e\u0635 \u062c\u06cc\u0646 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0641\u0642\u0637 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u06cc\u06a9 \u0645\u067e \u06a9\u0648\u0686\u06a9 \u0631\u0627 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f \u0648 \u0646\u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0647\u0631 \u06cc\u06a9 \u0631\u0627 \u06cc\u06a9 \u0628\u0647 \u06cc\u06a9 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f. \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u060c \u062a\u0645\u0627\u0645 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0627\u0632 \u0627\u0633\u06a9\u0646 Bitmap \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u0646\u062f.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D8%B1%D9%88%D8%B4_%D9%81%D8%B4%D8%B1%D8%AF%D9%87_%D8%B3%D8%A7%D8%B2%DB%8C\"><\/span>\n<p>  \u0631\u0648\u0634 \u0641\u0634\u0631\u062f\u0647 \u0633\u0627\u0632\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u06cc\u06a9\u06cc \u0627\u0632 \u0645\u0632\u0627\u06cc\u0627\u06cc \u062c\u06cc\u0646 \u0648\u06cc\u0698\u06af\u06cc \u0641\u0634\u0631\u062f\u0647 \u0633\u0627\u0632\u06cc \u0622\u0646 \u0627\u0633\u062a. \u062f\u0631 \u0645\u0631\u062d\u0644\u0647 \u0627\u0648\u0644 \u060c \u0627\u06af\u0631 \u0647\u0645\u0627\u0646 \u06a9\u0644\u0645\u0647 \u062f\u0631 \u0686\u0646\u062f\u06cc\u0646 \u0631\u062f\u06cc\u0641 \u0638\u0627\u0647\u0631 \u0634\u0648\u062f \u060c \u0641\u0642\u0637 \u06cc\u06a9 \u0628\u0627\u0631 \u062f\u0631 \u0641\u0647\u0631\u0633\u062a \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc \u0634\u0648\u062f. \u062b\u0627\u0646\u06cc\u0627 \u060c TID \u0647\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0645\u0631\u062a\u0628 \u0634\u062f\u0647 \u062f\u0631 \u0641\u0647\u0631\u0633\u062a \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc \u0634\u0648\u0646\u062f \u060c \u06a9\u0647 \u0645\u0627 \u0631\u0627 \u0642\u0627\u062f\u0631 \u0645\u06cc \u0633\u0627\u0632\u062f \u0627\u0632 \u06cc\u06a9 \u0631\u0648\u0634 \u0641\u0634\u0631\u062f\u0647 \u0633\u0627\u0632\u06cc \u0633\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645: \u0646\u06a9\u062a\u0647 \u0628\u0639\u062f\u06cc \u062f\u0631 \u0644\u06cc\u0633\u062a \u062f\u0631 \u0648\u0627\u0642\u0639 \u0628\u0627 TID \u0642\u0628\u0644\u06cc \u0645\u062a\u0641\u0627\u0648\u062a \u0627\u0633\u062a. \u0627\u06cc\u0646 \u062a\u0639\u062f\u0627\u062f \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u0628\u0633\u06cc\u0627\u0631 \u0627\u0646\u062f\u06a9 \u0627\u0633\u062a \u0648 \u062f\u0631 \u0645\u0642\u0627\u06cc\u0633\u0647 \u0628\u0627 \u06a9\u0627\u0645\u0644 \u06a9\u0627\u0645\u0644 \u0634\u0634 \u0628\u0627\u06cc\u062a \u060c \u062a\u0639\u062f\u0627\u062f \u0628\u06cc\u062a \u0647\u0627\u06cc \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 \u0628\u0633\u06cc\u0627\u0631 \u06a9\u0648\u0686\u06a9\u062a\u0631 \u0627\u0633\u062a.<\/p>\n<p>\u0627\u0646\u062f\u0627\u0632\u0647 \u0634\u0627\u062e\u0635 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0631\u0627 \u0628\u0627 \u06cc\u06a9\u062f\u06cc\u06af\u0631 \u0645\u0642\u0627\u06cc\u0633\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<p>\u06cc\u06a9 \u0641\u0647\u0631\u0633\u062a B-Tree \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f:<br \/>\u062c\u06cc\u0646 \u0628\u0631 \u0631\u0648\u06cc \u06cc\u06a9 \u0646\u0648\u0639 \u062f\u0627\u062f\u0647 \u0645\u062a\u0641\u0627\u0648\u062a (tsveector \u0628\u0647 \u062c\u0627\u06cc \u0645\u062a\u0646) \u0633\u0627\u062e\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u060c \u0648 \u0627\u06cc\u0646 \u0646\u0648\u0639 \u062f\u0627\u062f\u0647 \u06a9\u0648\u0686\u06a9\u062a\u0631 \u0627\u0633\u062a.<br \/>\u062f\u0631 \u0647\u0645\u0627\u0646 \u0632\u0645\u0627\u0646 \u060c \u062f\u0631\u062e\u062a B \u067e\u06cc\u0627\u0645 \u0631\u0627 \u0628\u0647 2K \u06a9\u0627\u0647\u0634 \u0645\u06cc \u062f\u0647\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"n\">fts<\/span><span class=\"o\">=#<\/span> <span class=\"k\">create<\/span> <span class=\"k\">index<\/span> <span class=\"n\">mail_messages_btree<\/span> <span class=\"k\">on<\/span> <span class=\"n\">mail_messages<\/span><span class=\"p\">(<\/span><span class=\"k\">substring<\/span><span class=\"p\">(<\/span><span class=\"n\">body_plain<\/span> <span class=\"k\">for<\/span> <span class=\"mi\">2048<\/span><span class=\"p\">));<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">INDEX<\/span>\n<span class=\"nb\">Time<\/span><span class=\"p\">:<\/span> <span class=\"mi\">32709<\/span><span class=\"p\">.<\/span><span class=\"mi\">807<\/span> <span class=\"n\">ms<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u06cc\u06a9 \u0641\u0647\u0631\u0633\u062a GIST \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"n\">fts<\/span><span class=\"o\">=#<\/span> <span class=\"k\">create<\/span> <span class=\"k\">index<\/span> <span class=\"n\">mail_messages_gist<\/span> <span class=\"k\">on<\/span> <span class=\"n\">mail_messages<\/span> <span class=\"k\">using<\/span> <span class=\"n\">gist<\/span><span class=\"p\">(<\/span><span class=\"n\">tsv<\/span><span class=\"p\">);<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">INDEX<\/span>\n<span class=\"nb\">Time<\/span><span class=\"p\">:<\/span> <span class=\"mi\">14651<\/span><span class=\"p\">.<\/span><span class=\"mi\">884<\/span> <span class=\"n\">ms<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0628\u0647 \u062a\u0631\u062a\u06cc\u0628 \u0628\u0647 \u0627\u0646\u062f\u0627\u0632\u0647 \u0647\u0627\u06cc \u062c\u06cc\u0646 \u060c gist \u0648 btree \u0646\u06af\u0627\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"n\">fts<\/span><span class=\"o\">=#<\/span> <span class=\"k\">select<\/span> <span class=\"n\">pg_size_pretty<\/span><span class=\"p\">(<\/span><span class=\"n\">pg_relation_size<\/span><span class=\"p\">(<\/span><span class=\"s1\">'mail_messages_tsv_idx'<\/span><span class=\"p\">))<\/span> <span class=\"k\">as<\/span> <span class=\"n\">gin<\/span><span class=\"p\">,<\/span>\n<span class=\"n\">fts<\/span><span class=\"o\">-#<\/span>              <span class=\"n\">pg_size_pretty<\/span><span class=\"p\">(<\/span><span class=\"n\">pg_relation_size<\/span><span class=\"p\">(<\/span><span class=\"s1\">'mail_messages_gist'<\/span><span class=\"p\">))<\/span> <span class=\"k\">as<\/span> <span class=\"n\">gist<\/span><span class=\"p\">,<\/span>\n<span class=\"n\">fts<\/span><span class=\"o\">-#<\/span>              <span class=\"n\">pg_size_pretty<\/span><span class=\"p\">(<\/span><span class=\"n\">pg_relation_size<\/span><span class=\"p\">(<\/span><span class=\"s1\">'mail_messages_btree'<\/span><span class=\"p\">))<\/span> <span class=\"k\">as<\/span> <span class=\"n\">btree<\/span><span class=\"p\">;<\/span>\n  <span class=\"n\">gin<\/span>   <span class=\"o\">|<\/span>  <span class=\"n\">gist<\/span>  <span class=\"o\">|<\/span> <span class=\"n\">btree<\/span>  \n<span class=\"c1\">--------+--------+--------<\/span>\n <span class=\"mi\">189<\/span> <span class=\"n\">MB<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">111<\/span> <span class=\"n\">MB<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">526<\/span> <span class=\"n\">MB<\/span>\n<span class=\"p\">(<\/span><span class=\"mi\">1<\/span> <span class=\"k\">row<\/span><span class=\"p\">)<\/span>\n\n<span class=\"nb\">Time<\/span><span class=\"p\">:<\/span> <span class=\"mi\">2<\/span><span class=\"p\">.<\/span><span class=\"mi\">961<\/span> <span class=\"n\">ms<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u0632 \u0622\u0646\u062c\u0627 \u06a9\u0647 \u0634\u0627\u062e\u0635 GIN \u0641\u0636\u0627\u06cc \u0628\u06cc\u0634\u062a\u0631\u06cc \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc \u06a9\u0646\u062f \u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0647 \u062c\u0627\u06cc \u0634\u0627\u062e\u0635 Bitmap \u062f\u0631 \u0637\u06cc \u0641\u0631\u0622\u06cc\u0646\u062f \u0645\u0647\u0627\u062c\u0631\u062a \u0627\u0632 Oracle \u0628\u0647 PostgreSQL \u0627\u0632 \u0634\u0627\u062e\u0635 GIN \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645. \u0628\u0647 \u0637\u0648\u0631 \u06a9\u0644\u06cc \u060c \u0634\u0627\u062e\u0635 Bitmap \u0628\u0631\u0627\u06cc \u0632\u0645\u06cc\u0646\u0647 \u0647\u0627\u06cc\u06cc \u0628\u0627 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0628\u0633\u06cc\u0627\u0631 \u06a9\u0645\u06cc \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f \u060c \u06a9\u0647 \u0628\u0631\u0627\u06cc \u062c\u06cc\u0646 \u0646\u06cc\u0632 \u0628\u0633\u06cc\u0627\u0631 \u0645\u0624\u062b\u0631 \u0627\u0633\u062a. \u0639\u0644\u0627\u0648\u0647 \u0628\u0631 \u0627\u06cc\u0646 \u060c PostgreSQL \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0635\u0648\u0631\u062a \u067e\u0648\u06cc\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0647\u0631 \u0634\u0627\u062e\u0635 (\u0627\u0632 \u062c\u0645\u0644\u0647 \u062c\u06cc\u0646) \u06cc\u06a9 bitmap \u0628\u0633\u0627\u0632\u062f.<\/p>\n<p>\u0633\u0631\u0627\u0646\u062c\u0627\u0645 \u060c \u0645\u0627 \u06cc\u06a9 \u0628\u0633\u062a\u0631 \u0645\u0646\u0627\u0633\u0628 \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0642\u0631\u0627\u0631 \u062e\u062f\u0645\u0627\u062a \u0648\u0628 \u0631\u0627 \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645: <strong>\u062c\u0647\u0634<\/strong><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/media2.dev.to\/dynamic\/image\/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Ft077jzq50pgz03es8cch.png\" alt=\"\u0634\u0631\u062d \u062a\u0635\u0648\u06cc\u0631\" loading=\"lazy\" width=\"800\" height=\"181\" title=\"\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"%F0%9F%9A%80_%D8%A8%D8%A7_%D8%B2%D8%A8%D8%A7%D9%86_%D9%85%D9%88%D8%B1%D8%AF_%D8%B9%D9%84%D8%A7%D9%82%D9%87_%D8%AE%D9%88%D8%AF_%D8%A8%D8%B3%D8%A7%D8%B2%DB%8C%D8%AF\"><\/span>\n<p>  \ud83d\ude80 \u0628\u0627 \u0632\u0628\u0627\u0646 \u0645\u0648\u0631\u062f \u0639\u0644\u0627\u0642\u0647 \u062e\u0648\u062f \u0628\u0633\u0627\u0632\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u0627 \u0632\u062d\u0645\u062a \u062f\u0631 JavaScript \u060c Python \u060c Go \u06cc\u0627 Rust.  <\/p>\n<h3><span class=\"ez-toc-section\" id=\"%F0%9F%8C%8D_%D9%BE%D8%B1%D9%88%DA%98%D9%87_%D9%87%D8%A7%DB%8C_%D9%86%D8%A7%D9%85%D8%AD%D8%AF%D9%88%D8%AF_%D8%B1%D8%A7_%D8%A8%D9%87_%D8%B5%D9%88%D8%B1%D8%AA_%D8%B1%D8%A7%DB%8C%DA%AF%D8%A7%D9%86_%D9%85%D8%B3%D8%AA%D9%82%D8%B1_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \ud83c\udf0d \u067e\u0631\u0648\u0698\u0647 \u0647\u0627\u06cc \u0646\u0627\u0645\u062d\u062f\u0648\u062f \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0631\u0627\u06cc\u06af\u0627\u0646 \u0645\u0633\u062a\u0642\u0631 \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0641\u0642\u0637 \u0622\u0646\u0686\u0647 \u0631\u0627 \u06a9\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u062f \u0628\u067e\u0631\u062f\u0627\u0632\u06cc\u062f &#8211; \u0628\u062f\u0648\u0646 \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u060c \u0628\u062f\u0648\u0646 \u0647\u0632\u06cc\u0646\u0647.  <\/p>\n<h3><span class=\"ez-toc-section\" id=\"%E2%9A%A1_%D9%BE%D8%B1%D8%AF%D8%A7%D8%AE%D8%AA_%D8%A8%D9%87_%D8%B9%D9%86%D9%88%D8%A7%D9%86_%D8%B4%D9%85%D8%A7_%D8%8C_%D8%A8%D8%AF%D9%88%D9%86_%D9%87%D8%B2%DB%8C%D9%86%D9%87_%D9%87%D8%A7%DB%8C_%D9%BE%D9%86%D9%87%D8%A7%D9%86\"><\/span>\n<p>  \u26a1 \u067e\u0631\u062f\u0627\u062e\u062a \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0634\u0645\u0627 \u060c \u0628\u062f\u0648\u0646 \u0647\u0632\u06cc\u0646\u0647 \u0647\u0627\u06cc \u067e\u0646\u0647\u0627\u0646<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u062f\u0648\u0646 \u0647\u0632\u06cc\u0646\u0647 \u0628\u06cc\u06a9\u0627\u0631 \u060c \u0641\u0642\u0637 \u0645\u0642\u06cc\u0627\u0633 \u067e\u0630\u06cc\u0631\u06cc \u0628\u062f\u0648\u0646 \u062f\u0631\u0632.  <\/p>\n<p><img decoding=\"async\" src=\"https:\/\/media2.dev.to\/dynamic\/image\/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fbyu3wirwbp8t27m7hl5h.png\" alt=\"\u0634\u0631\u062d \u062a\u0635\u0648\u06cc\u0631\" loading=\"lazy\" width=\"800\" height=\"187\" title=\"\"><\/p>\n<p>\ud83d\udcd6 \u0627\u0633\u0646\u0627\u062f \u0645\u0627 \u0631\u0627 \u06a9\u0627\u0648\u0634 \u06a9\u0646\u06cc\u062f  <\/p>\n<p>\ud83d\udd39 \u0645\u0627 \u0631\u0627 \u062f\u0631 \u062a\u0648\u06cc\u06cc\u062a\u0631 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f: leapcellhq <\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Leapcell: \u0628\u0647\u062a\u0631\u06cc\u0646 \u0645\u06cc\u0632\u0628\u0627\u0646\u06cc \u0648\u0628 \u0628\u062f\u0648\u0646 \u0633\u0631\u0648\u0631 \u0634\u0627\u062e\u0635 \u0645\u0639\u06a9\u0648\u0633 \u0627\u0632 \u0641\u0646\u0627\u0648\u0631\u06cc \u0645\u0648\u062a\u0648\u0631 \u062c\u0633\u062a\u062c\u0648 \u0633\u0631\u0686\u0634\u0645\u0647 \u0645\u06cc \u06af\u06cc\u0631\u062f \u0648 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0633\u0646\u06af \u0628\u0646\u0627\u06cc \u0645\u0648\u062a\u0648\u0631\u0647\u0627\u06cc \u062c\u0633\u062a\u062c\u0648 \u062f\u0631 \u0646\u0638\u0631 \u06af\u0631\u0641\u062a\u0647 \u0634\u0648\u062f. \u0628\u0627 \u062a\u0634\u06a9\u0631 \u0627\u0632 \u0641\u0646\u0627\u0648\u0631\u06cc \u0634\u0627\u062e\u0635 \u0645\u0639\u06a9\u0648\u0633 \u060c \u0645\u0648\u062a\u0648\u0631\u0647\u0627\u06cc \u062c\u0633\u062a\u062c\u0648 \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0647 \u0637\u0648\u0631 \u0645\u0624\u062b\u0631 \u0639\u0645\u0644\u06cc\u0627\u062a\u06cc \u0645\u0627\u0646\u0646\u062f \u062c\u0633\u062a\u062c\u0648\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0648 \u062d\u0630\u0641 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u0646\u062f. \u0642\u0628\u0644 \u0627\u0632 \u062a\u0648\u0636\u06cc\u062d &hellip;<\/p>\n","protected":false},"author":2,"featured_media":108210,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-108209","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/108209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=108209"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/108209\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/108210"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=108209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=108209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=108209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}