Avinash Vallarapu

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 been a Speaker at numerous PostgreSQL conferences and also written multiple books on PostgreSQL. He loves to help everybody migrate to Open Source and eliminate the clutches of vendor lock-in.

A short summary of the Year 2022 in the PostgreSQL world

We have earlier posted the summary of the year 2021 in the PostgreSQL world. On behalf of the PostgreSQL community and the team at MigOps, we wish all the readers a very Happy New Year – 2023. The year 2022 has been another great year for PostgreSQL with new features, patches to existing extensions, numerous new extensions and …

A short summary of the Year 2022 in the PostgreSQL world Read More »

A short summary of the Year 2021 in the PostgreSQL ecosystem

On behalf of the PostgreSQL community and the team at MigOps, we wish all the readers a very Happy New Year – 2022. It is no wonder that PostgreSQL is the only Open Source database with a consistent increase in its adoption every year. The Year 2021 has been another milestone in the PostgreSQL world. Every user of …

A short summary of the Year 2021 in the PostgreSQL ecosystem Read More »

Is Aurora PostgreSQL really faster and cheaper than RDS PostgreSQL – Benchmarking

This article is to help you understand that you should benchmark before choosing Aurora PostgreSQL over PostgreSQL. We have often noticed that a lot of Customers migrating from Oracle to PostgreSQL get confused between PostgreSQL and Aurora PostgreSQL. Majority of leaders and key decision makers incline towards Aurora PostgreSQL as it is often marketed as 3 times faster …

Is Aurora PostgreSQL really faster and cheaper than RDS PostgreSQL – Benchmarking Read More »

MigOps announcing the support for Babelfish on any Cloud Platform

AWS has recently announced the release of Babelfish extension that supports SQL Server TDS protocol. In order to have this extension work with PostgreSQL, it required some changes to PostgreSQL. However, the original thought of having the required hooks integrated into PostgreSQL has not been considered by the PostgreSQL Community (see the discussion here). For this reason, AWS …

MigOps announcing the support for Babelfish on any Cloud Platform Read More »

Upgrading PostgreSQL 9.6 to PostgreSQL 13

It the the time for everybody using PostgreSQL 9.6 to start planning an upgrade to the latest supported PostgreSQL version. PostgreSQL Global Development Group (PGDG) supports any major version for 5 years after its initial release. PostgreSQL 9.6 with its initial release on September 29, 2016 is about to become an unsupported version. Its final minor version will …

Upgrading PostgreSQL 9.6 to PostgreSQL 13 Read More »

How difficult is to create a database software like PostgreSQL ?

Recently on twitter, i have seen a poll by Qovery asking how hard is it to create a database like PostgreSQL. With no surprise, people mostly voted it as “Very hard”. However, the word “like” in this question is very ambiguous, as rightly said in one of the comments by Dave Cramer, who is one of the very …

How difficult is to create a database software like PostgreSQL ? Read More »

pgBackRest – The Best Postgres Backup Tool with a very active community

A reliable backup tool with an ability to perform a point in time recovery (PITR) is a usual enterprise need. Postgres includes a backup tool called pg_basebackup for full backups. It is great for a database of a few hundreds of GBs in size but currently lacks the support for parallel, incremental and differential backups. This makes it …

pgBackRest – The Best Postgres Backup Tool with a very active community Read More »

Setting up Streaming Replication in PostgreSQL 13 and Streaming Replication Internals

While migrating to PostgreSQL, some of the users may be curious about the type of replication offered by PostgreSQL. Some might want to know if they have to pay any additional enterprise license in order to achieve this requirement. This is because, a few commercial databases require a customer to take an enteprise license to setup replication. But, …

Setting up Streaming Replication in PostgreSQL 13 and Streaming Replication Internals Read More »

A Bug on Aurora PostgreSQL 12 causes Autovacuum to hang forever

Amazon recently announced the release of Aurora PostgreSQL 12. This announcement may have encouraged several customers to upgrade from their existing Aurora PostgreSQL 10.x or 11.x to Aurora PostgreSQL 12.4. The Community PostgreSQL 12 has been one of the greatest releases ever with a big list of features and performance optimizations. So, it may be fair to assume …

A Bug on Aurora PostgreSQL 12 causes Autovacuum to hang forever Read More »

Role of Foreign Data Wrappers in Migrations to PostgreSQL

Millions of databases are being migrated to PostgreSQL today. This is because of the liberal PostgreSQL license in particular that invited more contributions to PostgreSQL and eventually made it Enterprise Grade. I have presented and also blogged about some of the rich enterprise features as following, those are otherwise available for an additional cost with some commercial databases. …

Role of Foreign Data Wrappers in Migrations to PostgreSQL Read More »

Scroll to Top