Presented by:

49dd872b1d6dcb04750fbdf2d1fc9277

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:

  1. How we sharded our db (or why we never did for the longest time)
  2. Learnings on many how-tos when creating schemas for us.
  3. Specific usecases where Postgres "just worked" where the likes of mysql didn't.
  4. How we improved query performances by database tuning and using materialized views.
  5. 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)

Happening at the same time:

  1. How to identify and tune PostgreSQL performance issues using wait events
  2. Start Time:
    2023 February 23 14:00

    Room:
    Robusta + Arabica

  3. Journey of the DML queries
  4. Start Time:
    2023 February 23 14:00

    Room:
    Grand Victoria 1