facebook pixel
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...

 34.3k

 290

 3

 34.3k

    Suggested Credits
    Tags, Events, and Projects