38Ship a risky schema change to a 2 TB Postgres primary with near-zero downtime. How does that actually work?▼hard★ EssentialNewPhonePeStripeLinkedIn◆ premiumBlue-green works for stateless apps because instances are disposable. Databases are shared state, so safe migrations ride on backward compatibility and an explicit rollback boundary.Open full answer →
13Checkout is failing with 'connection pool exhausted', but the database CPU sits at 10 percent. Where is the problem?▼mediumNewFlipkartRazorpayWalmart Global Tech○ sign inAn idle database with a starved application is the tell. The connections are held, not used. More database capacity does not release leaked connections.Open full answer →
18Postgres is out of headroom. How do you choose a shard key, and how do you reshard later without downtime?▼hard★ EssentialNewPhonePeFlipkartUber○ sign inSharding buys write headroom and bills you in joins, foreign keys, and every future migration. The key choice is a query-pattern bet; the resharding choreography separates operators from diagram artists.Open full answer →
13Your Postgres bill tripled because three years of data live on one hot volume. How do you tier storage without breaking queries?▼hardNewAmazon & AWSSnowflakeFlipkart○ sign inMost of your rows are read rarely and cost the same as the ones read constantly. Tiering pays for itself only when access patterns are honest, which is why the audit comes before the architecture.Open full answer →
