Tag: tag

PostgreSQL Scaling: What OpenAI Proved Wrong at 800M Users

Posted on by Sanjeeva Kumar

By Sanjeeva Kumar | Senior Oracle DBA & Database ArchitectPublished: February 2026 | Reading time: 8 minutes The Scaling Advice That’s Costing You Millions OpenAI is running 800 million ChatGPT users on unsharded PostgreSQL. One primary writer per cluster. 50+ read replicas. No Cassandra. No sharding. Just PostgreSQL — properly governed. Sound familiar? It shouldn’t. Read more about PostgreSQL Scaling: What OpenAI Proved Wrong at 800M Users[…]

PostgreSQL synchronous master-slave replication — master waits for slave ACK via remote_apply

Data Replication Setup Using Master and Slave: PostgreSQL- IV

Posted on by Sanjeeva Kumar

In this final blog of our PostgreSQL synchronous replication setup series, we close the loop on Master-Slave replication — and we save the best for last. Through the previous three blogs, we built our foundation, configured the async node, and watched streaming replication come alive. Async worked beautifully — but async also means the master Read more about Data Replication Setup Using Master and Slave: PostgreSQL- IV[…]

Data Replication Setup Using Master and Slave: PostgreSQL – I

Posted on by Sanjeeva Kumar

Setting up high availability in PostgreSQL requires a master-slave replication environment where the slave takes over if the master fails. This post covers the architecture design. In next few blogs we will explore how High Availability(HA) will be setup. This is Part 1 of a 4-part series on PostgreSQL replication In this blog we will Read more about Data Replication Setup Using Master and Slave: PostgreSQL – I[…]