PostgreSQL: Pushing the limits on a single machine
Schedule

Presented by:

0134d94401bf6997c3f513a24e758a81

Ashu Pachauri

from Clarisights

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

Happening at the same time:

  1. Sharding in PostgreSQL
    2. Start Time:
    2020 February 28 11:00

    Room:
    Robusta + Arabica

  2. Top 10 Mistakes When Migrating From Oracle to PostgreSQL
    3. Start Time:
    2020 February 28 11:00

    Room:
    Grand Victoria 1