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 »
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 »
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 »
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 »
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 …
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 »
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 »
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 »
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 »
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 »
