This whitepaper covers experience of database migration from Oracle to PostgreSQL made by Intelligent Converters for a large cargo delivery company. The key reason of migration was reducing cost of ...

Community driven content discussing all aspects of software development from DevOps to design patterns. The Real GCP Certified Database Engineer Exam Questions validate your ability to architect, ...

Alex Merced is the co-author of O'Reilly's "Apache Iceberg: The Definitive Guide" and a developer advocate for Dremio Change Data Capture (CDC) is the process of identifying and capturing changes made ...

Our previous blog article, “The Part of PostgreSQL We Hate the Most,” discussed the problems caused by everyone’s favorite street-strength DBMS multi-version concurrency control (MVCC) implementation.

This article was written in collaboration with Bohan Zhang and originally appeared on the OtterTune website. In this article, we’ll dive into MVCC: what it is, how PostgreSQL does it, and why it is ...

PostgreSQL semantic of temporary tables is substantially different from that of Oracle. Oracle temporary tables are permanent, so their structure is static and visible to all users, and the content is ...

If you read Part 1 of this series, you've gotten an overview of the types of metrics that can help you track the health and performance of PostgreSQL on RDS. In order to gain comprehensive insights ...