251 - Databases at Scale with Prarthana Shiva, Sin City Ruby 2025 Speaker

In this episode of Code with Jason, host Jason Swett interviews
Prarthana Shiva, a senior software engineer at NexHealth, who
shares how her team is handling massive database scaling
challenges. Prarthana explains their PostgreSQL database's growth
to 24 terabytes (with projections to triple within a year) and
details their innovative solutions including read replicas,
Elasticsearch implementation, Redis caching, external write-ahead
logs, and optimized vacuuming processes. The conversation also
touches on Jason's own database challenges with his CI platform
and concludes with Prarthana's upcoming presentation at Sin City
Ruby 2025, where she'll discuss their transition from
schema-based to row-based multi-tenancy for better scalability.


Prarthana Shiva on LinkedIn

Sin City Ruby