PostgreSQL: Pushing the limits on a single machine
Ashu is the CTO at Clarisights which is a fast evolving SaaS platform offering realtime, interactive and contextual analytics for performance marketers. He is involved in solving the scalability challenges at Clarisights. Before Clarisights, Ashu used to build databases in Facebook's core data team and is an official Apache HBase committer.
No video of the event yet, sorry!
With more than 2 billion writes and 400 billion records read per day on a single machine, this talk is the story of how we, at Clarisights, scaled a single PostgreSQL instance more than 50x in last one year.
I'll outline the approaches we took to scale our use case on PostgreSQL, including how we identified and implemented the avenues for scaling both reads and writes, sequential and random.
- 40 min
- PGConf India, 2020
- Case Study