Presented by:

E50d72bbea36635af4836531b02f6d08

Srinivasarao Oguri

from Arcesium

Srinivasarao Oguri is a Database Engineer with 11+ years of working experience in PostgreSQL, Oracle and other database technologies. He is working with Arcesium as a Database Engineer and majorly focus on cost optimization, database performance. Srinivas worked with EDB/OpenText/TCS for 7 years.

Checkout the slides

About us:

Arcesium is an advanced data, operations and analytics platform managing $675B+ assets for world's most sophisticated asset managers and financial services organizations and we are backed by D.E.Shaw group, Blackstone Alternative Asset management and J.P.Morgan.

Abstract:

PostgreSQL, the most advanced open source database, has become our go-to relational database for all new-gen applications and also target for migrations.

  1. We are here to share our experiences with PostgreSQL and how we evolved from running a couple of RDS PostgreSQL test instances to hundreds of Aurora PostgreSQL production instances at scale with TBs of data and billions of IOPS per day and why we are now migrating from Aurora PostgreSQL to community PostgreSQL (in EC2 instances).

  2. We will share how we managed to save hundreds of thousands of dollars by constantly evaluating new features and how we built automation to significantly improve developer experience while saving hundreds of hours of time spent on operations.

  3. We will also walk you through our learnings running PostgreSQL in cloud (i.e incidents) and how we responded to them with the help of the community.

Last but not least, we want to keep you entertained throughout the session while sharing our insights

Date:
2023 February 23 - 11:30
Duration:
45 min
Room:
Grand Victoria 2
Conference:
PGConf India, 2023
Language:
Track:
Case Study
Difficulty:
Easy

Happening at the same time:

  1. Performance use cases and best practices - PL/pgSQL code conversion
  2. Start Time:
    2023 February 23 11:30

    Room:
    Robusta + Arabica

  3. Understanding and Fixing Autovacuum
  4. Start Time:
    2023 February 23 11:30

    Room:
    Grand Victoria 1