Database Tuning at Zerodha - India's Largest Stock Broker

Perfology
Perfology
90,761
0
Published 2024-07-07
Step into the world of Zerodha, India's largest stock broker, and uncover the secrets behind their database tuning and optimization techniques. In this exclusive video, we'll take you through:

Advanced Database Optimization Techniques: Learn how Zerodha keeps their databases running at peak performance.
Performance Tuning Insights: Discover real-world strategies and best practices from the experts at Zerodha.
Scalability Solutions: See how Zerodha handles massive data loads and ensures reliability for millions of users.

Whether you're a tech enthusiast, database professional, or just curious about the technology driving the stock market, this video is packed with valuable insights and practical tips to help you optimize your own databases.

Video Credit : ‪@pgconfin‬

🔔 Subscribe to our channel for more tech tips and tutorials:
👍 Like us on Facebook : www.facebook.com/perfology
👍 Add us on Instagram: www.instagram.com/perfologys/
👍 Follow us on Linkedin: www.linkedin.com/in/perfology/

#DatabaseTuning #Zerodha #StockBroker #DatabaseOptimization #TechTutorial #PerformanceTuning #SQL #DatabaseManagement #techinnovation

Chapters
00:00 Introduction
02:59 History Of Postgres usage
07:54 Managing Big Data
14:40 Understanding your query planner
20:38 Replica Master Slave
29:10 Postgres DB Rights
31:18 Postgres Learnings
39:16 Problems with Post
All Comments (21)
  • @mzs114
    Boring tech is usually better in most cases.
  • @pankajsharma-cb4ok
    By listening to it, I got to know that I also faced similar issues and worked on similar set of solutions except materialised views and redis. Happy to see myself on same path...
  • @haloboy777
    Sensible defaults go a long way, but they only work in certain scenarios. I commend their choice of sticking to the basics. To be honest, their main engineering efforts are focused on rewriting their codebase, and I believe that is their core competency. I wish more companies allowed frequent rewrites [where needed].
  • @TheBrahmadath
    So finally found the responsible guy for the recent backend glitch..
  • @manishmundra7303
    No doubt this is a gem talk.. Though I feel slides could be done much better with the kind of content talk had.. Still learned a lot & cheers to this great talk!!
  • @codingwithsam4992
    These are the guys and their content which people should be consuming and not those of LinkedIn didis
  • @CoppsMusic
    Zerodha sits on top of SEBI's tech APIs. God, One has to listen from SEBI on how their orchestration is.