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
Author Archives: Taraka Vuyyuru
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
Fixing Standby Slot Problems with pg_auto_failover
Dealing with failover in PostgreSQL clusters has always been tricky, but now there’s a solution: pg_auto_failover. This awesome tool makes it super easy to keep an eye on failovers and resolve the fencing issue. So, how does it work? Well, … Read More
Using pg_index_watch for PostgreSQL Indexing
Let’s delve into exploring pg_index_watch. In this instalment, I will guide you through the rationale behind its creation and explain its operational nuances. Meet pg_index_watch – a utility for automagical rebuild of bloated indexes, an absolutely handly tool designed to … Read More
PostgreSQL User Management: Best Practices & Security Nuances
PostgreSQL – The World’s Most Advanced Open Source Relational Database and stands out as a robust and feature-rich solution, offering extensive capabilities for user management. Effective user management is important for ensuring data security, integrity, and accessibility within the platform. … Read More
Mastering PostgreSQL: Rollback to Savepoints !!
Introduction: The word “Transaction” will ring so many bells and whistles, but in this topic’s context a “Transaction” is a call to a database function or procedure that can have one or multiple DML operations like Insert, Update, or Delete. … Read More
Working with Keepalived and SELinux: Ensuring HA and Security
Introduction: In the realm of modern system administration, two paramount concerns often stand at the forefront: ensuring high availability and maintaining robust security. While high availability protocols and applications such as Keepalived have evolved to keep critical services online, SELinux, … Read More
PgCat – Connection Pooling Decoded – Part 1
Introduction PostgreSQL – The World’s Most Advanced Open Source Relational Database holds its ground as a formidable player in the Open-source Databases market. With respect to Connection scalability & Connection concentration layers, optimising connection pooling, load balancing, and replica failover … Read More
The Good Doctor – Mastering the Art of PostgreSQL Health
We’re inspired by the compelling and thought-provoking Netflix series “The Good Doctor” It follows the remarkable journey of Dr. Shaun Murphy, a young surgical resident with autism and savant syndrome. As he navigates the challenges of a prestigious hospital, Shaun’s … Read More
From Locking to Lockstar: Unveiling the enhancements in PostgreSQL 11 and 14
Understanding Locking in PostgreSQL Locking is like the security guard of databases, ensuring data integrity and preventing conflicts when multiple users access the database at the same time. In PostgreSQL, “AccessShareLock” locks were acquired on partitions and indexes before PostgreSQL … Read More