databases

<p>Postgres as a search engine<br><a href="https://anyblockers.com/posts/postgres-as-a-search-engine" rel="nofollow" class="ellipsis" title="anyblockers.com/posts/postgres-as-a-search-engine"><span class="invisible">https://</span><span class="ellipsis">anyblockers.com/posts/postgres</span><span class="invisible">-as-a-search-engine</span></a><br><a href="https://news.ycombinator.com/item?id=41343814" rel="nofollow" class="ellipsis" title="news.ycombinator.com/item?id=41343814"><span class="invisible">https://</span><span class="ellipsis">news.ycombinator.com/item?id=4</span><span class="invisible">1343814</span></a></p><p>Build a retrieval system with semantic, full-text, &amp; fuzzy search in Postgres to be used as a backbone in RAG pipelines.</p><p>We’ll combine 3 techniques:</p><p>* full-text search with tsvector<br>* semantic search with pgvector<br>* fuzzy matching with pg_trgm</p><p>* bonus: BM25</p><p><a href="https://en.wikipedia.org/wiki/Okapi_BM25" rel="nofollow" class="ellipsis" title="en.wikipedia.org/wiki/Okapi_BM25"><span class="invisible">https://</span><span class="ellipsis">en.wikipedia.org/wiki/Okapi_BM</span><span class="invisible">25</span></a><br><a href="https://blog.paradedb.com/pages/elasticsearch_vs_postgres" rel="nofollow" class="ellipsis" title="blog.paradedb.com/pages/elasticsearch_vs_postgres"><span class="invisible">https://</span><span class="ellipsis">blog.paradedb.com/pages/elasti</span><span class="invisible">csearch_vs_postgres</span></a><br><a href="https://news.ycombinator.com/item?id=41173288" rel="nofollow" class="ellipsis" title="news.ycombinator.com/item?id=41173288"><span class="invisible">https://</span><span class="ellipsis">news.ycombinator.com/item?id=4</span><span class="invisible">1173288</span></a></p><p><a href="/tags/rdbms/" rel="tag">#RDBMS</a> <a href="/tags/postgres/" rel="tag">#postgres</a> <a href="/tags/postgresql/" rel="tag">#PostgreSQL</a> <a href="/tags/databases/" rel="tag">#databases</a> <a href="/tags/search/" rel="tag">#search</a> <a href="/tags/searchengine/" rel="tag">#SearchEngine</a> <a href="/tags/llm/" rel="tag">#LLM</a> <a href="/tags/rag/" rel="tag">#RAG</a> <a href="/tags/bm25/" rel="tag">#BM25</a></p>

<p>Hi California!<br><a href="/tags/victoriametrics/" rel="tag">#VictoriaMetrics</a> is proud to be a 🥇 Gold Sponsor at <a href="/tags/scale23x/" rel="tag">#Scale23x</a> 2026! <br>Dive into the world of <a href="/tags/opensource/" rel="tag">#OpenSource</a>, <a href="/tags/traces/" rel="tag">#traces</a>, <a href="/tags/observability/" rel="tag">#Observability</a>, time series &amp; logs <a href="/tags/databases/" rel="tag">#databases</a> with us.<br>📍 Pasadena | 🗓️ March 5-8<br><a href="/tags/techconference/" rel="tag">#TechConference</a> </p><p><a href="https://bit.ly/4amq55G" rel="nofollow"><span class="invisible">https://</span>bit.ly/4amq55G</a></p>

<p>New instance means introduction time. </p><p>I&#x27;ve been on the Fediverse since 2022 as well having been in various online communities since the late 80s.</p><p><a href="/tags/dad/" rel="tag">#Dad</a>, <a href="/tags/gamer/" rel="tag">#gamer</a>, <a href="/tags/skier/" rel="tag">#skier</a> (formerly volunteer <a href="/tags/skipatrol/" rel="tag">#skiPatrol</a> ), <a href="/tags/cancer/" rel="tag">#cancer</a> survivor (get your <a href="/tags/prostate/" rel="tag">#prostate</a> checked), degree in <a href="/tags/politicalscience/" rel="tag">#politicalScience</a>, career in <a href="/tags/it/" rel="tag">#IT</a>, <a href="/tags/databases/" rel="tag">#databases</a>, <a href="/tags/ramen/" rel="tag">#ramen</a> experimenter, <a href="/tags/union/" rel="tag">#union</a> member, <a href="/tags/geek/" rel="tag">#geek</a>, <a href="/tags/boardgamer/" rel="tag">#boardGamer</a>, <a href="/tags/nerd/" rel="tag">#nerd</a>, <a href="/tags/canadian/" rel="tag">#canadian</a></p><p>(Profile pic: Jackie Daytona, Just a regular human bartender)</p>