PostgreSQL: Pushing the limits on a single machine
Presented by:

Ashu Pachauri
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.
Download slides
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.
- Date:
- 2020 February 28 - 11:00
- Duration:
- 40 min
- Room:
- Grand Victoria 2
- Conference:
- PGConf India, 2020
- Language:
- Track:
- Case Study
- Difficulty:
- Medium
- Sharding in PostgreSQL
- Start Time:
- 2020 February 28 11:00
- Room:
- Robusta + Arabica
- Top 10 Mistakes When Migrating From Oracle to PostgreSQL
- Start Time:
- 2020 February 28 11:00
- Room:
- Grand Victoria 1