---
title: "Discussion on \"You Probably Don't Need Elasticsearch: Building a Fast, Typo-Tolerant Search Engine in PostgreSQL\" | Hashnode"
description: "Discussion on \"You Probably Don't Need Elasticsearch: Building a Fast, Typo-Tolerant Search Engine in PostgreSQL\". How to combine partial GIN trigram indexes, generated tsvectors, and weighted CTEs in Postgres to build a production search engine that runs under 15ms without the infrastructure headache."
url: "https://hashnode.com/posts/you-probably-dont-need-elasticsearch-building-a-fast-typo-tolerant-search-engine-in-postgresql/6abcf5c9344f84948092dc7f"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [You Probably Don't Need Elasticsearch: Building a Fast, Typo-Tolerant Search Engine in PostgreSQL](https://blog.zyvop.com/you-probably-dont-need-elasticsearch-building-a-fast-typo-tolerant-search-engine-in-postgresql?utm_source=hashnode&utm_medium=feed)

How to combine partial GIN trigram indexes, generated tsvectors, and weighted CTEs in Postgres to build a production search engine that runs under 15ms without the infrastructure headache.

Sep 30 · 14 min read · blog.zyvop.com  
Read the article

-   [#architecture](https://hashnode.com/tag/architecture)
-   [#database](https://hashnode.com/tag/database)
-   [#performance](https://hashnode.com/tag/performance)
-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#sql](https://hashnode.com/tag/sql)

## Written by

[ZyVOP](https://hashnode.com/@zyvop)

@zyvop · Delhi, India

  
[View profile](https://hashnode.com/@zyvop)

The Developer Publishing Hub

One platform to write, cross-post to Dev.to, Medium, WordPress, Hashnode, and Bluesky, and protect your SEO with canonical links. Zero paywalls and full content ownership.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
