Avinash Vallarapu

Moving away from Oracle or SQL Server is rarely just a database migration. The database is tied to applications, data models, integrations, operational processes, and years of database-specific decisions.

A multi-tenant SaaS platform of a FinTech company ran on Oracle. 800 TB of it, holding the production data of more than 6,000 customer organisations. Some of those customers were rows in shared tables. Others had schemas of their own, provisioned dynamically as the customer was onboarded. A...

There is a category of PostgreSQL performance work that costs nothing but attention - features already in the database, already free, that most clusters never switch on or never tune. This is not about buying a bigger instance or re-architecting anything. It is about the parameters you usually...

Scaling PostgreSQL reliably is less about a single “magic setting” and more about designing the whole platform including connections, configuration, replication, failover automation, and application routing, so it behaves predictably under real load and real failures. In this 3-hour, lab-driven...

Large migrations fail when they’re treated as one big project instead of a repeatable process. In this talk, I’ll walk through a case study where we migrated 155 SQL Server databases to PostgreSQL in two months for a leading healthcare organization, covering about 200 TB of data, 100K+ tables,...

With an increased adoption of PostgreSQL on DBaaS, developers are observed to be deploying their PostgreSQL databases and missing some of the key aspects. Especially while migrating from Oracle or other databases to PostgreSQL, Cloud vendors sell DBaaS much more than their capabilities.

PostgreSQL implements MVCC in a slightly different way when compared to databases like Oracle, MySQL, and others. In PostgreSQL, you'll see a different method for managing UNDO, which requires a cleanup concept called vacuum. It is now important for PostgreSQL admins/DevOps to understand the...

This tutorial is focused on teaching PostgreSQL to professionals who are already experienced with Oracle or MySQL. As we discuss from the basics, even a beginner may adapt the concepts easily.Here are the main points covered in this tutorial:Brief history of PostgreSQL and its featuresPostgreSQL...

This talk will cover simplifying some of the major complexities while performing migrations from Oracle to PostgreSQL. The following topics will be covered in detail, alongside a demo and a detailed explanation.Converting sysdate from Oracle to PostgreSQL. Among a variety of options available in...

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.

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.

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

"I migrated from a proprietary database software to PostgreSQL. I am curious to know whether I can get the same features I used to have in the proprietary database software."

PostgreSQL is an advanced open source database that is completely community driven. Continuous development and performance improvements, while maintaining a secondary focus on Oracle compatibility, gave PostgreSQL a great market penetration. When a database server is deployed in production, we...

Learn how to monitor PostgreSQL using Percona Monitoring and Management (PMM) so that you can:* gain greater visibility of performance and bottlenecks PostgreSQL* Consolidate your PostgreSQL servers into the same monitoring platform you already use for MySQL and MongoDB* Respond more quickly and...

PostgreSQL performance varies between different releases. Every new version comes with added features and performance improvements that help the growing adoption of PostgreSQL. All these continuous These ongoing developments and improvements drive us to plan on upgrading our PostgreSQL...

** Title : A detailed understanding of MVCC and autovacuum internals in PostgreSQL. ** * **Abstract : ** * PostgreSQL implements MVCC in a slightly different way when compared to databases like Oracle, MySQL and others.