28 subscribers
Chuyển sang chế độ ngoại tuyến với ứng dụng Player FM !
Podcast đáng để nghe
TÀI TRỢ BỞI


1 Dave Ramsey: 5 Stages to Build and Scale a Business That Lasts | Entrepreneurship | E344 1:03:38
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.
Chương
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)
258 tập
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.
Chương
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)
258 tập
すべてのエピソード
×
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 251 - Databases at Scale with Prarthana Shiva, Sin City Ruby 2025 Speaker 45:08

1 249 - Neeraj Singh, Founder and CEO of BigBinary and Neeto 56:20

1 248 - Ryan Kulp, Founder of TRMNL 1:04:24

1 247 - Steven R. Baker, Creator of RSpec 1:40:44

1 245 - Irina Nazarova, CEO of Evil Martians and Sin City Ruby 2025 Speaker 1:24:14

1 244 - Jeff Dwyer, Founder & CEO at Prefab 1:02:38

1 243 - Johanna Rothman, Author and Consultant 1:17:52

1 242 - John DeSilva, CTO at Revela 1:09:24

1 241 - Freedom Dumlao, Sin City Ruby 2025 Speaker 1:03:04

1 240 - JP Camara, Principal Software Engineer at Wealthbox 1:06:34

1 239 - Artur Trzop, Co-Founder & COO of Knapsack Pro 54:56
Chào mừng bạn đến với Player FM!
Player FM đang quét trang web để tìm các podcast chất lượng cao cho bạn thưởng thức ngay bây giờ. Đây là ứng dụng podcast tốt nhất và hoạt động trên Android, iPhone và web. Đăng ký để đồng bộ các theo dõi trên tất cả thiết bị.