28 subscribers
با برنامه Player FM !
پادکست هایی که ارزش شنیدن دارند
حمایت شده
251 - Databases at Scale with Prarthana Shiva, Sin City Ruby 2025 Speaker
Manage episode 470202540 series 2543897
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.
فصل ها
1. Sin City Ruby Conference Announcement (00:00:00)
2. Introduction with Prathna Shiva (00:03:30)
3. Scaling a 24TB Database (00:05:17)
4. Read Replicas and Database Anti-Patterns (00:08:30)
5. Caching Strategies and Performance Optimization (00:20:44)
6. Write-Ahead Logs and Storage Architecture (00:24:24)
7. Vacuuming and Database Maintenance (00:32:31)
8. Sin City Ruby Speaking Engagement (00:43:08)
268 قسمت
Manage episode 470202540 series 2543897
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.
فصل ها
1. Sin City Ruby Conference Announcement (00:00:00)
2. Introduction with Prathna Shiva (00:03:30)
3. Scaling a 24TB Database (00:05:17)
4. Read Replicas and Database Anti-Patterns (00:08:30)
5. Caching Strategies and Performance Optimization (00:20:44)
6. Write-Ahead Logs and Storage Architecture (00:24:24)
7. Vacuuming and Database Maintenance (00:32:31)
8. Sin City Ruby Speaking Engagement (00:43:08)
268 قسمت
همه قسمت ها
×
1 261 - Abstraction and Emergence with Jorge Manrubia 1:06:12

1 258 - Errol Schmidt, CEO of reinteractive 1:04:48

1 257 - Colleen Schnettler, Creator of HelloQuery 1:03:01

1 256 - Dave Farley, Author of Modern Software Engineering 1:08:49

1 254 - Amanda Perino, Executive Director of The Rails Foundation 1:12:28

1 253 - Dave Thomas, Author of The Pragmatic Programmer and Sin City Ruby 2025 Keynote Speaker 1:27:12

1 252 - What is Good Code? with Jerad Gallinger 1:10:10

1 250 - Nick Schwaderer 1:08:14
به Player FM خوش آمدید!
Player FM در سراسر وب را برای یافتن پادکست های با کیفیت اسکن می کند تا همین الان لذت ببرید. این بهترین برنامه ی پادکست است که در اندروید، آیفون و وب کار می کند. ثبت نام کنید تا اشتراک های شما در بین دستگاه های مختلف همگام سازی شود.