About

  • Avinash Vallarapu (Avi) is the CEO and Co-founder of MigOps, Inc. Before joining MigOps, Avi worked as a Global Services Lead and Product Owner for PostgreSQL services at Percona, Database Architect at OpenSCG and Dell. Avi has a great expertise on Migrations to PostgreSQL. He has a vast experience in technologies like Oracle, PostgreSQL, MySQL and MongoDB for the last 2 decades. He is an avid Python and Golang developer. He has 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 - 2017/2019
    • PGCON Ottawa 2018
    • Percona Live Frankfurt 2018
    • Postgres Conference New York 2019
    • Percona Live Texas 2019
    • Postgres Open Florida 2019
    • Postgres Conference Silicon Valley 2019
    • Percona Live Amsterdam 2019
    • PGCONF India 2020, New York, Percona Live and some more conferences.
  • His areas of expertise are PostgreSQL Migrations, Training and Consulting.


    Avinash Vallarapu Are databases on cloud DBaaS platforms really faster and cheaper as they are claimed ?
    Problems with scalability while migrating to PostgreSQL on DBaaS

    presented by Avinash Vallarapu

    • It is a known fact that Cloud vendors attract a lot of migrations to PostgreSQL. Managed infrastructure, database migration tools combined with zero software license are the strongest reasons for increased migrations to cloud. However, cloud vendors may promote their DBaaS platforms much more than their capabilities with scalability. Customers may not be aware of some technical limitations th...
    more

    Thu 7 2022 Ops
    Avinash Vallarapu Mostly mistaken and ignored PostgreSQL parameters while optimizing a PostgreSQL database

    presented by Avinash Vallarapu


    video

    Optimizing a PostgreSQL database may be a challenge if some of the important parameters are ignored. And a bigger challenge may be the understanding of the algorithm behind setting those parameters correctly. In my experience with PostgreSQL Consulting for more than a decade, I have seen a bigger list of parameters that are wrongly set or ignored. This talk details a list of important PostgreSQ...

    more

    Tue 16 2020 Ops
    Avinash Vallarapu PostgreSQL Indexes and Automatic Index Recommendations
    Performance Tuning

    presented by Avinash Vallarapu

    • PostgreSQL supports a wide variety of indexes. While most of them are common in almost all the databases, there are some types of indexes that are more specific to PostgreSQL.

    • Once we know what type of Indexes are suitable for our requirement, should we create an index physically or can we use a hypothetical index that is imaginary to the Optimizer. If that is possible, are there any ext...

    more

    Ops and Administration
    Avinash Vallarapu High Availability and Automatic Failover in PostgreSQL.
    PostgreSQL High Availability

    presented by Avinash Vallarapu

    • PostgreSQL is an advanced open source database that is completely community driven. Continuous development and performance improvements while making it feature rich gave PostgreSQL a great market penetration. When a database server is deployed in production, it is important to achieve several 9's of availability. It starts with a replication setup that is stable and some tool that could manag...
    more

    Ops and Administration
    Avinash Vallarapu A detailed understanding of MVCC and Autovacuum Internals in PostgreSQL.
    MVCC and Autovacuum Internals

    presented by Avinash Vallarapu

    • PostgreSQL implements MVCC in a slightly different way when compared to databases like Oracle, MySQL and others. In PostgreSQL, there is a different method for managing UNDO that requires a cleanup concept called vacuum. Over a period of time, PostgreSQL implemented autovacuum that has been enhanced with every release. It is now important for PostgreSQL admins/DevOPS to understand the interna...
    more

    Ops and Administration
    Avinash Vallarapu Mostly mistaken and ignored PostgreSQL parameters while optimizing a PostgreSQL database
    Performance Tuning

    presented by Avinash Vallarapu

    • Optimizing a PostgreSQL database may be a challenge if some of the important parameters are ignored. And a bigger challenge may be the understanding of the algorithm behind setting those parameters correctly. In my experience with PostgreSQL Consulting for more than a decade, I have seen a bigger list of parameters that are wrongly set or ignored. This talk details a list of important Postgre...
    more

    Ops and Administration
    Avinash Vallarapu Upgrading a PostgreSQL database from a legacy to newer version with no downtime.
    PostgreSQL Upgrades with no downtime

    presented by Avinash Vallarapu

    • It is very important to know a fact that PostgreSQL community does not support bug fixes and security fixes for older PostgreSQL versions. Currently, community only supports PostgreSQL versions starting from 9.4. So, if your database server is on 9.3 or older, you would see no bug fixes or security patches. Several benchmarks proves that the performance of a PostgreSQL database increases with...
    more

    Ops and Administration
    Avinash Vallarapu High Availability and Automatic Failover in PostgreSQL
    High Availaibilty

    presented by Avinash Vallarapu

    • PostgreSQL is an advanced open source database that is completely community driven. Continuous development and performance improvements while making it feature rich gave PostgreSQL a great market penetration. When a database server is deployed in production, it is important to achieve several 9's of availability. It starts with a replication setup that is stable and some tool that could manag...
    more

    Fri 20 2019 Ops and Administration
    Avinash Vallarapu Mostly mistaken and ignored PostgreSQL parameters while optimizing a PostgreSQL database
    Tuning PostgreSQL parameters

    presented by Avinash Vallarapu

    • *Abstract : *

      • Optimizing a PostgreSQL database may be a challenge if some of the important parameters are ignored. And a bigger challenge may be the algorithm behind setting those parameters correctly. In my experience with PostgreSQL Consulting for more than a decade, I have seen a bigger list of parameters that are wrongly set or ignored. This talk details a list of important Postg...
    more

    Fri 20 2019 Ops and Administration
    Avinash Vallarapu 400% performance improvement after tuning these PostgreSQL parameters
    PostgreSQL Performance Tuning

    presented by Avinash Vallarapu

    • *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 environm...
    more

    Fri 22 2019 Use Cases
    Avinash Vallarapu Introduction to PostgreSQL for Oracle and MySQL DBAs
    PostgreSQL Tutorial

    presented by Avinash Vallarapu


    Abstract

    • This tutorial is focused on teaching PostgreSQL to professionals that are already experienced with Oracle or MySQL. As we discuss from basics, even a beginner may adapt the concepts easily. Relational databases share a lot of similar concepts. You may find it easier if we help you relate the concepts of PostgreSQL with Oracle/MySQL. Thus, we would start with PostgreSQL A...
    more

    Mon 18 2019 Ops and Administration