Deep dive of usage of Postgres in Zerodha and our learnings
Presented by:
Satyajit Sarangi
from
Developer at Zerodha
I'm a developer at Zerodha, since 2015, and been responsible for much of the backend processes done at Zerodha: number crunching for pnl, portfolio computations, database management, and a bit more.
Checkout the slides
A presentation on how we use Postgres at Zerodha and our learnings:
- How we sharded our db (or why we never did for the longest time)
- Learnings on many how-tos when creating schemas for us.
- Specific usecases where Postgres "just worked" where the likes of mysql didn't.
- How we improved query performances by database tuning and using materialized views.
- Using postgres as caching layer where we create millions of tables.
- Date:
- 2023 February 23 - 14:00
- Duration:
- 45 min
- Room:
- Grand Victoria 2
- Conference:
- PGConf India, 2023
- Language:
- Track:
- Case Study
- Difficulty:
- Medium
- Requires Registration:
- Yes (Registered: 0)
- How to identify and tune PostgreSQL performance issues using wait events
- Start Time:
- 2023 February 23 14:00
- Room:
- Robusta + Arabica
- Journey of the DML queries
- Start Time:
- 2023 February 23 14:00
- Room:
- Grand Victoria 1