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, bottl...
Suggested Credits
Tags, Events, and Projects