Blog

Unleashing PostgreSQL Performance: Exploring the Power of pg_profile

Introduction In the evolving landscape of database management, optimizing performance is paramount. For enterprises relying on PostgreSQL, a robust monitoring tool can make all the difference. Using the extension pg_profile , can be a game changer in the realm of … Read More

Mastering pgbench for Database Performance Tuning – Part Ⅱ

Introduction In the realm of database performance tuning, the pursuit of optimal throughput and responsiveness is a never-ending journey. In our previous blog , we discussed about pgbench , setting up and first run of pgbench , tips, tricks and … Read More

Guide on Testing pgEdge Platform Multi-Master Replication

Introduction: In the realm of database management, ensuring the reliability and efficiency of replication systems is crucial. pgEdge Platform’s Multi-Master Replication (MMR) offers a robust solution for maintaining continuous synchronization across multiple servers, enhancing both availability and fault tolerance. But … Read More

Mastering pgbench for Database Performance Tuning

Introduction In today’s world of databases, performance is one of the key aspects that need to be taken care-of irrespective of the size of the database. If you’re in charge of managing a PostgreSQL database, ensuring peak performance is undoubtedly … Read More

Troubleshooting PostgreSQL Replication Setup Errors with repmgr

Introduction Hey All Managing a PostgreSQL replication setup involves various challenges, especially when encountering errors during configuration. This blog post explores common errors encountered while setting up replication using repmgr, a popular replication manager for PostgreSQL. We’ll delve into the … Read More

Building PostgreSQL HA Systems with repmgr

Introduction Welcome to our latest blog post! Today, we’ll delve into the intricacies of setting up PostgreSQL High availability (HA) production cluster for a prominent client in the banking sector. Our task? Designing and implementing a robust HA solution for … Read More

FOSSASIA SUMMIT 2024

OpenSourceDB’s participation in the FOSSASIA SUMMIT 2024 was a great event. The FOSSASIA SUMMIT is a prominent event in the field of open-source software and technology. FOSSASIA, which stands for Free and Open-Source Software Asia, is an organization committed to fostering open-source software development and … Read More

PostgreSQL Database Choices : Shared vs Separate for Microservices

In the ever-evolving realm of Microservices, one of the fundamental decisions developers face is whether to adopt a shared database model or opt for separate databases for each service. This blog aims to dissect both approaches, offering insights to help … Read More

PostgreSQL OID Datatype: Impacts and Remedies

Introduction PostgreSQL – The World’s Most Advanced Open Source Relational Database, introduced a significant change with version 12: the discontinuation of the Object Identifier (OID) datatype. This move has left many developers and database administrators pondering over its implications and … Read More

Unlocking Initial Sync for Logical Replication in AWS RDS for PostgreSQL

PostgreSQL’s logical replication is handled through publications and subscriptions. Publications define what data to replicate, while subscriptions specify which server receives the updates. Initial synchronization ensures the subscriber has all the data. Common methods include: Snapshot: Copies all data at … Read More