# @dataengineeringtamil on Instagram

- **Type:** Video
- **Original URL:** https://www.instagram.com/p/DTu8sDukgF5
- **Gondola URL:** https://gondola.cc/posts/63366122-dataengineeringtamil-instagram
- **Thumbnail:** https://img.gondola.cc/tr:w-,h-,fo-auto/postThumbnails/123f03fee9.jpg
- **Posted:** 2026-01-20T13:07:56.000+00:00
- **Account Owner:** Data Engineering Tamil (@dataengineeringtamil) — https://gondola.cc/dataengineeringtamil

## Caption

Postgres la large scale possible ah? nu yosikkura ellarukkum…

Figma sollra answer: Definitely YES! 💪
40 Million+ users ah Postgres vechu handle pannudhu na,
adhu luck illa,
correct system design.
Figma eppadi scale pannina-nu paarpom 👇

1️⃣ Read Replicas
Primary DB = writes mattum
Replica DB = reads mattum
App la irundhu varra read load full-aa replicas mela pogum.
Result?
Primary pressure kammi, response time fast.

2️⃣ PgBouncer
Thousands of users = thousands of DB connections 😵
Direct-aa Postgres connect panna, DB down aagum.
So PgBouncer use pannuvaanga.
Idhu connection pooler.
Connections kammi, performance high.

3️⃣ Vertical Partitioning
Single DB la ellaa tables vechaa, chaos 😅
So domain-wise split pannuvaanga:
Files DB, Orgs DB, Comments DB.
Each DB-ku own responsibility.
Maintain pannradhum easy, query fast.

4️⃣ Horizontal Sharding
Table romba perusa aagumbodhu,
Rows ah split pannuvaanga.
User_id hash panni different shard-ku route.
Result?
Data evenly distribute, bottleneck illa.

5️⃣ Logical Sharding
Direct-aa physical split panna risky.
So first VIEW use panni logical sharding.
Production la test pannala madhiri feel.
Problem irundhaa easy-aa rollback.

6️⃣ Physical Sharding
Logical replication use panni,
Data new shards-ku migrate pannuvaanga.
Almost zero downtime.
10 seconds migration nu sollra alavukku fast.

Bottom line:
Postgres “small company DB” illa.
Correct design irundhaa,
Idhu enterprise-level monster 😎
Save pannunga, share pannunga,

Database & System Design lovers-ku must post 🔥
#Postgres #SystemDesign #DatabaseScaling #DataEngineeringtamil  #BackendDev Figma TechTamil Tanglish Developers

## Stats

- **Views:** 9,319
- **Likes:** 290
- **Shares:** 0
- **Comments:** 3

## Tags

backenddev, postgres, systemdesign, dataengineeringtamil, databasescaling

---
Copyright (c) Gondola