Presented by:

  • Avinash Vallarapu (Avi) is the CEO and Founder of HexaCluster, a company specialized in Database Migrations, PostgreSQL Consulting, Application Migrations and Modernizations, and AI/ML Services. Before creating HexaCluster, Avi was the CEO and Co-founder of MigOps, specialized in database migrations to PostgreSQL. He created the PostgreSQL practice at Percona as a Global Services Lead and Product Owner, and worked as a Database Architect at OpenSCG and Dell. With a vast experience in technologies like Oracle, PostgreSQL, MySQL and MongoDB for the last 2 decades, Avi had co-authored multiple books on PostgreSQL : Beginning PostgreSQL on Cloud and PostgreSQL 13 Cookbook.

  • He spoke at various PostgreSQL Conferences in the past including -

    • PGCONF India
    • PGCON Ottawa
    • Percona Live Frankfurt
    • Postgres Conference New York
    • Percona Live Texas
    • Postgres Open Florida
    • Postgres Conference Silicon Valley
    • Percona Live
    • GITEX Global
    • and some more conferences.
  • His areas of expertise are PostgreSQL Migrations, Training and Consulting.

No video of the event yet, sorry!

  • *Abstract : *

  • In the proposal, I would like to share how we have optimized a few database parameters that did outburst the performance by several times. It was a PostgreSQL Server of size 325 GB and more than 1500 TPS. After our tuning, we were able to get the database process upto 4900 TPS without compromising on ACID or availability.

  • ** The talk includes : **

    • The environment where we have seen disastrous performance.
    • The parameters we concentrated for tuning and why ?
    • The way we analyzed the active data set and optimized many more parameters in run time
    • Answers to questions like :
    • Does my active data set fits in memory ?
    • Should I increase work_mem ?
    • Is WAL compression working to my advantage ?
    • How far should I have checkpoints spread ?
    • By the end of this talk, you should know what parameters you should tune in PostgreSQL and when.

Date:
2019 March 22 14:00 EDT
Duration:
50 min
Room:
Riverside Suite
Conference:
Postgres Conference
Language:
Track:
Use Cases
Difficulty:
Medium