No upcoming presentations...

    Are databases on cloud DBaaS platforms really faster and cheaper as they are claimed ?

    Problems with scalability while migrating to PostgreSQL on DBaaS

    • 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...

    @ Silicon Valley 2022
    Avinash Vallarapu

    Apr 7 2022

    Ops

    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...

    @ Postgres Webinar Series
    Avinash Vallarapu

    Jun 16 2020

    Ops

    • 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...

    @ Postgres Conference 2020
    Avinash Vallarapu
    Ops and Administration

    • 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...

    @ Postgres Conference 2020
    Avinash Vallarapu
    Ops and Administration

    • 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...

    @ Postgres Conference 2020
    Avinash Vallarapu
    Ops and Administration

    • 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...

    @ Postgres Conference 2020
    Avinash Vallarapu
    Ops and Administration

    • 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...

    @ Postgres Conference 2020
    Avinash Vallarapu
    Ops and Administration

    • 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...

    @ Silicon Valley 2019
    Avinash Vallarapu

    Sep 20 2019

    Ops and Administration

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

    @ Silicon Valley 2019
    Avinash Vallarapu

    Sep 20 2019

    Ops and Administration

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

    @ Postgres Conference
    Avinash Vallarapu

    Mar 22 2019

    Use Cases

    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...

    @ Postgres Conference
    Avinash Vallarapu

    Mar 18 2019

    Ops and Administration