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

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

Update: 2025-03-07
Share

Description

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.

Comments 
00:00
00:00
x

0.5x

0.8x

1.0x

1.25x

1.5x

2.0x

3.0x

Sleep Timer

Off

End of Episode

5 Minutes

10 Minutes

15 Minutes

30 Minutes

45 Minutes

60 Minutes

120 Minutes

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

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

Jason Swett