---
title: "Discussion on \"[PostgreSQL Scaling and Optimization] How to search on 10 GB data (1 million rows) within 5 ms?\" | Hashnode"
description: "Discussion on \"[PostgreSQL Scaling and Optimization] How to search on 10 GB data (1 million rows) within 5 ms?\". Warning\n\nThis article will help you to make a full text search API on PostgreSQL - a kind of text and retrieval problem.\n\nNowadays, in large-scale system, people usually decouple write-heavy DB and read-heavy DB, not one for all. Example: using Postg..."
url: "https://hashnode.com/posts/postgresql-scaling-and-optimization-how-to-search-on-10-gb-data-1-million-rows-within-5-ms/658ebec3af8780458faaa838"
---

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

Discussion

# [\[PostgreSQL Scaling and Optimization\] How to search on 10 GB data (1 million rows) within 5 ms?](https://leonardkieu.hashnode.dev/postgresql-scaling-and-optimization-how-to-search-on-10-gb-data-1-million-rows-within-5-ms?utm_source=hashnode&utm_medium=feed)

Warning This article will help you to make a full text search API on PostgreSQL - a kind of text and retrieval problem. Nowadays, in large-scale system, people usually decouple write-heavy DB and read-heavy DB, not one for all. Example: using Postg...

Dec 29, 2023 · 7 min read · leonardkieu.hashnode.dev  
Updated Jan 4, 2024  
Read the article

-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#scalability](https://hashnode.com/tag/scalability)
-   [#django](https://hashnode.com/tag/django)
-   [#database-partitioning](https://hashnode.com/tag/database-partitioning)
-   [#full-text-search](https://hashnode.com/tag/full-text-search)

## Written by

[Dinh Kieu (Leon)](https://hashnode.com/@leonardkieu)

@leonardkieu

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

IT platform engineer

I am a lifelong learner. In career, I'm a Computer science engineer, focusing on Platform engineering, Distributed System, Backend development &amp; Big data. In life, I'm a simple-organic manifestation of writer, poet, amateur singer, runner athlete, spiritual-truth-seeker. I'm a bookworm, a big fan of Krishnamurti, Carl Jung, Ichikawa Takuji, Faraday, Newton, Buddha, Nam Cao... As the whole we are, I commit to consistently engage &amp; contribute to the world forward. This page is my content creator world, somewhat crazy and unpopular. Nice to meet &amp; entertain you!

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
