{"id":40677,"date":"2026-02-28T14:56:00","date_gmt":"2026-02-28T11:56:00","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/"},"modified":"2026-02-28T14:56:00","modified_gmt":"2026-02-28T11:56:00","slug":"timescale-pg_textsearch-postgresql-metin-arama-motoru","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/","title":{"rendered":"timescale\/pg_textsearch &#8211; PostgreSQL Metin Arama Motoru"},"content":{"rendered":"<h2>PostgreSQL Metin Arama Motoru<\/h2>\n<p style=\"text-align:center\"><img decoding=\"async\" src=\"https:\/\/fatihsoysal.com\/data\/images\/timescale-pg_textsearch.png\" alt=\"PostgreSQL Metin Arama Motoru\" style=\"max-width:100%;height:auto\" \/><\/p>\n<p>Bu proje, PostgreSQL veritabanlar\u0131 i\u00e7in geli\u015fmi\u015f bir metin arama yetene\u011fi sunar. BM25 algoritmas\u0131n\u0131 kullanarak y\u00fcksek performansl\u0131 ve ilgili arama sonu\u00e7lar\u0131 sa\u011flar. \u00d6zellikle WAND optimizasyonu sayesinde b\u00fcy\u00fck veri k\u00fcmelerinde bile h\u0131zl\u0131 ve verimli aramalar yap\u0131lmas\u0131na olanak tan\u0131r. Metin tabanl\u0131 verileri PostgreSQL&#8217;de depolayan ve h\u0131zl\u0131, alakal\u0131 arama fonksiyonelli\u011fi arayan geli\u015ftiricilere y\u00f6neliktir.<\/p>\n<p><strong>GitHub:<\/strong> <a href=\"https:\/\/github.com\/timescale\/pg_textsearch\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/github.com\/timescale\/pg_textsearch<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"Bu proje, PostgreSQL veritabanlar\u0131 i\u00e7in geli\u015fmi\u015f bir metin arama yetene\u011fi sunar.","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[1816],"tags":[],"class_list":{"0":"post-40677","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-github-repo-radar","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>timescale\/pg_textsearch - PostgreSQL Metin Arama Motoru - Kodlar\u0131n Gizemli D\u00fcnyas\u0131<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"timescale\/pg_textsearch - PostgreSQL Metin Arama Motoru\" \/>\n<meta property=\"og:description\" content=\"Bu proje, PostgreSQL veritabanlar\u0131 i\u00e7in geli\u015fmi\u015f bir metin arama yetene\u011fi sunar.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2026-02-28T11:56:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/fatihsoysal.com\/data\/images\/timescale-pg_textsearch.png\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"timescale\/pg_textsearch &#8211; PostgreSQL Metin Arama Motoru\",\"datePublished\":\"2026-02-28T11:56:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/\"},\"wordCount\":87,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"image\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fatihsoysal.com\/data\/images\/timescale-pg_textsearch.png\",\"articleSection\":[\"Github Repo Radar\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/#respond\"]}],\"copyrightYear\":\"2026\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/\",\"name\":\"timescale\/pg_textsearch - PostgreSQL Metin Arama Motoru - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fatihsoysal.com\/data\/images\/timescale-pg_textsearch.png\",\"datePublished\":\"2026-02-28T11:56:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/#primaryimage\",\"url\":\"https:\/\/fatihsoysal.com\/data\/images\/timescale-pg_textsearch.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/data\/images\/timescale-pg_textsearch.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"timescale\/pg_textsearch &#8211; PostgreSQL Metin Arama Motoru\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"timescale\/pg_textsearch - PostgreSQL Metin Arama Motoru - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/","og_locale":"tr_TR","og_type":"article","og_title":"timescale\/pg_textsearch - PostgreSQL Metin Arama Motoru","og_description":"Bu proje, PostgreSQL veritabanlar\u0131 i\u00e7in geli\u015fmi\u015f bir metin arama yetene\u011fi sunar.","og_url":"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2026-02-28T11:56:00+00:00","og_image":[{"url":"https:\/\/fatihsoysal.com\/data\/images\/timescale-pg_textsearch.png","type":"","width":"","height":""}],"author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"timescale\/pg_textsearch &#8211; PostgreSQL Metin Arama Motoru","datePublished":"2026-02-28T11:56:00+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/"},"wordCount":87,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"image":{"@id":"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/#primaryimage"},"thumbnailUrl":"https:\/\/fatihsoysal.com\/data\/images\/timescale-pg_textsearch.png","articleSection":["Github Repo Radar"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/#respond"]}],"copyrightYear":"2026","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/","url":"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/","name":"timescale\/pg_textsearch - PostgreSQL Metin Arama Motoru - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/#primaryimage"},"image":{"@id":"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/#primaryimage"},"thumbnailUrl":"https:\/\/fatihsoysal.com\/data\/images\/timescale-pg_textsearch.png","datePublished":"2026-02-28T11:56:00+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/#primaryimage","url":"https:\/\/fatihsoysal.com\/data\/images\/timescale-pg_textsearch.png","contentUrl":"https:\/\/fatihsoysal.com\/data\/images\/timescale-pg_textsearch.png"},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/timescale-pg_textsearch-postgresql-metin-arama-motoru\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"timescale\/pg_textsearch &#8211; PostgreSQL Metin Arama Motoru"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/40677","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=40677"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/40677\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=40677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=40677"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=40677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}